Viewing 15 posts - 16,726 through 16,740 (of 22,219 total)
Add another vote of confidence supporting you for doing well on your initial design. Now don't mess with it. There's nothing wrong with using lookup tables. As a matter 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
August 14, 2009 at 8:24 am
Excellent article, thanks Andy. It's also very well timed for my company. We're having some trouble convincing people that trunc & reload is NOT the industry best practice.
"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 14, 2009 at 8:00 am
drew.allen (8/13/2009)
Grant Fritchey (8/13/2009)
Or, since you only care about when records do exist, check for NOT NULL values on the outer table. You'll still arrive at the same place.
No, 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
August 14, 2009 at 5:33 am
Jeff Moden (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 14, 2009 at 5:31 am
Kit G (8/13/2009)
Bob Hovious (8/13/2009)
j tk th sq o/t t2 n xrf th dmv frm thr 4 all sign f
Does one even dare ask for a translation? Or...
"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 14, 2009 at 5:30 am
drew.allen (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 1:25 pm
Justa Developer (8/13/2009)
Grant Fritchey (8/13/2009)
Introductory error handling article[/url]. It includes 2000 and 2005/2008 syntax.Oh, that is lovely, thanks Grant! I'm learning tons and tons!
Pleasure!
"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 1:00 pm
RBarryYoung (8/13/2009)
Another real Gem...
I went to respond to your interpretation of the SSMS shorthand and decided that it would look too much like picking on the guy who did 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 12:39 pm
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
Viewing 15 posts - 16,726 through 16,740 (of 22,219 total)