Viewing 15 posts - 5,641 through 5,655 (of 9,712 total)
Not sure I understand your question.
I'd drop and recreate the stored procedure with those commands added to it.
June 23, 2011 at 8:56 am
1) Backup the database, restore it to the new machine
2) Add 5 new files to your default filegroup, each pointing to a different drive.
3) Move the data from the...
June 23, 2011 at 8:04 am
Jeff Moden (6/23/2011)
Craig Farrell (6/20/2011)
Don't even get me started on the incredibly interesting answers I've gotten for "Describe two differences between Truncate and Delete".
BWAAA-HAAA!!!! Such easy questions! 😉 Everyone...
June 23, 2011 at 7:37 am
Oh, wait. I forgot about table partitioning. You could probably do that.
1) Backup the database, restore it to the new machine with each of the existing files on a different...
June 23, 2011 at 7:25 am
Your title indicates something different from what your post says. Are you dealing with multiple files in one filegroup or multiple filegroups?
EDIT: The reason I ask is that you can...
June 23, 2011 at 7:21 am
The advisor doesn't tell you about all errors. Syntax errors, for instance, I believe aren't registered by the advisor.
June 23, 2011 at 7:16 am
Is T a logical or physical drive? Is it a SAN? Can you add more space to it without having to move anything?
I'm assuming from your description that you only...
June 23, 2011 at 7:09 am
chris.caines (6/23/2011)
Brandie Tarvin (6/23/2011)
Chris,Is this an upgraded database from SQL 2000?
No, this was a straight 2005 install originally. The backups have worked a long time in the past, but...
June 23, 2011 at 7:06 am
If you are downloading services packs and not SQL Server itself, then you cannot use them to install SQL Server. You need the actual SQL Server .msi file to installing...
June 23, 2011 at 7:01 am
What type of files are they?
June 23, 2011 at 6:48 am
You don't run the Upgrade Advisor during the migration. You run it before the migration so you know what problems to fix before the migration.
Use the SQL 2008 Upgrade Advisor....
June 23, 2011 at 6:47 am
Honestly, I don't know if that query will cause RBAR without seeing the DDL for both tables and some sample data to test with.
June 23, 2011 at 6:45 am
Chris,
Is this an upgraded database from SQL 2000?
June 23, 2011 at 6:39 am
paul.knibbs (6/23/2011)
Steve Jones - SSC Editor (6/22/2011)
I like plumbers. They seem to do a better job than I do at hooking pipes together
Yeah, but ask them to do a simple...
June 23, 2011 at 5:11 am
Viewing 15 posts - 5,641 through 5,655 (of 9,712 total)