Viewing 15 posts - 17,176 through 17,190 (of 22,221 total)
jason (6/17/2009)
thanks , i will give it a try...By the way,
How to optimize tempdb if i want to use Snapshot Isolation
There are several white papers on optimizing tempdb available...
"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
June 18, 2009 at 5:38 am
I don't understand what ISQLW does that SQLCMD does not?
From the sounds of it, you really might benefit from Powershell.
"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
June 18, 2009 at 5:31 am
Gail is 100% correct.
You could look into using snapshot isolation as a way to reduce locking issues. It increases the load on tempdb and some on the CPU, 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
June 17, 2009 at 9:30 am
Import/Export uses SSIS. You can go to SSIS directly. It's more work, but you can make a more efficient DTL.
"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
June 17, 2009 at 9:24 am
In a perfect world, no. In reality, yeah. But specifically what would be the difference? I'm not sure. I haven't found the export wizard to create the most efficient ETL...
"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
June 17, 2009 at 8:38 am
There is a template, but, like Gus says, unless they do precisely the same thing every time to create a new proc and no one ever just starts typing (same...
"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
June 17, 2009 at 8:10 am
Assuming the source tables are not being updated, no, it should only be putting shared locks on them for reading. It might cause excessive I/O, memory, or CPU use while...
"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
June 17, 2009 at 7:56 am
SAT_SQL (6/17/2009)
This is regarding the Trace & DTA.
Question:
1)
I am working in sql-2005,If i want to no that weather the Trace 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
June 17, 2009 at 7:54 am
I think you've already hit the best option, use trace events to see what calls have come through. You can also query the system cache to see what's there, 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
June 17, 2009 at 7:45 am
You might want to post this in Scripts area (look to the left, just below forums on the menu choices). It's more likely to be found by people looking for...
"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
June 17, 2009 at 7:43 am
Yeah, I was going to suggest SQLCMD as well.
Plus, why are you manually opening all kinds of windows in SSMS to do manual updates all day long? You should be...
"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
June 17, 2009 at 7:38 am
As far as documentation goes, use the stuff that comes with VSTS:DBE. It's pretty complete, especially on installs.
You wouldn't need to uninstall Visual Studio to install the Team Edition. 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
June 17, 2009 at 7:35 am
Excellently stated. I wish I had been able to come up with these exact arguments a year ago when one of our major projects started down the object database path....
"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
June 17, 2009 at 6:03 am
A foreign key constraint can only be placed on a primary key or on a unique constraint. So, if the parent table has another column that you can place 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
June 16, 2009 at 4:56 am
GSquared (6/15/2009)
Grant Fritchey (6/15/2009)
Crap, The Thread passed me this weekend and I didn't even notice. It's officially the 15th highest poster on SSC now.
Not sure what you mean. I...
"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
June 15, 2009 at 12:37 pm
Viewing 15 posts - 17,176 through 17,190 (of 22,221 total)