Viewing 15 posts - 15,406 through 15,420 (of 22,219 total)
Alvin Ramard (4/22/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
April 22, 2010 at 10:37 am
Gianluca Sartori (4/22/2010)
Jack Corbett (4/22/2010)
Gianluca Sartori (4/21/2010)
Public const SC AS String = "'" 'Yes, you got it right, it's...
"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
April 22, 2010 at 8:12 am
Personally, I shy away from it in almost all situations. Alternatives are to enable snapshot isolation, so that you can read rows while the data is being manipulated. Or, 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
April 22, 2010 at 7:04 am
Paul White NZ (4/22/2010)
Chris Morris-439714 (4/22/2010)
Well I can't see what you're on about. Must be a rare defect of the optic nerve.SOM
White phosphorous? I'm not sure, that could be overkill.
"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
April 22, 2010 at 6:58 am
Joy Smith San (4/22/2010)
The executable is SQL Server.
But for SQL Server 2005 the executable is "SQLWB.EXE" no ?
To really understand performance issues, you need 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
April 22, 2010 at 6:57 am
jcrawf02 (4/22/2010)
Anyway, if it's...
"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
April 22, 2010 at 6:46 am
Arjun Sivadasan (4/22/2010)
@Grant: What do you mean by missing rows? Rows that are there in the dataset but not present in database as a result of...
"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
April 22, 2010 at 6:43 am
trivedi.nikesh (4/22/2010)
Last week we designed a query to generate a report. Initially this query was running fine fetching all records in 10 sec, but this week it is running...
"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
April 22, 2010 at 6:42 am
Joy Smith San (4/22/2010)
One of our client was complaining that their application has become too slow now.
It used to be fast enough. I went there and checked the server.
Following...
"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
April 22, 2010 at 6:37 am
Since it's an optional key word, I suspect as well that it's to support the ANSI standard. It may also be to keep the language consistent because you have 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
April 22, 2010 at 6:34 am
You can also use the logical name of the file if you have it.
DBCC shrinkfile('MyFileName',2)
But, shrinking files should only be done if you know, for sure, that the files aren't...
"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
April 22, 2010 at 6:26 am
Lowell (4/22/2010)
Grant Fritchey (4/22/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
April 22, 2010 at 6:22 am
You've actually already outlined most of the work involved. SSIS packages can be moved as files. To move the agent jobs, you just script them out and then run 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
April 22, 2010 at 6:16 am
It won't matter which database you run it from. Contention, despite the nolock hints, can cause things to slow down.
You do know that nolock doesn't just mean the classic "dirty...
"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
April 22, 2010 at 6:10 am
How many databases do you have? That's how many transaction logs you have.
That article is a good introduction.
"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
April 22, 2010 at 6:07 am
Viewing 15 posts - 15,406 through 15,420 (of 22,219 total)