Viewing 15 posts - 3,676 through 3,690 (of 22,219 total)
BEGIN TRANCOMMIT TRAN /* ROLLBACK */
BEGIN TRYEND TRY
BEGIN CATCH
END CATCH
"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
August 2, 2017 at 5:53 am
There's not going to be a giant performance difference between CHAR(2) and VARCHAR(2) when it comes to NULL values. When the value is NULL, there is no length stored with...
"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
August 2, 2017 at 5:51 am
First up, there are specific wait statistics assigned to query store. When you query sys.dm_os_wait_stats, if you are experiencing issues with Query Store, that's where you'll see the evidence 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
August 2, 2017 at 5:42 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
August 2, 2017 at 5:28 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
August 2, 2017 at 5:22 am
I expanded this into a full blog post. Comes out a little after 10. Yes, DBCC TIMEWARP is mentioned, but no, it's not the "Run Really Fast" button.
"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
August 1, 2017 at 7:09 am
OK guys. I think it's way past time. We need to just unveil the magic "Run Really Fast" button that we know about and are hiding from the rest 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
August 1, 2017 at 6:24 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
August 1, 2017 at 6:19 am
I'm not sure about others, but I think this may be a tough nut to crack.
First of all, I wouldn't put any kind of process inside your existing...
"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
August 1, 2017 at 5:11 am
My big moment for PowerShell was when we were moving the data center. We had to physically disconnect all our drives and move all the hardware into a new location....
"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
July 31, 2017 at 2:29 pm
Yes. You need to look at redesigning.
Now, the bigger question is, what? That's going to be hard to say. Going off the index names (totally making an assumption,...
"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
July 31, 2017 at 7:59 am
GilaMonster - Monday, July 31, 2017 5:33 AMCrystal ball to aisle 7 please. Crystal ball to aisle 7.
https://www.sqlservercentral.com/Forums/1889451/Should-I-Redesign-table
That one is going...
"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
July 31, 2017 at 5:36 am
Gail asked for the table design. How many columns, their data types, the primary key, the clustered index, any additional nonclustered indexes, constraints, triggers, foreign keys. That's the information we...
"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
July 31, 2017 at 5:32 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
July 20, 2017 at 7:56 am
One more inputs from you. Even though I have a Non Clustered...
"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
July 20, 2017 at 7:51 am
Viewing 15 posts - 3,676 through 3,690 (of 22,219 total)