Viewing 15 posts - 19,411 through 19,425 (of 22,219 total)
Several of the Red Gate people haunt these forums. Hopefully they'll pick it up & run with it. Contact them and offer your services. I'd like to see a cheaper...
"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
October 21, 2008 at 8:10 am
I'm sure you can move the backups, but I don't think you move the logs. I see Quorum there. That usually means a cluster. Which further means that all 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
October 21, 2008 at 6:06 am
Also, if you can, post the actual execution plan. This can show where you have missing or incorrect indexes, indicate the possibility of out of date statistics... all useful stuff...
"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
October 21, 2008 at 6:01 am
Do you mean compare the data or compare the structures?
Rachel is right, Red Gate & Apex both offer great tools for doing either of these operations. I prefer the Red...
"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
October 21, 2008 at 5:59 am
Barkingdog (10/20/2008)
Grant,You wrote
>>>
..we are relying on tools like Visual Studio Team System Database Edition.
>>>
I didn't think that VSTS, yet, offered any database design tools at all. (Am I wrong?)
Barkingdog
You're not...
"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
October 21, 2008 at 5:43 am
You'll have to drop and recreate the primary key. Which means if the table is acting as the parent in referential constraints, you'll need to drop and recreate those references...
"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
October 20, 2008 at 1:10 pm
Considering the size of the table, yeah, I'd suggest a defrag. I wouldn't necessarily do a rebuild at with an index this size and this level of fragementation, but 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
October 20, 2008 at 12:19 pm
I think you're a bit confused by online & offline. Neither one requires access to the database to be stopped. The offline option only heavily, negatively, affects the creation 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
October 20, 2008 at 11:01 am
UPDATE STATISTICS is the best command for working with statistics since it has the most flexibility. However, for batch work, sp_updatestats can do all the stats on a database.
"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
October 20, 2008 at 8:48 am
Here are some tutorials over at JumpstartTV that might help too:
This one exactly answers the question:
http://www.jumpstarttv.com/generating-sql-server-scripts-using-smo_425.aspx?searchid=3347
This one discusses capturing changes
http://www.jumpstarttv.com/capture-schema-changes-with-smo_412.aspx?searchid=3347
Here's the full list.
http://www.jumpstarttv.com/Search.aspx?terms=smo
"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
October 20, 2008 at 8:44 am
You could also try to the tools from Red Gate (www.redgate.com).
You could use a coding language and make a call to SMO (SQL Management Objects) to generate the scripts. Since...
"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
October 20, 2008 at 7:55 am
Also answered here:
http://www.sqlservercentral.com/Forums/Topic588077-149-1.aspx?Update=1
"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
October 20, 2008 at 7:46 am
Do you mean running scripts from the command prompt? Check out the functionality of sqlcmd.exe.
"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
October 20, 2008 at 7:46 am
In addition to how to create an index, you might want to know about where to create them:
http://www.sqlmag.com/articles/index.cfm?articleid=5113
http://www.sqlservercentral.com/articles/Performance+Tuning/2770/%5B/url%5D
"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
October 20, 2008 at 7:41 am
We've been using ER diagrams less and less for development and instead relying on tools like Visual Studio Team System Database Edition. But we still do use ER diagrams 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
October 20, 2008 at 7:35 am
Viewing 15 posts - 19,411 through 19,425 (of 22,219 total)