Viewing 15 posts - 4,216 through 4,230 (of 22,227 total)
Assuming you're outputting to a file, you can just open the file and you'll be immediately viewing the live data. That may not be a lot easier, but it works.
"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 21, 2016 at 8:07 am
ThomasRushton (11/21/2016)
Grant Fritchey (11/18/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 21, 2016 at 7:03 am
tazzman (11/20/2016)
If you don't need to perform point-in-time database recovery and doesn't use mirroring or other HA-solutions you can use simple recovery model.
I would only recommend this switch after an...
"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 20, 2016 at 8:37 am
Ad Hoc:
SELECT * FROM Table;
If this is run from SQL Server Management Studio, Reporting Services, Integration Services, or through code from an app, it's ad hoc because it's not in...
"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 1:02 pm
For the second time this year, I successfully got a Linux VM running with SQL Server on it. Last time I just did the install & walked away. This time...
"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 10:40 am
jasona.work (11/18/2016)
Grant Fritchey (11/18/2016)
jasona.work (11/18/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 18, 2016 at 8:43 am
jasona.work (11/18/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 18, 2016 at 7:22 am
Quest had a tool like that once upon a time. I think it's long been discontinued.
For testing the running of a procedure, it's not hard to write a quick PowerShell...
"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 6:01 am
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
Viewing 15 posts - 4,216 through 4,230 (of 22,227 total)