Forum Replies Created
Viewing 15 posts - 286 through 300 (of 530 total)
-
RE: Question of the Day for 23 Jun 2005
Hmm.. Mike C. First out. It said NOT LIKE, but even though, the query can use indices.
Second: 'LIKE '%george' -- cannot use an...
-
RE: Bulk Copy Operations - Record Merging
Well, in his first post he actually wrote that he started BCP from his batch file...
-
RE: Bulk Copy Operations - Record Merging
How is the data moved from the staging tables?
* If you have access to osql.exe you could always check if the tables are empty.
* If you can convert your script...
-
RE: Automatically killing long running queries?
You could implement your own Auto-KILL. You could periodically check sysprocesses (or sp_who/sp_who2) to identify offending PIDs and then kills them off?
-
RE: Question of the Day for 23 Jun 2005
...and since I saw the explanation (Explanation
The EXISTS and NOT EXISTS operators are more efficient because they can often use an index whereas the NOT LIKE operation...
-
RE: Question of the Day for 23 Jun 2005
talltop: It could always be good to verify facts by yourself even if you read them in a highly prestigious place like...
-
RE: Database Diagram Empty
Hello,
Well, if the application 'uses' AWE it should be fairly simple to detect... Check the sp_configure, row: awe enabled. If AWE is not enabled then the application does not (cannot)...
-
RE: Collecting DBCC SHOWFILESTATS output from linked server
I am abit suspicious that it didn't work in the other way but whatever works is a solution
-
RE: Linked Server. Remote SMALLDATETIME becomes local DATETIME?
So far I have only tried on W2k Adv Server (fully patched, no IIS), SQL Server 2000 Enterprice Ed. SP4. 4-8 Processors. 4 GB Memory (No AWE)
-
RE: Question of the Day for 23 Jun 2005
Yepp. Talking performance is not like talking weather... Any performance question requires indepth knowledge about almost everything in the scenario that one should try to solve.
With this I am of course not...
-
RE: Question of the Day for 23 Jun 2005
Hehe, well. Not that I would recommend it but...
SELECT myData.CustomerID, myData.ContactName
FROM Northwind.dbo.Customers AS myData
WHERE ContactName NOT LIKE '%SON'
(Table 'Customers'. Scan count 1, logical reads 4, physical reads 0, read-ahead reads...
-
RE: Question of the Day for 23 Jun 2005
I would say this question needs a little more description.
How can you compare these two operators? Does anyone has any good example?
From the reference included in the answer:
Negative...
-
RE: How to debug a SP in Client/Server
Or do a trace... Tracing SP:StmtStarting and SP:StmtCompleted gives quite a good understanding what was being done in the SP...
Tracing puts a little load on the server, but then again,...
-
RE: bcp queryout to xls
Yepp. I guess it takes a few CPU cycles more but I wouldn't worry abou those. Maybe annoying if you have many columns though. Then maybe a SELECT from SYSCOLUMNS and the use...
-
RE: SQL Server 2000 SP4
Hmm. Did you read the post by 'BJReplay RE: SQL Server 2000 SP4 Posted 6/14/2005 2:58:00 PM'?
Unless you notice any...
Viewing 15 posts - 286 through 300 (of 530 total)