Viewing 15 posts - 1,846 through 1,860 (of 22,224 total)
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 21, 2020 at 11:09 am
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 16, 2020 at 3:33 pm
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 16, 2020 at 1:59 pm
I'm not selling anything. I'll take it elsewhere tho. Thanks.
What were you going for then? This sure looked promotional. Although, maybe I'm wrong and the Thread Denizens can correct...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 16, 2020 at 1:54 pm
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 16, 2020 at 1:06 pm
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 16, 2020 at 11:57 am
Not a problem. Happy to help.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 16, 2020 at 11:43 am
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 16, 2020 at 10:47 am
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 16, 2020 at 10:23 am
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.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 15, 2020 at 7:53 pm
I think rowstore indexes would not be required with Clustered Columnstore Index. However, I've not tried this yet. This needs to be authenticated.
I'd be really cautious here. You can...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 13, 2020 at 10:56 am
So, before I comment on anything, remember, testing is your best friend in these situations. Anyone can have opinions on behavior. However, you should test those opinions and assumptions against...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 13, 2020 at 10:51 am
First, tell your friend to simply be honest about their knowledge and experience. Next, some good news. To a large degree, SQL Server is SQL Server. Whether we're talking about...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 13, 2020 at 10:33 am
It's a very good idea to have a second copy of your backups anyway. Not all of them every time, but, say, weekly or something. Just so, in the event...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 13, 2020 at 10:27 am
Grant Fritchey wrote:I am the canary in your coal mine.
Rumor has it that the first people that will get axed are people that keep badmouthing SQL Profiler. 😀 😀 😀
HA!...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 9, 2020 at 11:49 am
Viewing 15 posts - 1,846 through 1,860 (of 22,224 total)