"..This was my biggest year, where I flew over 140,000 miles and spent nearly 90 nights away from home.."

That sounds like an opportunity to read more than handful of...

Hardly, though we do have Uber helicopters, so maybe we have flying cars.

They can play tricks in the engine to use less space in a way you cannot with row storage. The index itself can be smaller than a rowstore index.

Columnstore would work by tokenizing and limiting the repetition of values. A simple example is gender. Say we have 3 values (M, F, Other). If we had these stored as...

Thanks for the response. I agree SSMS isn't great, but I know where the sharp edges are and it works well. ADS feels limited to me, and semi-functional. It works...

Nothing to do with the question, nor the fact that it is Christmas:

Does anyone else find that the "Stay signed in" option has ceased to function over the past...

Merry Christmas, everyone. Hope you enjoyed it

Merry Christmas to everyone, Happy Holidays, and congrats to the top 3.

I'll get prizes out after Christmas.

I think Agent works really well in many cases. There are enterprise schedulers, and most cost money because they handle complex things. I agree, it's generally worked very well for...

Use sp_helprevlogin

https://support.microsoft.com/en-us/help/918992/how-to-transfer-logins-and-passwords-between-instances-of-sql-server

technically, I would think that you would work a half day and then knock off, so if you normally start at 8 am your time, you would knock...

This actually isn't quite right unless you are living in Arizona.  But I think you live in Colorado.  In that case, the proper time zone is "Mountain Standard Time". ...

Strangely, I tried the code and it reported a syntax error... the only thing that didn't was the Convert statement, which didn't give the right time. A niggle, I...

The identity is not necessarily the max value. I can use identity_insert or dbcc checkident(reseed) and end up with different values. The max in the table might be far different...

Are you looking for the max value in a table or are you looking for the last value used? (or next one needed)?

These are different things. The identity doesn't ensure...

• This reply was modified 6 years, 3 months ago by Steve Jones - SSC Editor.