Grant Fritchey (7/16/2009)

---

I don't know that I'd recommend recompiling out of hand. The execution plan using a parameter is going to sample the appropriate indexes and arrive at a generic...

Ian Scarlett (7/15/2009)

---

Absolutely... performance of the inserts should...

A spid can show as blocking itself - a 'feature' added in SQL 2005. IIRC it happens when a block of memory is latched and it blocks continued execution...

I would calculate the date you need with that math first and put it into a variable and use that. You will also need an OPTION RECOMPILE to ensure...

All of the locking and such will be automatically handled by sql server. Indexing will be key to efficient delete of the maintable rows, which will be critical to...

Where possible (which is the vast majority of the cases even if you need uniqueness across multiple machines - just use a compound key) I recommend to my clients that...

>>How I wish there was a sp_configure GO_MUCH_FASTER 1 setting to play with.

This configuration exists - and is known as hiring TheSQLGuru to give your system a performance review. ...

Depending on the size of the data, copying it all local and then doing the query could be significantly faster. This is especially true if you can restrict the...

jvElecenter (7/1/2009)

---

Hi there

I know I give few info and I am asking a lot.

We are not running big queries. There are no deadlocks.

Database is running on disk, transaction log is...

+1 to Gail's comment about zeroing out large files.

Also, you stated 10TB of SATA drives - that is going to suck for performance. SATA drives are not nearly as...

I agree with the others re IFI - if ultra-high security isn't a requirement I advise my clients to enable it.

I have had some clients on NetApp SAN's for SQL...

>> negative faith

New term - I think I may like it! Although perhaps antifaith could be better. 🙂

1) I would imagine (hope) that the optimizer would choose the 'most-compact' covering index in the case where multiple indexes cover a query.

2) DTA and the missing index subsystem really...

1) forums such as this are for targeted, short problems where people that are volunteering their time can provide a solution in a matter of minutes. What you posted...

1) IIRC, Microsoft's recommendation is to not even bother defragging tables with less than 1000 pages

2) For sizeable tables, if you don't have sufficient free space in the database of...