What is running in an automated fashion every 30 minutes on the system? 3rd party backup software? Something? Kevin has a pretty good order for trying to figure out what's...

Nothing is ever 100%, but no, in most cases you're only going to see some additional I/O, CPU & memory during a stats update. It doesn't put locks on the...

Jeff Moden (2/24/2016)

---

SQLRNNR (2/24/2016)

---

GilaMonster (2/24/2016)

---

SQLRNNR (2/24/2016)

---

GilaMonster (2/24/2016)

---

jasona.work (2/24/2016)

---

http://www.sqlservercentral.com/Forums/Topic1763775-3412-1.aspx

/Me leans back, grabs bucket of popcorn

Sure sounds like Gail answered the original question, yet for some reason the OP decided to focus...

You're not actually referencing partitions. Here's a good article on setting [/url]up sliding window partitions, which is almost what you're describing. The thing about partitions and partitioning is, that you're...

I've been speaking publicly for 10 years and I still get nervous and, depending on who is in the audience, I can be intimidated. However, you just keep going. Remember...

Good plan. And, you...

It's not magic. It has to be something. Either a SQL login that he has the password for, or he's in a group that's in a group that has access....

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