Viewing 15 posts - 21,556 through 21,570 (of 22,220 total)
There are a number of scripts available on this site that will analyze the indexes and perform a defrag or a reindex depending on the level of fragementation. It shouldn't...
"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
November 12, 2007 at 5:18 am
Sorry I haven't gotten back to you, I was out of town.
Yeah, that's approximately the format I was thinking of. It's just better when you have 'x' number of potential...
"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
November 12, 2007 at 4:24 am
My well is over 700ft down. Can I just add a couple of pipes & use 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
November 2, 2007 at 11:39 am
All true.
The reason I'm chasing this down is because on another thread, someone was asking how to parse an XML file out into it's component parts for loading into...
"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
November 2, 2007 at 10:38 am
We keep this up and I'll make it really, really scary... I'll take my shirt off
[SHRIEKS]
"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
November 2, 2007 at 10:31 am
Thanks.
Much closer to 50/50 which was my initial assumption of worst case (boy was I shocked). I think I'll expand the tests a bit & start looking at actual memory...
"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
November 2, 2007 at 10:29 am
Should I tape a full two-hours?
That'd be slightly more interesting than the yule log on TV.
"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
November 2, 2007 at 9:40 am
Up in the Peoples Republic of Massachusetts we don't worry too much about cooling the house, but this GeoThermal heating sounds a heck of a lot better than the two...
"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
November 2, 2007 at 9:14 am
I'll hazard a wild guess and suggest... compile time. That's one large plan. You can test this by going to a non-production server, run the view to get it 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
November 2, 2007 at 8:45 am
SELECT *
FROM Table1
JOIN Table2
ON Table1.Key = Table2.Key
JOIN Table3
ON Table1.Key = Table3.Key
This assumes that the PK on Table1 matches an FK on Table2 & Table3. Either way, you can then 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
November 2, 2007 at 7:11 am
day (11/1/2007)
Can anyone help me with this?
SELECT...
"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
November 2, 2007 at 7:08 am
kev_byrne (11/2/2007)
The SQL when run directly against the DB, on 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
November 2, 2007 at 7:03 am
This is unlikely to run very fast, 43 seconds on my machine against 54 million rows, but it'll work.
WITH x AS (SELECT b.[ID]
,b.[Date]
,b.[Value]
,ROW_NUMBER() OVER(ORDER BY b.[ID]) AS RowNum
FROM [BigTable] b
)
SELECT...
"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
November 2, 2007 at 6:55 am
Johannes Fourie (11/2/2007)
Then remove the ORDER BY in 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
November 2, 2007 at 6:46 am
Thinking about it more, you should be able to get reasonable performance, even pivoting the data, assuming the indexes are clean, especially the clustered indexes. How did you set 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
November 2, 2007 at 5:39 am
Viewing 15 posts - 21,556 through 21,570 (of 22,220 total)