Viewing 15 posts - 15,406 through 15,420 (of 22,221 total)
Temp table or not, this code:
((LTRIM(RTRIM(lt.name))
Is going to kill your performance. It's going to prevent any indexes on the tables from being used and you'll see nothing but table...
"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 1:16 pm
yoacer (4/22/2010)
I need to find a different solution Dynamic SQL is not what I want, I want another kind of solution even if I need to create a filter...
"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:41 am
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
Viewing 15 posts - 15,406 through 15,420 (of 22,221 total)