davoscollective (9/23/2014)

---

You can't just take 3 TIME IO measurements and average them and say that a faster query is necessarily better than a slower one.

Sometimes it just seems like a...

Good article - writing good code with a good design is never premature, and measurements is the key.

When I do optimizations that are beyond simple good code, I try to...

For use inside a database, or even cross-database, I can absolutely see the use for synonyms (once you handle cross-database permissions, of course).

For cross-instance work, such as was presented in...

Sean Lange (9/2/2014)

---

Nadrek (9/2/2014)

---

Heaven help you if you have to debug that...

As others have said, you haven't given enough information, but you should first minimize the number of UPDATEs on bigger tables; if the FROM/JOIN clause is the same, you can...

GilaMonster (8/27/2014)

---

Which is...

Shaun Finnegan (8/13/2014)

---

Are you using SQL out of the box maintenance plans for index rebuilds? If so, to further reduce activity on your SAN, consider using Ola Hallagren's solutions....

Be aware that SQL Server 2008 R2 SP2 has two security vulnerabilities you'll need to patch after the upgrade:

MS14-044

As far as I know, newly added reports do get parent security; it's when you change it at the report level that it breaks the inheritance.

You can also cheat and set up a SQL 2012 SSRS report with a data source leading to the current data, since SQL 2012 will actually export to an .xlsx,...

And note that copy/paste coding leads to Application D using...

I think you want to read the SSC thread "Index reorg VS rebuild, round 1" first; here's my post from that thread:

"When I have a choice where, based on...

Shawn Scoville (7/15/2014)

---

Can you elaborate on the SQL Server installation at the DR Site please. I'm still not sure how to install SQL Server at the DR site before...

Here's a slightly longer set of test data.

Note that spaces are particularly interesting, as are the spelled out FLOAT limits.

Please remove the TRY_CONVERT blocks for SQL Server versions below 2012.

SELECT...

Not true - the user account used for SQL Services does not (and should not, in any...