Caesar

nuno.fbo (4/19/2016)

---

Thanks John for the advise.

As I said you this in only a short peace od SQL code we are talking about SQL code generated by a .net application and...

There are getting to be many products like this (cf Actifio). This is probably a push that DBAs will need to learn to live with. All I can...

One index per statement is the limit. You can't combine indexes in one statement.

The single exception: rebuilding a clustered index automatically rebuilds all nonclustered indexes. But then you...

If it is just one SP which was a problem before, then I have to concur with Kevin that the increase in horsepower is making blocks turn to deadlocks. ...

I seriously doubt compatibility mode will help -- from what I know, that controls not the way the queries are processed but what T-SQL statements are allowed.

If it...

If you are using SMTP to send a file, then you are dependent upon Excel itself to preserve the file for users. SQL Server can't do that, nor can...

Other thing to bear in mind is that sometimes the third party software just is the problem in itself. You have commented more than once that there is some...

Developers using implicit conversions is how I earned my director's award during a major application upgrade once. The developer mentality says that fewer queries is better and simpler activity...

We had a situation where a single procedure was generating 2 billion logical reads across a few thousand executions of a particular statement. This had a definite and palpable...

I am not even sure jumping to clustering is the right move until we have eliminated other DB-level issues. Have you compared execution plans between test and prod? Is...

pickle

Grant Fritchey (4/18/2016)

---

Piling on, don't use the Profiler GUI against production systems. It hurts performance.

If you do go to use extended events (also my advice on a 2012 forum), be...

You either have to have the rights to create computer objects in AD for the cluster and for the SQL VM, or else you must pre-create those objects. The...

AlwaysOn AGs (and traditional mirroring also) use the transaction log to replicate. Any operation that writes to the log is mirrored. Since updating statistics writes to the log, it...