Well, then it won't matter. If the data will ALWAYS be less than 50 characters then indexing a VARCHAR(50) or a VARCHAR(500) will be the same. It's completely dependent on...

Killing SPIDs just puts them into rollback, same as  this. I'd be more concerned about what's happening, what has changed, what's new that something that has ran for years without...

Well, the "regardless of who is connected" bit is what you've run into. There was some sort of open transaction and it got rolled back successfully. I'd just suggest changing...

That's an error from taking a database into single user mode. That shouldn't normally be a part of a restore process unless people on your server have too many permissions...

This is a very old school (and old) summary of the rules of normalization, with examples. The core concept is, a column or columns has to define what makes...

Also, there is a 900 byte max key length that you have to stay within.

The simple fact is, it's going to be harder to index 500 characters than 50 because...

The single best method is to use Extended Events to capture the call. You can get a general set of data through rpc_completed or sql_batch_completed, or you can get individual...

You've been given a gift... when most folks write a presentation, they practice it at say 20 minutes but they've included so much good stuff that it will actually...

You've been given a gift... when most folks write a presentation, they practice it at say 20 minutes but they've included so much good stuff that it will actually...

Cause the vast majority of people out there are...

Alerts based on tags. I don't know the specifics of how to do this in Idera. Last time I evaled the product, it's alerts weren't that hot.

After tons and tons of testing with partitioning, I've completely tossed it as a performance enhancement tool. You can, in exceedingly rare circumstances, see actual performance enhancement through partition elimination...

Also, the biggest pain point in upgrades from pre-2014 to post-2014 is the new cardinality estimation engine. Most queries are unaffected. Some queries benefit. A few, suffer greatly. Plan to...

I agree, temporal tables are probably a better approach than CDC. I actually was sitting here trying to remember what they were called. Ha! Old age is fun.

As to history...

Oooh, this is a HUGE topic. Posting into comments in a thread is not going to cover everything. You need to look at a completely different database design. Here's an...