DECLARE @sDBName SysName

SET @sDBName=''

WHILE @sDBName IS NOT NULL

BEGIN

SELECT @sDBName = MIN(Name)

FROMMaster.dbo.sysdatabases

WHEREName>@sDBName

AND Name NOT IN ('Master','Model','MSDB','TEMPDB','DISTRIBUTION')

AND DATABASEPROPERTY(Name,'IsTruncLog')=0

IF @sDBName IS NOT NULL

exec sp_dboption @sDBName,'trunc. log on chkpt.',true

END

I've just tested this against a 50,000 record table with record length 4468 and a none unique varchar column that is part of a compound index.

In both cases the execution...

This recent article http://www.sqlservercentral.com/columnists/jBulinckx/indexedviewswithouterjoins.asp showed how to do outer joins with and indexed view.

If you replace your SELECT * statement with explicit column names do you get any improvement in...

If you watch the locks using Enterprise Manager while your program is running do you seen anything significant?

Are the long running inserts being blocked by the shorter ones?

Does your logging...

I would be extremely suprised to find that Windows defrag and Diskeeper were the same product.

No-one would willingly buy a product that was as bad as Windows defrag.

I think the problem is that as you gain seniority you get promoted and assigned to lead teams without anyone giving any advice or training on how to go about...

The built-in Windows 2000 defrag is absolutely rubbish. You need at least 15% free disk-space to do a defrag and even if you have the tool will tell you...

I too have misgivings about the CLR. I've read somewhere that there are people in Microsoft who have misgivings. Something to do with a badly written piece of...

Nice debate Joe.

Short circuiting has been true of in every SQL you know about. I didn't know but I do now. Perhaps I should buy some of your...

OK, so EXISTS short circuits. Great. One less thing to worry about.

I would hardly call using stuff that has been in MS SQL Server since version 7 (and...

sp_help 'your table name here'

Brings back all sorts of information on the table including the primary key.

Joe, does EXISTS short out SELECT * FROM..?

If you are programming for SQL Server then why ignore valid SQL statements?

If I am going to develop for cross platform compatibility then...

If you are going to do it Joe's way then perhaps

UPDATE Poz

SET tip = 'k'

WHERE EXISTS

(SELECT TOP 1 J.con

...

Well, the field itself will simply reject any date that isn't in the correct format but if you had a stored procedure to do some bespoke error handling you could...

Yes, continuous push replication. Only the tables are replicated.

I solved the problem by removing the triggers but the idea that the inserted table contains NULL values in the field...