Viewing 15 posts - 4,231 through 4,245 (of 22,219 total)
VARCHAR(1) is my favorite data type of all time... Well, behind VARIANT, but hopefully that's going to be on the ash heap soon.
"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
November 15, 2016 at 7:36 am
Wild. I hadn't even thought of temporal tables as an added protection for the data. Thanks for sharing the concept.
"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
November 15, 2016 at 7:30 am
I'm with Thomas, it depends.
However, just a general observation, tempdb and logs are pretty frequent I/O bottlenecks. Lots of other stuff can, and will, be, but you get consistent problems...
"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
November 15, 2016 at 6:31 am
If you mean that you are looking at the value for parameterized_plan_handle and it's showing something like this:
0x
What you're seeing is the handle for a plan that has not been...
"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
November 15, 2016 at 6:27 am
Marbles?
Pretty sure I lost them years ago.
"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
November 11, 2016 at 12:58 pm
You're performing a function against the column. That's going to lead to scans. You need to not do that. Using IS NOT NULL is more likely to perform well. However,...
"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
November 10, 2016 at 11:26 am
Query Data Store.
It's probably the biggest change to query metrics, query tuning, performance knowledge and system behavior since the upgrade of the optimizer between SQL Server 7 & 2000.
"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
November 10, 2016 at 11:16 am
Lowell (11/9/2016)
m not sure if they are SQL Server version agnostic or not, but the dacpac has the object schemas, ; i...
"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
November 9, 2016 at 2:55 pm
Eirikur Eiriksson (11/9/2016)
Grant Fritchey (11/9/2016)
Beatrix Kiddo (11/9/2016)
There is absolutely nothing when working on an SQL Server that requires RDP to the server
Not quite true- if you work in a bank...
"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
November 9, 2016 at 11:02 am
There's a chance with that kind of procedure that you're also dealing with ad hoc execution. If you have ad hoc T-SQL, you may find that you won't see all...
"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
November 9, 2016 at 10:34 am
Beatrix Kiddo (11/9/2016)
There is absolutely nothing when working on an SQL Server that requires RDP to the server
Not quite true- if you work in a bank or other high security...
"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
November 9, 2016 at 10:30 am
To a degree this is just piling on, but this is an important question.
You are much better off not using SSMS on the server for a number of reasons. Most...
"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
November 9, 2016 at 9:57 am
I agree with Eirikur (I type that a lot).
You can easily script this install. It's quite small. My one addition to what has already been said is that you should...
"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
November 9, 2016 at 9:01 am
xsevensinzx (11/8/2016)
"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
November 8, 2016 at 6:24 am
Query hints? NOLOCK?
"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
November 7, 2016 at 6:30 pm
Viewing 15 posts - 4,231 through 4,245 (of 22,219 total)