Viewing 15 posts - 9,511 through 9,525 (of 22,224 total)
I currently work for Red Gate, but, prior to my employment here, I worked with the Red Gate tool belt for 10 years as a DBA. My love for 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
September 27, 2013 at 3:40 am
The options are, query the dynamic management objects (DMO) such as sys.dm_exec_requests while the query is running in order to see which locks are taking a long time during execution....
"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
September 27, 2013 at 3:36 am
You might want to take a look at SQL Server Integration Services, SSIS. That's the standard Extract, Transform, Load (ETL) tool for SQL Server.
"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
September 27, 2013 at 3:28 am
hisakimatama (9/26/2013)
SQLRNNR (9/26/2013)
hisakimatama (9/26/2013)
Working with the company's vendor software, and one of the reports is coming across super-slow, about 10 minutes 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
September 27, 2013 at 3:15 am
This is really down to opinion, but my feelings on it are, you should add comments for clarity.
If you're doing something really complex in T-SQL, tell us what it is....
"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
September 26, 2013 at 4:41 am
Talib123 (9/25/2013)
Grant Fritchey (9/25/2013)
"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
September 25, 2013 at 7:53 am
Bhuvnesh (9/25/2013)
Grant Fritchey (9/25/2013)
Log backups are different.But how does the LSN get matched ? i mean their sequence because that will be required to ordered restore
Take a...
"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
September 25, 2013 at 7:31 am
Full backups and the log backups are disconnected. You can go back to BackupA and then run all the transaction logs. Full backups and log backups are not linked like...
"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
September 25, 2013 at 6:59 am
The backup process is a page by page copy of the database. So the restore process is the same. For any object to simply be missing means that it was...
"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
September 25, 2013 at 4:45 am
sunny.tjk (9/24/2013)
Grant Fritchey (9/14/2013)
"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
September 24, 2013 at 4:45 pm
Without looking at execution plans, nope. I can't tell you what's happening. Adding the TOP doesn't "actualize the table in tempdb" whatever the heck that means. It does give 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
September 24, 2013 at 8:43 am
Check sys.dm_exec_requests while the query is running to understand what is causing it to wait. That's the best method. Anything else is just guessing.
"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
September 24, 2013 at 8:37 am
Just piling on, but, no execution plan, we're just making crazy guesses that will likely have absolutely no bearing on reality.
Oh, and no_lock... that is just such a dangerous crutch...
"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
September 24, 2013 at 7:15 am
I primarily only use table variables where I need to avoid recompiles for some reason. Otherwise, the cost incurred by the lack of statistics is almost always not worth it.
"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
September 24, 2013 at 7:09 am
In order to rearrange the index, SQL Server must put locks on that index. While locked, other users can't get access to it. The way around this is, if you're...
"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
September 24, 2013 at 7:05 am
Viewing 15 posts - 9,511 through 9,525 (of 22,224 total)