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 6 years ago by Grant Fritchey.

Oops. Wrong window.

• This reply was modified 6 years ago by Grant Fritchey.
• This reply was modified 6 years 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...

Shared locks only affect data modification queries. They don't affect other reads, so you have to focus there. The key issue is ensuring that your queries are written well to...

Look up READ COMMITTED SNAPSHOT. That will be a humungous help to you. Just know that it adds overhead to tempdb. However, most people won't even notice.

I'd be really cautious here. You can...