Viewing 15 posts - 21,781 through 21,795 (of 22,226 total)
One for the car would be really cool.
"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
July 11, 2007 at 6:46 am
Whoa! Wait a second here. Superman is imaginary?
"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
June 20, 2007 at 5:21 pm
I'm not too sure I'm crazy about this trend. I mean, some of us have a face perfect for radio...
"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
June 20, 2007 at 5:54 am
I do have to admit to using Redgate SQL Refactor & SQL Prompt. Between the two they do tons of formatting so I don't have to. I do like 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
June 19, 2007 at 5:10 am
I still capitalize the reserved words because not all our SQL code will end up in a nice graphical editor. It does make it a bit easier to read.
"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
June 18, 2007 at 8:42 am
If the environment has moved to 2005 and its new development, there's no real reason to not go to SSIS. It's going to be the tool used in future releases...
"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
June 13, 2007 at 12:48 pm
Have you looked for configuration differences between the BETA servera and PROD?
Any chance that after inserting 1.2 million rows a record at a time that you've got index fragmentation problems?
Those...
"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
June 11, 2007 at 11:44 am
<ShamelessPlug>I just got an article published on the basics of performance tuning at Simple-Talk.com
http://www.simple-talk.com/sql/performance/sql-server-performance-crib-sheet/
</ShamelessPlug>
"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
June 11, 2007 at 11:40 am
It might not be exactly what you're looking for, but have you looked into, what was in SQL 2000, the black box? Lookup sp_trace_create in BOL.
"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
June 11, 2007 at 11:36 am
Something along the lines of:
SELECT c.State, h.HotelName, h.MinPrice
FROM City c
INNER JOIN Hotel h
ON c.City = h.City
AND h.Range = (SELECT MIN(Range)
FROM Hotel h2
WHERE h2.City = h.City
and h2.Hotel = h.Hotel
...
"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
June 11, 2007 at 11:30 am
The estimated plan can't be trusted because statistics & data can get out of sync. I had to come up with a contrived situation to display it. Silly, I'll grant...
"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
June 8, 2007 at 9:38 am
With some help from a person, here's one that works (by works I mean we get two different plans).
IF
EXISTS (...
"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
June 8, 2007 at 8:55 am
The short answer is "as often as possible." What this translates to varies widely based on system, space, etc.. The reason is pretty much as you state. You need 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
June 8, 2007 at 4:36 am
It's funny you say that. The reason I posted an XML plan was that the graphical plans were acting all wonky with that script. There's a mystery I'm going 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
June 8, 2007 at 4:29 am
Basically, yes. I'm working on something and rather than simply caution that differences could arise, I'd like to show one.
"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
June 7, 2007 at 10:21 am
Viewing 15 posts - 21,781 through 21,795 (of 22,226 total)