God I hope not. I have...

Jeff Moden (2/13/2013)

---

On the other hand, I don't necessarily want all of those lookup tables to group together. I'd rather have them group together with the tables they support....

I'm presenting on Saturday. I'll be...

Stats being out of date like that is only one possible cause of a spill, but yeah, that could be it. And yes, what you're seeing is SQL Server wants...

Ever is probably an over-reaction, but in general these types of naming conventions just don't make sense. How is tblInvoices easier to understand than Invoices? How is it more clear?...

Thanks for the kind words.

The differences in the tempdb usage are probably just down to the variations within the plan. As to exactly why you're getting what you're getting... I'm...

I think we're back to the Roadhouse rule set here. Be nice.

sqlfriends (2/12/2013)

---

Grant Fritchey (2/12/2013)

---

An 8gb database? Unless you're running it on a VERY tiny little drive, there's no need to do a differential. Just do a FULL on a daily...

If it's read only during the day, then the first thing I'd do is make the database a readonly database. That will eliminate all locking, which will help performance some.

There's...

devaji123 (2/12/2013)

---

Try this way, comment the create procedure line using declare give values to the parameters and run it as query and now you can check the place where you...

First question, after the upgrade, did you manually update all the statistics. Further, did you update them with a full scan? Statistcs are stored differently from one version to the...

I've been using backup compression for years across a wide range of systems, both native and third party. Compression has been extremely reliable and overall a net positive. I say...

An 8gb database? Unless you're running it on a VERY tiny little drive, there's no need to do a differential. Just do a FULL on a daily basis. In fact,...

Second vote for Gail's article.

That second query will only, ever, use a scan to retrieve data. Functions against columns in the WHERE or JOIN conditions always lead to scans.

Stored procedure tuning is the same as query tuning. You measure the performance of the procedure, in terms of time to execute, logical reads and CPU. You make modifications to...