Short answer: No.

SQL caches data from tables and query execution plans, but it doesn't cache query results.

DTA often suggests multi-column...

Look up ALTER TABLE in books online (web version: http://msdn.microsoft.com/en-us/library/ms190273%28SQL.90%29.aspx)

ALTER TABLE ... DROP CONSTRAINT ... to remove the pk

ALTER TABLE ... ADD ... to add a new column

ALTER TABLE ......

Don't trust DTA. It's...

You sure you want to disable your index rebuild jobs?

They'll be sQL agent jobs or maiontenance plans. Check with the DBA before you take any action.

Sure you can save it. It's just a view, it behaves like any other view in SQL. INSERT INTO (with a pre-created table) or SELECT ... INTO (to both create...

Only if those inserts could be minimally logged. Otherwise the...

JacekO (11/9/2009)

---

The only difference in those two modes is how long SQL Server holds on to this data, not in the data logged itself. In Simple recovery mode the log...

Don't think so, but it's heavily weighted to the lower end.

There are 15 people with...

Home, finally! Two cats are not letting me out of their sight.

Still got to configure ADSL and redo the entire wireless network. That'll teach me to change ISP while out...

Index rebuilds?

Why are you doing differential backups hourly? How often are log backups running?

The whole reason for creating multiple files (in user databases) is to spread the IO load out over multiple drives, usually because the original drive(s) are maxed out. Creating multiple...

Blame Steve. 😀 The footnotes were correctly numbered in the original word doc. There should be 3 footnotes, will go in and edit later.

ramadesai108 (11/9/2009)

---

In this case what I will have to do is to insert the records into a temp table and thru a cursor check the previous Key value with...

Try create a new column, batch-update the values, then drop the old column. Might lessen the log impact. Run checkpoints between each (since you're in simple) to mark the log...