Redgate software makes a tool called SQL Compare that will compare between SVN (TFS, Git, etc.) directly and your database, or a set of .SQL files and the database (or...

You might find that you identify certain tables or certain indexes that need more frequent statistics updates. When you do, you might want to schedule updates on those specific objects,...

Yeah, that's pretty much it.

Thanks.

I should add though, that queries like this can be somewhat expensive. I wouldn't recommend running them under load on a production system.

Look for A/D groups that do have access that he belongs to.

if you really need to know exactly how many queries are run against the database, you need to set that up ahead of time. With SQL Server 2012 or better,...

Alan.B (2/23/2016)

---

I don't know if anyone is aware of this but I noticed Dwain Camps hadn't posted anything in awhile so I checked his blog (dwaincsql.com), simple-talk, twitter, linkedin... then...

This will get you started. You just have to look at the right properties to only see the indexes

WITH XMLNAMESPACES(DEFAULT N'http://schemas.microsoft.com/sqlserver/2004/07/showplan'),

QueryPlans AS

(

SELECT RelOp.pln.value(N'@PhysicalOp', N'varchar(50)') AS OperatorName,

RelOp.pln.value(N'@NodeId',N'integer') AS NodeId,

RelOp.pln.value(N'@EstimateCPU', N'decimal(10,9)') AS...

Transactions and transaction playback, log shipping, are not the same as a backup, a page-by-page copy of the database. The processes of restore are different. The at rest copy of...

Pretty much what Luis said. It's entirely possible to learn about 6 months worth of DBA knowledge and then repeat those 6 months for 10 years. I've interviewed a lot...

I am absolutely anti-certification. However, that said, if you're going for the certification, I would not recommend getting the 2008 cert. Go for the 2014 cert or wait for the...

VPlex I believe copies stuff at the page level? If so, yeah, it's likely to replicate corruption.

Log shipping (or, since we're in the 2014 group, Availability Groups, a much better...

Is recovery full? If so, as much as I dislike this, change it to simple. If you're dumping the logs you can't do a full recovery anyway. Might as well...

You do know that NOLOCK leads to extra or missing rows if you're experiencing scans, right?

You're getting inconsistent behavior because you're not providing the schema. That's the right way to do things. It might mean you need to go back and edit your code, but...