Viewing 15 posts - 4,231 through 4,245 (of 22,227 total)
I strongly recommend getting a copy of Craig Mullins book: Database Administration. It covers the job, as a job. It's technology agnostic. It'll give you a more complete picture 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
November 16, 2016 at 10:01 am
Sounds like you're hitting this issue. Are you sure this is a SQL SErver 2012 instance?
"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 16, 2016 at 9:58 am
Add two columns that are only from the Owner. Then set them to null on the second query in the UNION. That ought to return what you're looking 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
November 16, 2016 at 9:56 am
All that, and the vNext is also on Windows. They're going to be releasing another full version of SQL Server very soon now. We are in for a wild ride.
"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 16, 2016 at 9:10 am
Announcements include:
SP1 for 2016 (which also has CREATE OR ALTER).
A single development surface. This means all functionality in Enterprise is also in Standard and Web (WHOOOP!).
vNext community preview available (you...
"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 16, 2016 at 8:50 am
Sorry. I didn't see that Gail had already alerted you.
"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 16, 2016 at 8:25 am
Quick note. You all should be watching Connect right now[/url].
"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 16, 2016 at 8:23 am
That pyramid looks amazing.
BTW, I'll be going on SQL Cruise in January. It's stopping at Cozumel. Who wants to go see the pyramid with me?
"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 8:35 am
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
Viewing 15 posts - 4,231 through 4,245 (of 22,227 total)