Forum Replies Created
Viewing 15 posts - 7,966 through 7,980 (of 22,219 total)
-
RE: Trace user in sql server
There are a number of tools you can set up to track changes to the system. If you want to track individual queries you can use extended events or trace....
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Rewrite the below query for performance
Kind of a shame to not let others see the question or provide a solution. Others could benefit from whatever issue you hit.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Dead Lock Help..
SQL Server 2008 has a system_health extended event session. I'm pretty sure it's capturing information from your deadlock called a deadlock graph. You'll need to query the files to get...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Are the posted questions getting worse?
Koen Verbeeck (6/14/2014)
Grant Fritchey (6/14/2014)
Koen Verbeeck (6/14/2014)
Ah, the world cup......
Spoilsport.
England plays today!
WHOOOOP!!!
I bet they are going to lose. Hard. 😀
And they did. Well, not that hard, but a loss is...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Are the posted questions getting worse?
Koen Verbeeck (6/14/2014)
Ah, the world cup...
Spoilsport.
England plays today!
WHOOOOP!!!
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Server Performance Issue
Both the server-side trace and extended events can be set up to run from a SQL Agent job so that they start at a particular time. Both can also be...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Removing joins & Execution Time
ramana3327 (6/13/2014)
Hi Jack,I am running in dev box only. So stats were not very up to date. Usually to test the changes do we need to run the stats before...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: SQL Backups versus TSM TDP SQL (Tivoly Storage Manager)
I'd ask for a demonstration of a point in time restore. If it can restore to 3:57PM yesterday, accurately, without a corrupt database, go with it. I've seen SAN snapshot...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: SQL 2012 vs SQL 2014 standard version performance
I agree with Howard. I have seen some interesting improvements in performance because of the new cardinality estimation across quite a few queries, including some I wouldn't have expected to...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Reduce Log File Size
Did you read the post I linked to? You need to have log backups enabled.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Are the posted questions getting worse?
wolfkillj (6/13/2014)
SQLRNNR (6/13/2014)
Grant Fritchey (6/13/2014)
Sean Lange (6/13/2014)
Grant Fritchey (6/13/2014)
NOt a great game, but not a bad one so far. First one I've had on so far this World Cup. I..."The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Are the posted questions getting worse?
Jeff Moden (6/13/2014)
Grant Fritchey (6/13/2014)
Sean Lange (6/13/2014)
Grant Fritchey (6/13/2014)
NOt a great game, but not a bad one so far. First one I've had on so far this World Cup. I..."The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Slow Join
Without the execution plan, I couldn't tell you why the other method ran slowly. It could be that the foreign key constraint isn't trusted. This would be because the WITH...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Are the posted questions getting worse?
Sean Lange (6/13/2014)
Grant Fritchey (6/13/2014)
NOt a great game, but not a bad one so far. First one I've had on so far this World Cup. I missed last night's game..."The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Are the posted questions getting worse?
NOt a great game, but not a bad one so far. First one I've had on so far this World Cup. I missed last night's game with Brazil. Heard it...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 15 posts - 7,966 through 7,980 (of 22,219 total)