Excellent. Thanks for reporting back what worked.

It's a general rule that you should have a clustered index on every table (there are exceptions and exceptions to the exceptions). For detailed discussion of why this is so,...

Yes, that's true. It won't help you bury the bodies. In fact, it usually digs them up, like a dog. Traitors!

Sounds like it could be parameter sniffing. Check the execution plans to see if they're changing between the non-parameratized values and the parameratized values. You can try a couple of...

And, deadlocks are an error that can be captured with a TRY/CATCH statement in TSQL. You can try resubmitting the query a certain number of times before you finally give...

The proc cache is your bestest buddy. Why on earth do you want it cleared out all the time? What problem are you trying to solve?

Gail's 100% on the money here.

If you just look at the differences you can see why. A view is simply a select statement kept around in a way that sort...

Just to take a slightly contrarian point of view.

We did a lot of testing and found, depending on the number of columns and the type of data in a table,...

Shiraz (6/23/2008)

---

I think what Brad is saying is ok for small companies where there is one or two DBA's, but most times its not a good idea with large companies...

I get into work at 7AM. That gives me a good hour and a half before other people start coming in. It's the only way I know to get a...

Table variables have locks on them too...

You can... But it could lead to problems. You just have to use a table hint to control the locking mechanism.

UPDATE dbo.Mytable

WITH (ROWLOCK)

SET MyCol= 'SomeValue'

...

Be VERY careful doing stuff like...

FYI, this is a repost of another discussion going through the same perambulations over here.

http://www.sqlservercentral.com/Forums/Topic520048-338-1.aspx

Do you have to have a title? Grand-High-Worshipful-Poobah-and-Support?

Seriously it sounds like you're the "IT Guy." I did that for a time. I wrote WordPerfect macros, designed databases, ran networks, punched...

It's just a straight-forward cost/benefit analysis along with risk and mitigation. Do you need the new functionality or is it nice to have? You need it. How big is the...