djj (9/29/2014)

---

They hire me to be a DBA and then they do not take my suggestions.

I tell them they should only store a standardized value. A prime example of...

Compile time for the plan is stored with the plan itself. If you look at the graphical operator it can be seen in the first operation of the plan (usually...

A two minute restore for logs is kind of long unless you just have tons of transactions. There's no really effective ways to speed up restores. I have an article...

I'm on my phone, so I can't look at the plans and this will be short.

Because we have two different servers with different memory, I would focus there....

No

You can just create that same schema in the next database.

And roles have very little, if anything, to do with performance. They're mainly about access and availability and functionality.

A checklist for database design? System maintenance? Query Tuning? Best practices for high availability? ORM implementation?

There's a lot to this job. There are no places where you can just get...

Excellent point.

If you want to do the second thing, you'll need to build that as a string and then execute the string.

DECLARE @ExecProc AS VARCHAR(75) --or something much bigger, depending

SET @ExecProc...

You can see some long running queries in the system_health extended event session. It might show you where you had some issues. It might not, but it's something.

There's nothing that Red Gate does that will capture this information. The one place I know you can get it without any changes to your system is the system_health extended...

100% agreement. With few exceptions, every table should have a clustered index. Selecting that index is actually part of designing the database. The one consideration I would add on top...

If you really don't want to learn extended events (and I can't think of a good reason why not) and you still want to see what queries have been doing...

Phil Parkin (9/25/2014)

---

Grant Fritchey (9/25/2014)

---

This is exactly why you should be using source control to modify all your database objects, just as developers use it to modify code. Unless you...