Viewing 15 posts - 4,216 through 4,230 (of 22,219 total)
Two tools that I would suggest that can help with this (you're still going to have to do a lot of work to understand exactly what is being documented) are...
"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 18, 2016 at 5:55 am
Yeah, you're recompiling all the plans after that runs. It might not be that big a deal. It really depends on your system, the code, all sorts of factors. Also,...
"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 17, 2016 at 12:29 pm
Ed Wagner (11/17/2016)
I didn't make it through the entire presentation, but I read the announcement - thank you 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 17, 2016 at 7:33 am
Another third party tool to check out is Minion Ware. They have a free version of an index management software that does a fantastic job of managing your indexes.
"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 17, 2016 at 4:06 am
I'm not sure then.
"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 12:30 pm
I have never attempted to set up replication to Azure SQL DB. I suppose it will work since it's in the documentation. I'd strongly suggest testing it and setting it...
"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 11:48 am
Oh, and welcome to the party.
"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:02 am
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
Viewing 15 posts - 4,216 through 4,230 (of 22,219 total)