Viewing 15 posts - 5,236 through 5,250 (of 22,221 total)
Always start with the Microsoft documentation when you have fundamental questions about what something is or how it works. For example, here's the information on indexed views. Then you can...
"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 13, 2016 at 6:11 am
Eirikur Eiriksson (1/12/2016)
Grant Fritchey (1/12/2016)
What's the query hint doing?😎
WITH (READ
UNCOMMITTED)???
I know what it does. I just don't understand why it's included.
"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 13, 2016 at 5:25 am
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
Viewing 15 posts - 5,236 through 5,250 (of 22,221 total)