Viewing 15 posts - 14,761 through 14,775 (of 22,219 total)
GabyYYZ (6/30/2010)
Roy Ernest (6/30/2010)
This is the first time that one my articles did not bring out any discussion. It was rated very good, but it is very quiet... 🙂
Lucky...still shell-shocked...
"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 30, 2010 at 7:42 am
balasach82 (6/30/2010)
Is the default trace (which is in Log folder) also available in SQL 2000?If so, then what is the equivalent of fn_trace_getinfo?
You could get a much wider audience if...
"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 30, 2010 at 7:15 am
Jeff Moden (6/30/2010)
Heh... I finally beat Grant to the punch for a change. 😀
Oh right, Mr. Umpty-gazillion points, you "finally" beat me to the punch. :hehe:
"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 30, 2010 at 7:12 am
Is that a single statement table valued function or a multi-statement table valued function? If multi-statement, you were just lucky that it ran well in 2000. These types of functions...
"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 30, 2010 at 6:33 am
I have heard that some functions, usually ones that are problematic in nature anyway, do perform slower on 2008 than on 2000. I have not seen or heard of any...
"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 30, 2010 at 6:30 am
There's nothing wrong with a few of these types of queries in almost any system. They do come up, and it's pretty normal. Using sp_executesql and parameters can improve 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 29, 2010 at 6:53 am
Nagesh S-432384 (6/29/2010)
"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 29, 2010 at 6:46 am
It sounds like you might have an issue with the Litespeed install. Instead of trying to run the standard backup & restore commands, try using Litespeed's extended stored procedures. 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
June 29, 2010 at 6:20 am
Although if you move to SQL Server 2008 (or R2), you can use Change Data Capture to perform this type of change tracking without using triggers.
"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 29, 2010 at 6:12 am
That's not a normal issue, but evidently it's happened before[/url]. It sounds like you must have some third party software involved with your backups, possibly interfering in the backup process...
"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 29, 2010 at 6:11 am
yessen (6/28/2010)
Grant Fritchey (6/28/2010)
"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 28, 2010 at 1:17 pm
I'd check out Craig Mullins book Database Administration. It's not so much a "how-to" manual but a "what kind of job are you looking for" manual. It's pretty technology agnostic...
"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 28, 2010 at 8:41 am
Volume like this in sQL Server will require both hardware and careful database design, appropriate tsql, good indexes, proper maintenance... I'm with everyone else. You're probably better off hiring someone...
"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 28, 2010 at 8:25 am
Yep, it ought to work just fine with 2005.
You should also check out Professional SQl Server 2008 Internals and Troubleshooting.
"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 28, 2010 at 8:23 am
balasach82 (6/28/2010)
so it maybe a background process...right?.. Also can I omit such records for my calculation, since they are not a transaction in strict sense.
Not knowing the events you've defined,...
"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 28, 2010 at 7:42 am
Viewing 15 posts - 14,761 through 14,775 (of 22,219 total)