Cool. Keep an eye on it though. We eliminated recompiles using this method, but, if I recall correctly, we were seeing a few more scans and a few less seeks.

Single user mode will take the first connection that comes along.

We usually try to set servers to restricted user mode. That way, only people with admin privileges can connect.

You...

One way you can do this, and it's a bit problematic let me say up front, is to do something like this (p-code):

WHERE... 1 = CASE WHEN (ColA IS NULL)...

Too true. You're right. I keep forgetting those things are in there.

To determine what's happening with the system, yes, you use Perfomance Monitor. For a detailed look inside the databases, to get individual query performance and behavior, then you use a...

Or, write all your code in a syntax checking tool like Visual Studio Team System Database Edition. I can't even save a script with bad syntax without getting an alert...

Yet another option is to look at the execution plans. sys.dm_exec_cached_plans has a column usecounts that shows how many times a plan has been used. This won't be perfect because...

And do a search on the site here. There are a bunch of useful articles and scripts on this topic.

1. Answered

2. It depends on the database recovery mode. If it's in simple recovery, there's nothing for you to do because the log is being flushed of all committed transactions...

You can't delete multiple tables at once. Each table will get deleted individually. However, you can use a select statement and joins to determine the data to be deleted. This...

You have to log in to your work network, usually through a Virtual Private Network (VPN) connection. Once you're connected to your work network, you access the server the same...

I've only started testing filestream but, other than what Gail has already outlined, there are no other restrictions on columns in the table. That's a big part of the idea...

Although, with the ordered guid introduced in 2005, you can get a lot less rearrangement if you put the guid into a clustered index. It's still a bit wide. There's...

Another vote for jumpstarttv. I did a bunch of work for Andy on a series of videos introducing execution plan concepts. There are going to over 500 videos there by...

NPR did a report on it several weeks ago. According to the report the show has a pretty firm basis in reality, but instead of a few people in one...