Thank you for the kind words.

I don't know that I would sweat adding the additional 8 bytes. It's not that much. Yes. it'll be a little wider, but if...

You have to make a determination for hardware through a whole slew of factors. How much data do you anticipate? How many users will there be? How many transactions will...

Did you try connecting with the dedicated admin connection (DAC)? I've seen that work in similar circumstances. And yeah, I think your devs might be out to lunch on this...

I'd go right by 2012 and use 2014. The licensing costs are about the same, and the number of enhancements to 2012 functionality around things like columnstore, statistics, statistics maintenance,...

It's a little more complex than that. You also have to take into account the logical, or business, identifier for each row. This is sometimes referred to as the natural...

And, in the event of failover, async means no guarantee of intact data.

I'd take a look at extended events. You can just capture the events that exceed a certain value for run time and then have them forwarded to just about anything...

Glad to hear it was narrowed down. It sure didn't sound like a physical problem. Good luck on the fix.

Glad to hear it's proving useful. Let me know if you have questions.

One of the first, and most important resources, you've already found. SQL Server Central is one of the best places to get more learning. Not only from the forums like...

With no information, I'm with Lynn. It's impossible to say what you need to do to improve performance.

But, whatever other forum you were on is partly correct. A view, a...

In terms of a "backup" as defined by SQL Server backups, no.

But, as has already been pointed out, there are a number of mechanisms for scripting out the procedures. Might...

If it's waiting on the log, you need to look to contention within your I/O system. Can you separate your log and data onto different disks and disk controllers? Can...

Interesting. Glad you fixed it. Sorry I didn't have anything better to offer.

One generic index should be best. If you had created multiple indexes, all with the same key values, you might not see them used even in the queries that suggested...