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

Basically you need to understand the business requirements and then validate that the data structure will meet them. It's conceptually insanely simple. It's a ton of work in practice.

It depends on where you're measuring from. From the client, you have to include the round trip time for the query to leave app, go to the server, get processed,...