Viewing 15 posts - 15,931 through 15,945 (of 22,221 total)
sunpalozzi (1/5/2010)
"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 5, 2010 at 6:59 am
The thing you're looking for is the TOP operator (check it out in BOL) but it's going to return nonsense values if you don't supply additional information, basically something to...
"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 5, 2010 at 6:56 am
Thanks Scott. I'm looking forward to your presentation at Data Camp 2.0 as well. You need to keep up your work for the community also.
Now, I happen to be closely...
"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 5, 2010 at 6:31 am
Nice article and useful for digging out those silly artifacts.
"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 5, 2010 at 5:34 am
Ronald Cartmale (1/5/2010)
"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 5, 2010 at 5:23 am
Edogg (1/4/2010)
Grant Fritchey (1/4/2010)
umailedit (1/4/2010)
Why should something as routine as backup not be done automatically by computers? Why depend on people to do the backup?
"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 5, 2010 at 5:19 am
ken.trock (1/4/2010)
Speak of Murphy and he will appear. Right here is a good example. No backups. Corrupt file. Just the same as flat tire, no spare.
This is something of a...
"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 5, 2010 at 5:17 am
Julie Breutzmann (1/4/2010)
Some people's idea of a backup is having their resume up-to-date and access to a copier.😛
Oh, that's a backup. I thought it was disaster recovery.
"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 4, 2010 at 10:46 am
sudhakara (1/4/2010)
Jack Corbett (1/4/2010)
"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 4, 2010 at 8:58 am
GilaMonster (1/4/2010)
"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 4, 2010 at 8:54 am
And I was actually questioned about why I would bother posting today's editorial[/url].
Why aren't you taking backups of the system?
"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 4, 2010 at 8:17 am
umailedit (1/4/2010)
Why should something as routine as backup not be done automatically by computers? Why depend on people to do the backup?
Speak of Murphy and he will appear. Right...
"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 4, 2010 at 8:16 am
If he runs scripts to create procedures like this:
CREATE PROCEDURE MyProc ...
instead of like this
CREATE PROCEDURE dbo.MyProc ...
--or
CREATE PROCEDURE myschema.MyProc ...
You'll see what's occurring. It will create 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 4, 2010 at 7:14 am
When this happens, you actually need a little bit of space to shrink the tempdb and you might not have it. One option would be to add another file to...
"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 4, 2010 at 6:58 am
People have to set up the backup, monitor it and fix it when it goes wrong. The actual execution should be scheduled and automated, you're right. But far too many...
"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 4, 2010 at 3:46 am
Viewing 15 posts - 15,931 through 15,945 (of 22,221 total)