Viewing 15 posts - 20,911 through 20,925 (of 22,219 total)
From what you described, I'd move on to coding now. As you code, when you get portions of the app working, run Profiler while you test the app so that...
"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
March 7, 2008 at 7:13 am
I tried it. It worked.
I took your table & loaded it with data (still beta testing Red Gates SQL Data Generator). I then created this table:
CREATE TABLE tableofdates
...
"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
March 7, 2008 at 7:08 am
I'm strapped for time, so I might not be able to experiment with this, but what if you created the equivalent of a table of numbers, but instead made 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
March 7, 2008 at 5:46 am
I agree. If you're processing 15 rows of data and it doesn't matter that it takes 10 seconds, walk away a winner.
If you're trying to build a large scale, repeatable,...
"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
March 7, 2008 at 5:36 am
At my company, we do clean up & hide the data from production, but not nearly enough and, unfortunately, not across all teams. The biggest problem we have is getting...
"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
March 7, 2008 at 5:34 am
Michael Valentine Jones (3/6/2008)
"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
March 7, 2008 at 5:22 am
Jeff Moden (3/6/2008)
Grant Fritchey (3/5/2008)
What this is doing is using the temp table in place of a join or joins. That's bad.
Ummm... I gotta say, "Not always". I've...
"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
March 6, 2008 at 12:54 pm
Rishi Girdhar (3/6/2008)
For example
select max(a.closedate) as closedate, a.offerid...
"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
March 6, 2008 at 12:29 pm
I'm impressed if you can write the TSQL so that it fully performs and returns all the correct data out of the gate. It usually takes me a pass 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
March 6, 2008 at 12:25 pm
Speaking only for myself, I won't be applying for that position.
:smooooth:
"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
March 6, 2008 at 12:15 pm
You can run the query and capture the actual execution plan. There's a button on the default tool bar, look for the tool tip that says "Include Actual Execution Plan"...
"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
March 6, 2008 at 12:09 pm
Right now I'm trying to uninstall 2008 from a virtual machine.
For a good overview, read the book "Database Administration" by Craig Mullins. Best summary of the job I've ever seen.
Do...
"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
March 6, 2008 at 11:24 am
Well, back in the day... 6.5, 7.0, that was true, to a degree. But it hasn't been true at all for years & years now. Here's an introduction to performance...
"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
March 6, 2008 at 11:20 am
Yeah, sorry about that.
I sent an email to the group this morning. Did you get 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
March 6, 2008 at 10:47 am
Profiler and Perfmon are your bestest friends. There are also a number of dynamic management views available in 2005 that list missing indexes, etc.
"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
March 6, 2008 at 10:41 am
Viewing 15 posts - 20,911 through 20,925 (of 22,219 total)