Viewing 15 posts - 16,741 through 16,755 (of 22,226 total)
Introductory error handling article[/url]. It includes 2000 and 2005/2008 syntax.
"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
August 13, 2009 at 12:03 pm
Can you post the code you tried that didn't work?
It is possible in a single query.
"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
August 13, 2009 at 12:01 pm
GilaMonster (8/13/2009)
sivark1 (8/12/2009)
pls tell how to c the o/p of the profilerWhat?
Guessing:
Please tell me how to see the output of the profiler?
But I could sure be wrong. Whole words make...
"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
August 13, 2009 at 9:18 am
jcrawf02 (8/13/2009)
"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
August 13, 2009 at 9:14 am
What's in your query window? For that matter, what does the procedure look like? Is the tab "Execution Plan" opening when you request the estimated plan? If so, maybe you...
"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
August 13, 2009 at 6:59 am
Run a query using the EXISTS keyword. Look it up in the Books Online.
"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
August 13, 2009 at 6:55 am
Personally, being a paranoid type, I'd use backup & restore. Why not. It leaves the database in place on the first server in case something goes wrong while getting 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
August 13, 2009 at 6:52 am
What's wrong with using a server side trace?
But, you can also query the dynamic management views (dmv), such as sys.dm_exec_requests to see which database is getting a lot of activity....
"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
August 13, 2009 at 6:50 am
Look up the command sp_msforeachdb. It's considered to be an undocumented command, but it's been around for a very long time with no signs of going away. You can use...
"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
August 13, 2009 at 6:46 am
Personally, I'd recommend both. Put the constraint in the database to prevent accidental violation of the rules, and put code into the front-end that checks on the rules and neatly...
"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
August 13, 2009 at 6:41 am
Jack Corbett (8/13/2009)
Grant Fritchey (8/13/2009)
"And this article I wrote was plagiarized five...
"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
August 13, 2009 at 6:39 am
This is going to become a new badge of honor for people going for jobs or qualifying for MVP:
"And this article I wrote was plagiarized five times in 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
August 13, 2009 at 6:24 am
Do you mean hints?
"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
August 13, 2009 at 6:15 am
This will be my first time in Vegas too. I'm not crazy about gambling, but I understand other forms of entertainment are available. I'll spend most of my time 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
August 13, 2009 at 6:02 am
Kit G (8/12/2009)
Grant Fritchey (8/12/2009)
I'm pretty sure they are. There was a new printing of The Moon is a Harsh Mistress just recently. I'm rereading Farnums Freehold on my Kindle...
"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
August 12, 2009 at 6:47 am
Viewing 15 posts - 16,741 through 16,755 (of 22,226 total)