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

The one thing to keep in mind when setting up any backup plan is the restore process. Because, after all, the backup is not the most important part, the restore...

Since you're seeing intermittent behavior, I would suggest looking for resource contention and blocking. Next time it's running slow, run a query against sys.dm_exec_requests to see what the process is...

And the indexes have to be selective enough to be useful for a seek or you'll get scans. Same things apply to non-clustered indexes too.

For lots more detail on query...

Once. Had an app that was freaked that they were going to run out of numbers so we seeded them to max negative value so that they could increment all...

I wasn't aware that SQL Server on it's own EVER sent anything to the DBA proactively. All monitoring has to be built or bought.