Viewing 15 posts - 14,776 through 14,790 (of 22,232 total)
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
balasach82 (6/28/2010)
Thats a great way of explaining. Now I understand. Its complicated to get the query's count(which query ran how many times).
Still having one doubt.. that fileds with NULL values.....
"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:30 am
The text data field shows the full query, including parameters passed. Take these two calls as an example:
EXEC spMyProc @parm1 = 42, @parm2 = 'Optional Parameter'
EXEC spMyProc @parm1 = 42
Now,...
"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:13 am
Viewing 15 posts - 14,776 through 14,790 (of 22,232 total)