|
|
|
March 2003 April 2003 May 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 |
Connect from sql query via IP adress - is i possible? Posted by Just D. at 7/31/2004 12:23:11 PM Does anybody really know is it possible? We don't want to create a linked
database, but we need to make some steps on the remote database, gather some
data and then send this data to our main server via IP connection, setting
the connection every time when the remote server wants to transfer the ...more >>
local administrator access for DBA's - is this required? Posted by Miles at 7/30/2004 8:45:52 PM Hi
I need to manage a SQL cluster, monitor database and O.S performance and
apply database patches. Do I require local admin rights for this? If not
what is the workaround please?
Problem is, my organisation is very reluctant to grant local admin rights.
Is there a Microsoft article on th...more >>
database views Posted by Just D. at 7/30/2004 11:44:25 AM Hi All,
Who knows how the database views work at the lowest level? If we have a view
with a very long query and retrieve data from this view does it retrieve
data from all tables only when we send a query to this view, or always when
the relative data is updated this view should be updated by ...more >>
Performance Issues w/INSERT, UPDATE, DELETE Posted by mkerrigan NO[at]SPAM ktoys.com at 7/30/2004 8:31:48 AM Is there any advantage to moving simple INSERT, UPDATE, or DELETE
statements to stored procedures rather than just putting them in the
application code? Is it better performance-wise or does it make a
difference? The application in question is a ColdFusion Web
application....more >>
A complex query Posted by Roy at 7/29/2004 7:08:50 PM Hi All,
I need to do do a select statement and one of the columns will be a
conditional statement.
select x, y, "T" =
case acctnum
when
where not exists
(select a from tblG where tblG.acctnum =
acctnum)
then 'N/A'
when
wh...more >>
How to truncate all tables in a database? Posted by James at 7/28/2004 2:55:21 PM
...more >>
Query Performance Posted by MP at 7/26/2004 10:57:26 PM How do I increase the performance of a SELECT query with GROUP BY clause?
...more >>
Combining 2 Select with Join statements into one result Posted by cmo63126 NO[at]SPAM yahoo.com at 7/26/2004 1:49:59 PM There has to be a simple answer. How can I combine Results(1) with
Results(2) in the two statements below? Thanks!
Statement 1.)
SELECT tbTestDates.*, tbOfficeClosures.DateClosed FROM tbTestDates
LEFT JOIN tbOfficeClosures ON
tbOfficeClosures.DateClosed = tbTestDates.EventDate
WHERE tbTestD...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
MAX() and DATEDIFF() question Posted by BCM at 7/26/2004 8:01:39 AM I've written some software that listens to meters on a specified port and
writes XML files when any of those meters "speak." There are some 200 of
them, and each is programmed to "speak" at 10 second intervals, so there's a
fair amount of traffic.
Now what I've been asked to do is write a reco...more >>
Size of SQLServer databases with indices Posted by barthome1 NO[at]SPAM comcast.net at 7/23/2004 7:47:28 AM Hello,
I am starting to examine using SQLServer instead of Oracle. I went
through the SQLServer import utility to copy tables from Oracle into
SQLServer. I then checked the size of the database.
I then started to specify indices for the tables. I did not see the
database file size grow a...more >>
What's wrong ? Posted by mmmc_reptail NO[at]SPAM hotmail.com at 7/23/2004 1:00:21 AM Hi,
I'm totally stuck and confused as to why my simple enough query
doesn't work.
Here's the query:
SELECT pl.PlanTable, pl.Mode, pl.ID, pl.NE, tbl0.*
FROM PLANDB.dbo.plan_info pinfo, PLANDB.dbo.plan_list pl,
PLANDB.dbo.parameters tbl0
WHERE pinfo.PlanName = 'passi'
AND pinfo.planId ...more >>
EXEC Command with 'EXEC' as parameter fires twice Posted by mark at 7/22/2004 10:34:52 PM I created the procedure below in a SQLServer 2000 environment to export a
SQL query to a log file. The procedure exports all of the records correctly
but the procedure is executing 'someproc' twice.
Any help will be much appreciated.
Thanks,
Mark
CREATE PROCEDURE sp_queryToFile
@...more >>
Can't remove multiple instances of SQL Server 2000 Posted by Daryl Foster at 7/22/2004 2:39:33 PM I have had an installation fail twice now. The first time, the setup process
went all the way through OK but than hung showing the message:
'Setup is starting the server and installing your chosen configuration'
I have had to kill the setup process after a while and try again. The second
ins...more >>
application roles Posted by Jeigh at 7/22/2004 10:56:11 AM I want to write a T-SQL Script that will run sp_setapprole ONLY IF an
application role is currently not active.
Can anyone please advise me of how I can detect wether or not I'm currently
using an application role?
Thanks,
-- Jason
...more >>
Incorrect Syntax Posted by GitarJake at 7/19/2004 3:27:42 PM Hello all,
Newbie here.
SQL 2000, Windows 2000
I'm trying to alter tables in my SQL DB using statements like the following:
/* AD_GROUPS */
alter table AD_GROUPS alter column AD_GROUP_NAME nvarchar(64)not null
go
/* ARTICLES */
alter table ARTICLES add column CONTENTTYPE_REF int nu...more >>
syncronising SQL tables between seperate servers Posted by John D at 7/16/2004 12:44:01 PM Does anyone have any idea how to syncronise two SQL identical tables across
a network, between servers?
We want to run our website from a SQL tables on the same server, but set up
so that if the main SQL tables across the network change, or the tables on
the web server change, the two seperate...more >>
problem with migrating DTS package from file to server Posted by Andrew Baker at 7/15/2004 1:34:34 PM Sorry about the cross post, but I need an answer by the end of the week.
I am trying to migrate a DTS from a file into the server. I dont know what
user name or password will be on the target PC, so I cant specify them, but
the integrated security gives the user ability to connect. On my
dev...more >>
Date Format Question. Posted by Manuel Canas at 7/14/2004 6:33:03 AM Hi there,
in a select statement like SELECT date FROM test. the result that I get is
the date with many zeros to the right of the date. How can I change the
format of the date to let's say DateFormat Jan-01-01 and get rid of the
zeros at the left?
Thanks for your help
Manny.
...more >>
T-SQL Question.... Posted by BCM at 7/12/2004 3:01:30 PM I am a relative newbie with T-Sql and am having a bear of a time with the
few lines of code below. I need to resolve the @meter variable on the fly
(it's the name of a table), but I seem to be syntactically screwing
something up. If you look further below, you'll see that I tried using EXEC
too,...more >>
SQL Server 2000 newbie Posted by GD at 7/7/2004 7:11:05 PM Hi,
I've downloaded SQL Server 2000 Desktop edition & installed it - however I
don't know where it is or how I can open the program - shudn't it install
some icons on the start menu like all installations?
TIA
...more >>
Why doesn't left join work but *= does? Posted by ambradnum NO[at]SPAM hotmail.com at 7/7/2004 9:11:42 AM I have tried to join two tables with a left join as follows:
SELECT a.*
FROM a LEFT JOIN b ON a.someid = b.someid
WHERE a.flda = 6
AND (b.fldb = 7 or b.fldb is null)
I get incorrect results.
However, if I rewrite it as follows, it works:
SELECT a.*
FROM a, b
WHERE a.someid *= b.someid...more >>
Log shipping: servers won't see each other Posted by fdsa NO[at]SPAM spam.la at 7/7/2004 8:05:15 AM We are trying to setup log shipping.
Our configuration is as follows:
2 Servers, S01 and S02, in the same domain D
There are several instances on both servers, shipping is supposed to occur
from S01\instance1 to S02\instance1_bak.
We have created a linked server connection from S01\instan...more >>
SQL Server Conferences in the next year ? Posted by bob NO[at]SPAM lifeasbob.com at 7/7/2004 6:33:18 AM A little less technical, fun post ?
Looking for comments on the best SQL Server specific conferences to
attend in the next year.
I'd like to find which conference Microsoft will launch Yukon at and
hit that one, but don't know for sure...
Thanks
Bob...more >>
Can't copy database Posted by google NO[at]SPAM erb.com at 7/7/2004 2:17:35 AM I am trying to copy a database from a server to a laptop.
My server is a Windows 2000 Server running SQL Server 2000 Standard
Edition. My laptop is running Windows XP Pro and SQL Server 2000
Personal Edition.
In Enterprise Manager I use the Copy Database Wizard, I select my
server as the s...more >>
SQL Server 2000 - Which version do I need? Posted by GD at 7/3/2004 3:57:41 PM Which version should I download ?
I am currently running dual boot system Win2000 / Win XP Pro (Use Pro
mainly) - I have seen many diff versions available on the MS website, but
i'm unsure which is best for me.
I aim to use it for developing alongside ASP & ASP.net
Regards
...more >>
Live Data - How do you see it ? Posted by Jon Delano at 7/1/2004 2:32:14 PM Hello
I'm working on a project that will be used my multiple users.
I need to have a grid on a form that displays data in a "working" table ...
each person will be making edits.
What I'd like is to have a connection to this table that is "live" ..
meaning any changes are automatically displ...more >>
Retrieve SQL Job Posted by DTJ at 7/1/2004 3:52:00 AM Our DBA is out of town. She has a job named Optimizations job for DB
Maintenance Plan 'Re-Index'. This job is not enabled.
The only step of the job is EXECUTE master.dbo.xp_sqlmaint N'-PlanID
(GUID) -Write History -Rebldldx 10.
How do I determine what PlanID ... refers to? I assume there ...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |