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...

Sandy2704 (5/25/2010)

---

Trasactions in our application generally range between 7 to 40 /sec......The application is not huge.....I am using a third party tool called precise i3(It gives me alert messages whenever...

Here is the Bible for this area:

http://blogs.msdn.com/bartd/archive/2006/09/09/Deadlock-Troubleshooting_2C00_-Part-1.aspx

Note there are 2 additional parts to this blog series.