Viewing 15 posts - 4,006 through 4,020 (of 22,219 total)
So the complaints aren't coming from the developers or a design team or something, but from someone looking at a report? Oh, to heck with that then. Yeah, just say...
"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
March 3, 2017 at 7:59 am
I'm not exactly a normalization Nazi, but I think they have a point. You're overloading the behavior of that column. From a normalization standpoint, that's pretty much a violation of...
"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
March 3, 2017 at 6:52 am
Extended Events. You can easily capture the logins and filter to only a single database. It's the least obtrusive way to get this done.
"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
March 3, 2017 at 6:11 am
Looking at it again, an interesting thing is that the output from the Hash join is estimated at 2,000 rows and is actually 10k. That's the opposite direction of the...
"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
March 3, 2017 at 3:25 am
Sure, you can send a command to force a failover. That's the easy part. The hard part is that you're going to have to constantly poll the database to see...
"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
March 3, 2017 at 3:00 am
That is a big difference. I'm not sure why you're seeing that without checking the statistics to understand what the values that the plan is compiling for represent there. "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood" Author of:
- Theodore Roosevelt
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 3, 2017 at 2:49 am
"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
March 2, 2017 at 9:25 am
My situation is similar. I have a good number of inactive users that need...
"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
March 2, 2017 at 9:15 am
BTW, I agree with what everyone else is saying. Of course you should be deleting the data in such a way that you're not violating referential integrity. It's there for...
"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
March 2, 2017 at 5:17 am
"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
March 2, 2017 at 2:09 am
For DELETE and UPDATE operations, you can't simply disable the constraint by using NOCHECK. Instead, you have to drop and recreate the constraint. Just be sure that when you recreate the...
"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
March 2, 2017 at 1:35 am
"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
March 1, 2017 at 7:13 am
Can you have an availability group across two different failover clusters? Yes.
The issue is, generally, AG is meant as a replacement for failover clusters. Unlike failover clusters, there...
"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
March 1, 2017 at 3:58 am
How to replicate or backup/restore a SQL azure...
"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
March 1, 2017 at 1:43 am
Have you looked at the execution plans to understand how the optimizer is choosing to resolve the query? Can you capture the actual plan (although, an estimated plan would work...
"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
February 28, 2017 at 7:12 am
Viewing 15 posts - 4,006 through 4,020 (of 22,219 total)