Viewing 15 posts - 4,201 through 4,215 (of 22,219 total)
Thinking about it, make sure you have updated your SSMS version as well.
I know there's documentation saying that backup to URL is supported in 2012 as of SP2, but it's...
"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 28, 2016 at 6:48 am
Currently on the MSDN documentation on Backup to URL, it only shows support in 2014 & 2016. There was an app to do backup to Azure for 2008 & up,...
"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 28, 2016 at 6:42 am
Brandie Tarvin (11/23/2016)
Because I won't be online tomorrow (or probably Friday), Happy Turkey Day to all who celebrate. Or Tofurkey Day, whichever floats your boat.Enjoy the holiday!
Surely the denizens 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 23, 2016 at 5:09 am
I don't see any mention of cost threshold for parallelism? What's that set to?
Also, in addition to the cardinality estimator, all sorts of changes have been made to the optimizer....
"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 22, 2016 at 11:56 am
The biggest issue with upgrading to 2014 is the new cardinality estimator. Overall, it helps, but there are edge cases, especially with queries that were poorly written to begin 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
November 22, 2016 at 11:12 am
Well done to all Steve. That's a hell of an accomplishment.
"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 22, 2016 at 10:10 am
If you're migrating your data into a new configuration, I wouldn't do it in a single set as you're describing. Instead, break it apart and move only 100k rows at...
"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:10 am
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
Viewing 15 posts - 4,201 through 4,215 (of 22,219 total)