I stick with my first advise on this one.

Keep it simple and code regular joins.

The column level nested selects will only give you benefits if cardinality meets a treshhold.

I certainly...

How about me just routing you to Paul Randals series of sqlserver myths:

This one on checkpoints:http://www.sqlskills.com/BLOGS/PAUL/post/A-SQL-Server-DBA-myth-a-day-%281530%29-checkpoint-only-writes-pages-from-committed-transactions.aspx

pankaj.nainu1 (12/19/2010)

I am facing some problem while updating a column through trigger.

I have a table User_Records with n number of columns, one of the column is SequenceNumber. When first time...

have a look at the OUTPUT clause (new with sql2005) and how it can help you with this request.

Paul Randals article has more (and more,.. ) info on waits :http://www.sqlskills.com/BLOGS/PAUL/post/Wait-statistics-or-please-tell-me-where-it-hurts.aspx

It also refers to other great resources.

By default, put indexes on your FK columns (so they match the PK they refer to) and have the FK declared with check.

Grant published a little but great article on...

please read http://technet.microsoft.com/en-us/library/dd758814(SQL.100).aspx for more info.

ps

AFAIK SSDs no longer use read/write heads, so they won't have to be aligned ...:w00t:

Default trace typicaly has trace id 1.

Check sys.traces to figure out what kind of trace that is, what file it tries to write to, and check if you can correct...

Installed it on my laptop instance.

It took 30 minutes.

First impressions: seems to be working fine.

First startup of SQLAgent got a "Warning [1]: Possible date calculation spin for Schedule 1"....

SQLkiwi (12/18/2010)

Thanks, though the old twitter references...

Hey .. paulwhitenz also disappeared at SSC.:hehe:

Welcome SQLKiwi 😀

Keep in mind to have SSC altering your twitter refs in your articles 😉

sorry for that :Whistling: 😉

btw If these managers have some kind of awareness, they would understand you first need to test it on a DBA-only instance, before you can implement...

Are you already familiar with SQL2008.

If not, start testing it yourself !

maybe even get an upgrade course.

for your db/instance:

1) download SQL2008 upgrade advisor

2) run it against the db you want...

- Personally I don't like those column level select statements in the select clause.

Maybe the engine will even parse it into a join for you, but IMO it is a...

With regards to the beverage, I used milk and honey and that did a good job.

But I will take it into my notes.

That breaking up will indeed be needed if...