Viewing 15 posts - 5,236 through 5,250 (of 22,219 total)
What's the query hint doing?
"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
January 12, 2016 at 8:26 pm
The reason there are tools around this task is because there really isn't any simple, quick & easy way to get it done. Especially not one that supports all the...
"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
January 12, 2016 at 2:40 pm
And Visual Studio, both versions mentioned, has been quite stable.
"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
January 12, 2016 at 11:09 am
Hugo Kornelis (1/11/2016)
Grant Fritchey (1/11/2016)
You can, if necessary, apply a clustered index to the table and then drop that index.
In most cases, the better idea is to stop halfway through...
"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
January 11, 2016 at 3:41 pm
Martin Sherwood-301653 (1/11/2016)
With the advent of (MPP) capability within Azure SQL DWH was curious to field the...
"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
January 11, 2016 at 3:41 pm
ypeng5 (1/11/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
January 11, 2016 at 1:26 pm
I'm having trust issues with Lenovo. Both because of the horror show of the W530 and the security issues they've been having recently.
Still, that's a nice looking piece 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
January 11, 2016 at 10:59 am
That's actually a pretty dense set of questions. Any advice I'm offering up here should be taken with a very large grain of salt.
1) Heck no. Take Azure and everything...
"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
January 11, 2016 at 10:53 am
kramaswamy (1/11/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
January 11, 2016 at 10:40 am
Automation is your bestest buddy.
You're not going to test every backup every night. Start with the vital ones. Figure out how often you can test them, more is better. Automate...
"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
January 11, 2016 at 9:04 am
That's a job for SQL Server Integration Services, SSIS. You can do a search for SSIS & Interbase to find lots of information on how to integrate between the two....
"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
January 11, 2016 at 4:03 am
You can only do that if you have the tail log backup of that time. Based on what you said, you don't. So you can only restore to the last...
"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
January 11, 2016 at 4:01 am
Continuing my role as the harbinger of death, Ziggy Stardust is no more.
One of my favorite songs. Although Bauhaus actually did it better.
"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
January 11, 2016 at 3:56 am
Eirikur Eiriksson (1/10/2016)
Grant Fritchey (1/10/2016)
Here's an article by Kathi Kellenberger[/url]. Here's one I wrote[/url]. Either or both should satisfy exactly what you're looking for.
Grant, the link to your article doesn't...
"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
January 11, 2016 at 3:44 am
Here's an article by Kathi Kellenberger[/url]. Here's one I wrote[/url]. Either or both should satisfy exactly 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
January 10, 2016 at 9:53 am
Viewing 15 posts - 5,236 through 5,250 (of 22,219 total)