Viewing 15 posts - 21,271 through 21,285 (of 22,219 total)
2000 doesn't support XQuery. You will have to use string functions. I don't have any samples because, frankly, it wasn't worth doing in TSQL in 2000. Instead we used VB,...
"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
January 14, 2008 at 5:18 am
The most immediate benefit you'd see from using the CTE vs. a function is that the CTE will take advantage of indexes within the system as part of it's operation....
"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
January 14, 2008 at 5:14 am
Microsoft has a tool to generate load from trace files located here. You can also go for more sophisticated third party offerings like SQLScaler from Idera or Benchmark Factory from...
"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
January 14, 2008 at 5:10 am
How about taking the initial query and placing it into a sub-select and the wrapping the outer where clause around that. Then you can refer to the columns derived from...
"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
January 14, 2008 at 5:02 am
I second the vote for XML PATH. It will make a huge difference.
"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
January 14, 2008 at 4:48 am
The one piece of advice I can give you is to get the Microsoft Upgrade Advisor. This will identify the places where you need work in your existing 2000 database.
"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
January 13, 2008 at 4:27 am
Excellent. Thanks Steve.
"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
January 13, 2008 at 4:23 am
Fourth, assuming that's not homework, if it's proprietary information, you sure shouldn't be posting it willy-nilly on the internet.
"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
January 12, 2008 at 4:38 am
Rereading your description, it sounds like you might be doing RBAR (row-by-agonizing-row) processing. Are you sure the process that you mention that is row-by-row can't be done as a batch?...
"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
January 12, 2008 at 4:31 am
Thanks. His blog seems to be offline right now. I'll check on it later.
I understood that there were few if any fundamental changes, but I just wanted the chance 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
January 11, 2008 at 11:42 am
Oh, sorry. Yeah, I did post the 2005 code. This is the 2005 forum after all. Sorry about 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
January 11, 2008 at 11:38 am
In addition to the suggestion above to use XML and XPath queries, you might look into the XML Bulk loader. It sounds like you've got a perfect place to 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
January 11, 2008 at 11:35 am
Subversion was recommended above. I've used VSS in the past. I'm currently using TFS, Team Foundation System, the new management tool from Microsoft.
Picking the code management tool is 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
January 11, 2008 at 7:21 am
iain lastname (1/11/2008)
I'd also suggest some source control, we use Subversion and it's quite good but there are others.
I'd like to second this suggestion. You should treat the code in...
"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
January 11, 2008 at 6:36 am
Actually, you could also get one of the third party log explorer tools and retrieve the older version of the procedure from the log IF you have your recovery set...
"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
January 11, 2008 at 6:32 am
Viewing 15 posts - 21,271 through 21,285 (of 22,219 total)