You can set a timeout on either a cmdExec step in a job or a cmdExec task in DTS. hth
Hi Shaun, Sadly enough my post sums up my real world experience. On my current project half the tables do not have Primary Keys, a lot of stored...
You are right Bambola. I was confused with temporary tables that are created outside stored procedures, through a batch in QA or something similar,...
Except doing all this after the fact checking, you might also want to implement more stingent development procedures and permissions. The fact that...
Windows 2000 will see the hyperthreaded CPUs as 2 different CPUs. This should change in Windows 2003, as that is designed with hyper threading in...
Hi, I ran some tests with SET NOCOUNT ON and OFF on my local machine (see script below) and what took 15,490 milliseconds with NOCOUNT OFF, took...
Hi Gaurav, Just to set some terminology straight first: distibuted partitioned views are views that combine tables on multiple servers, that is what...
Hi Bambola, Using * or NULL or a column name or even a constant (0, 1 etc) has the same effect in a Select clause that is used inside an Exists. It...
Chappy,<br /><br />select UserID from UserTable where not exists (select * from SelectTable where UserID >= FirstUserID and UserID <=...
Read this excellent article by SQL Server MVP Itzik Ben-Gan: http://www.sqlmag.com/Articles/Index.cfm?ArticleID=23511 It is about a very similar...
Thanks for the compliments <img src='/community/emoticons/emotion-1.gif' alt=':)' /><br /><br />I have included Bambola's tip in the script (and made...
If you run SQL Server on it's own machine without any other applications running on it, leave the memory settings on dynamically configured memory...
Argyle, You can't force parallel execution with the MAXDOP option, you can only limit the number of processors that will be considered for a...
This script gives a list of all the columns in the database and the number of distinct values in them. This can be very useful if you take over a...
Chappy, I have worked on something like your 3rd case before and I designed the following method: - Run a profiler trace against the database during...
If you use INNER JOINs only, using JOINs or putting your statements in the WHERE clause will yield the same results. It is preferrable to use the...
As you say that other connections have problems trying to connect to the server, not the database I suspect that the report is actually generating...
I experimented a bit and ran a transaction with waitfor in one QA window and fn_get_sql/DBCC INPUTBUFFER in the other, so that the transactionw as...
I totally agree with that. If you have a table that has mostly single row inserts/updates/selects having the clustered index on a unique column is a...
All errors with severity 11 or higher (and errors with a severity of 10 or lower are considered informational messages) will _always_ be raised to...
Separate names with a comma.
