Viewing 15 posts - 18,166 through 18,180 (of 22,219 total)
Reading that BOL entry, I'll bet it's a holdover from 2005. It did work in 2005, but it doesn't seem to in 2008.
"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
March 2, 2009 at 6:26 am
I've never been able to do it either. When I'm working 2000 instances I just go back to sp_who2 and other TSQL methods for seeing what's going on. Not as...
"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
March 2, 2009 at 6:25 am
Free? No. But Red Gate's SQL Prompt is extremely inexpensive.
It won't help while writing the code, but ApexSQL has a free clean-up utility that will help you with formatting.
"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
March 2, 2009 at 6:23 am
You can store tableA data in TableC without a relation, but without a relation you have no way of knowing that the data is valid. If TableA data gets deleted,...
"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
March 2, 2009 at 6:21 am
You can manage 2000 databases from the 2008 Management Studio. Out of the box you can't edit DTS packages and I'm not sure how you would go about doing that....
"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
March 2, 2009 at 4:55 am
info (3/1/2009)
"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
March 2, 2009 at 4:52 am
That's way more information than can be easily answered in a post on a board. Performance tuning has three major areas of concern, the OS & Server, which you usually...
"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
March 2, 2009 at 4:45 am
I'd suggest a couple of different things. First, have you checked the execution plans on your select statements to be sure that the indexes on your tables are being used....
"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
February 28, 2009 at 6:11 am
I'd suggest getting all the database objects into source control. Then, make all your changes through the scripts, not by editing the database through Management Studio. You should very carefully...
"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
February 28, 2009 at 6:05 am
It's in the Books Online, the SQL Server documentation. Just look up sp_recompile and read what's there.
"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
February 28, 2009 at 5:59 am
David Sumlin (2/27/2009)
If not, almost makes me want 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
February 28, 2009 at 5:49 am
Ah, if you want to collect errors, this won't help at all. It's only going to show completed queries. You'll need to set up a server side trace.
Howerver, a slightly...
"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
February 27, 2009 at 8:53 am
Jeff Moden (2/27/2009)
"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
February 27, 2009 at 6:39 am
Profiler doesn't debug queries. It captures performance and behavior. I'm not aware of a third party tool that does everything that it does.
However, just because you don't have Profiler doesn'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
February 27, 2009 at 6:13 am
Just to help the newbiezzzzz a bit further, this is an Access bit of code you're writing, not T-SQL inside SQL Server 2005, right?
"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
February 27, 2009 at 6:06 am
Viewing 15 posts - 18,166 through 18,180 (of 22,219 total)