Viewing 15 posts - 17,191 through 17,205 (of 22,226 total)
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
Our plans are to perform most of our upgrades as side-by-side upgrades, meaning we install a new server with SQL Server 2008 and then backup & restore the 2000 databases...
"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:17 pm
No. It can't be changed.
If you need perfectly synchronized incrementally increasing numbers, you should come up with a mechanism to create them. That's not the purpose of the Identity column....
"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:09 pm
This is such a common problem. Rather than trying to roll your own queries every time you need to do this, pick up one of the third party tools 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
June 15, 2009 at 12:04 pm
TRACEY (6/15/2009)
Processors 8 CPU
processor affinity ...
"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 10:59 am
GilaMonster (6/15/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
June 15, 2009 at 10:52 am
Crap, The Thread passed me this weekend and I didn't even notice. It's officially the 15th highest poster on SSC now.
"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 9:21 am
GilaMonster (6/15/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
June 15, 2009 at 9:19 am
GilaMonster (6/15/2009)
Grant Fritchey (6/15/2009)
GilaMonster (6/15/2009)
Any thoughts on who's going to take the FIFA Confederations Cup this year?
I seriously doubt it'll be the US, but I always hold on to 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
June 15, 2009 at 7:51 am
GilaMonster (6/15/2009)
I thought Rockies were mountains.Any thoughts on who's going to take the FIFA Confederations Cup this year?
I seriously doubt it'll be the US, but I always hold on 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
June 15, 2009 at 7:14 am
It's not really possible to determine which procedures are not used. Instead, you need to determine which procedures are used and then, by process of elimination, you can choose 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
June 15, 2009 at 7:12 am
Viewing 15 posts - 17,191 through 17,205 (of 22,226 total)