Viewing 15 posts - 15,421 through 15,435 (of 22,227 total)
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
homebrew01 (4/21/2010)
Grant Fritchey (4/21/2010)
As far as I know, if you stop the server, the trace stops and has to be restarted.
Not the default trace. That's different. But it doesn't capture...
"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 5:57 am
jcrawf02 (4/21/2010)
And now for something completely different...
Any advice on ridding my lawn of 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 5:17 am
jcrawf02 (4/21/2010)
GregoryF: "don't worry about not knowing how many instances/servers there are, every where I have ever worked, no one know all of them, there are some that are barely...
"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 5:14 am
WayneS (4/21/2010)
sergei.gorelik (4/21/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 21, 2010 at 7:53 pm
Lowell (4/21/2010)
i thought a server side trace starts when you run the command EXEC sp_trace_setstatus @traceid, 1, and runs continuously. rebooting or stopping/starting 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 21, 2010 at 7:53 pm
Jeff Moden (4/21/2010)
Grant Fritchey (4/21/2010)
So in summary, Oracle Sucks!Thanks for that important safety tip Jeff.
Heh... I'll probably get slammed by the folks that like Oracle (not slamming them, though), but...
"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 21, 2010 at 1:42 pm
To start it automatically after a reboot? The only way I know is through the start up script which you don't want to run.
"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 21, 2010 at 1:06 pm
Viewing 15 posts - 15,421 through 15,435 (of 22,227 total)