I suspect that will work.

If you query sys.dm_exec_requests, you'll see that there is a pretty easy way to spot that you have blocking:

SELECTCOUNT(*)

FROMsys.dm_exec_requests AS der

WHEREder.blocking_session_id > 0;

Now all you have...

You could, but you'd be even better served by running a query against sys.dm_exec_requests and looking for blocked processes. This will work better because instead of having to execute a...

Hmm... Don't know. I thought it was already available.

Thought of one other place where I store a lot of my scripts. My blog. I put more stuff up there than anywhere else, and it's always online when I...

ScottPletcher (12/3/2012)

---

Hmm, something seems odd.

SQL should be able to easily do "simple parameterization" -- the old name, "auto-parameterization", seems clearer to me -- on that query. That is, SQL...

I have a blog post on the basic things to look at first[/url] when you're looking at an execution plan. That's where I would start.

As to the XML plans....

Yes, that's an indication that you're probably using dynamic or ad hoc queries and every single variation of the parameter values is resulting in a different execution plan. That's really,...

I'm still confused. Is that 23,000 executions of a query, or 23,000 different query plans of a query? You keep saying "plan count" and that's where my confusion lies. If...

I'm a little confused by the question. When you say "high plan count" do you mean the number of plans in cache is high? If that's right, how are you...

Start with the statistics, absolutely. That fixes the majority of issues of this type. Running sp_updatestats will give you a basic statistics update. If you're not maintaining statistics in your...

If you do need to convert the database from the *.sqb format, we have a tool available for doing that.

If you are going to restore the master, we have some...

Much better than my approach. I keep forgetting to check Extended Events for solutions to problems like these. Thanks for posting Lowell.

To do source control management easily, you will need to introduce other tools. The two primary ones are SQL Server Database Toos (SSDT) from Microsoft. These are built into Visual...

I do work for Red Gate, but was doing this before I got the job.

I keep my personal scripts in the Snippets Manager within SQL Prompt. You can add a...

Can you just build the query into the process that does the restore?

If not, you'll need to have a T-SQL statement with a TRY/CATCH that you can run, probably on...