Jeff Moden (6/8/2010)

---

Sandy2704 (6/8/2010)

---

On further investigating the High transacttions/sec i noticed it is due to high number of SQL Compilations/sec......It seems some of the statements don't have the Actual Plan...

sounds like the classic bin-packing problem, or a variant of it: http://en.wikipedia.org/wiki/Bin_packing_problem

See here for some SQL Server specific goodness. Note there are multiple parts to this series,...

Do not do varchar(2) for state. It is 2 and only 2 characters, so char(2) is more efficient. I would also use this as the actual identifier for...

I would not worry about fragmentation on any table under 1000 pages in size.

Replication is a VERY complex topic. I highly recommend you get a professional to help you out sujeet. There are MANY ways you can go astray here.

Jeff, can you please try the sample you have where the row-number-diff code falls off a cliff with the following changes: 1) temp table instead of table variable and...

I highly recommend you reference Books Online. A WONDERFUL resource.

The missing indexes engine (and Database Tuning Advisor) will create a bunch of BAD indexes if you allow it. Massive amounts of included columns, overlaps, etc. Your best...

I am submitting a presentation for PASS this fall titled "Death by UDF". 😎 I will be VERY disappointed if it isn't accepted! I have a TON...

For day-specific values I have for years helped clients refactor their report queries to completely eliminate the need for a time table altogether. Properly formated integers can be used...

cgreathouse (5/30/2010)

---

Well, this was working very well for a while (almost 2 months!). However I hit the potential problem that was mentioned earlier with needing to adjust the range....

I too am a consultant that makes very good money primarily off of companies that don't have DBAs and/or don't train developers in good database application design/development. But I...

Steve F. (5/26/2010)

---

I updated the statistics just to be sure, and it didn't change anything.

It does use the CI if I hardcode the date instead of using a variable. But,...

Your signature says you are a Junior DBA. I would have the Senior DBA investigate. 😀

Gail actually gave the best advice for this scenario - hire a professional....

PaulB-TheOneAndOnly (5/25/2010)

---

Any particular reason not to allow read-only access on production to a development side "refresh" account?

Development environment usually holds a volume-scaled-down subset of production...