Fine, but where is it coming from? It's not a part of the query as outlined, so is that thing...

Text plans... blech!

Anyway, like I said, you're getting a scan because of the function:

[SCM].[MEAS_VALUE]<>-1 AND [SCM].[COL3]&239=0

The other two scans are not as obvious. For example, this one:

[M].[COL4]>=0 OR [M].[COL4]=-2.01019e+009

It's...

I'd love to see the execution plans, but this little critter is going to prevent index use:

and ((c.col6 & 0XOEF) =0)

That's going to lead to scans, all the time every...

If you have an account that has access to all the file shares that your backups are going to, you could use that account to run a powershell or batch...

Never heard of it. But my response to one these is always the same, "Cool. Awesome. Can you show me a recovery to a point in time?"

If they can do...

The basic costs break down on the parsing of the query and/or getting the object id of the procedure and then retrieving those from cache by a search on the...

You said variables several times. Be sure to differentiate between variables and parameters. A parameter, defined with the stored procedure or in a parameterized query, can be sampled, or sniffed,...

You can gather information on deadlocks on SQL Server 2008 and better without ever setting a trace flag. Just use the system_health extended event session that is running automatically on...

I'd suggest breaking up your index rebuilds, only do a few at a time in small chunks. And don't swap the recovery model to bulk-logged. If you need to restore...

It all has to do with permissions. I suspect your SQL Server instances are running under local accounts instead of under networked accounts. You'll have issues trying to communicate across...

ASPState is difficult to deal with. Generally, isolating it as much as possible is the best bet. Better bet, don't use it for state management of your ASP pages. Storing...

SQLRNNR (3/12/2014)

---

Lynn Pettis (3/12/2014)

---

SQLRNNR (3/12/2014)

---

Lynn Pettis (3/12/2014)

---

william.rees.howells (3/12/2014)

---

That is correct. I run it every time I run the query. The query speeds only go back to normal once I drop...

If you're on SQL Server 2012, then the answer is the Distributed Replay tool. With that you can simulate load on the system. You'll have to build the load yourself,...

Try modifying the system database called model to have the security settings you want as outlined above. Then, when you create a new database, what's in model is what gets...

Well, thinking about it some more, you can turn on auditing on the blob stores where the VM files are located. Set that to verbose and see what the heck...