I'm not aware of a change like you're describing. Microsoft always publishes a "what's new" article on each version. Look through there. Do you mean the new verbose...

Stats, no so much. Comments, tons.

The key to understand how Microsoft develops and releases SQL Server in this modern age is Azure SQL Database. With a few exceptions, all the...

Good news. You can get nonclustered index use as long as the INCLUDE list contains the columns you're using in the CHOOSE command in the SELECT clause. Blog post will...

Already part way into testing. With a clustered index, and CHOOSE in the SELECT, no affect on performance whatsoever. Working on the next bit now.

Usually, I'll start with the lecture and then provide an alternative. Today, let's mix things up and start with the alternative. Check out Gail's blog post on catch-all queries....

• This reply was modified 5 years, 11 months ago by Grant Fritchey.

Oops. Wrong window.

• This reply was modified 5 years, 11 months ago by Grant Fritchey.
• This reply was modified 5 years, 11 months ago by Grant Fritchey.

Personally, I'd lean towards using a unicode column and store the data as needed. I mean, what happens when you add German, Swahili and Sanskrit? Translate or format on the...

It makes sense that the columnstore index is going to get used for queries that are moving large chunks of data. That's pretty much why they exist. If testing shows...

Very happy to help out any time we can. We sure try to be friendly & helpful here (doesn't always work, but that's what we aim for).

So yes, focus on...

I went ahead and hit the unspam. Let's see what others think. As I said, I could be wrong. More than willing to entertain the possibility (especially since it happens...

What were you going for then? This sure looked promotional. Although, maybe I'm wrong and the Thread Denizens can correct...

Assuming @scdecade can see this, that's so clearly spam. I marked it as such. If you'd like to explain why you think posting about a wod software you're selling or...

You could capture the update events using Extended Events. If there's a specified stored procedure used to update the table, you can use rpc_completed and filter for the procedure name...

Not a problem. Happy to help.

Don't mess with the formatting in the data storage. Let it store the raw number as is, decimal (18,2) as you defined. Then, format the results in the client or...