Viewing 15 posts - 1 through 15 (of 155 total)
Steve, you'll be happy to know that SQL is smart enough not to allow an included column to be used if it's already in the index key:
CREATE NONCLUSTERED INDEX ncixtest...
March 21, 2011 at 8:44 pm
george sibbald (3/18/2011)
Craig Farrell (3/17/2011)
Rem70Rem (3/17/2011)
What are the steps to rollback if needed?
Generate a new filegroup, move *everything* into the new filegroup. Rebuild the original Primary as desired, move...
March 18, 2011 at 5:02 am
I strongly dislike that dialog box. * might be considered too dangerous to use, and so won't work. You may need to create three different steps, one for each extension....
March 17, 2011 at 6:48 pm
george sibbald (3/17/2011)
rollback -dbcc shrinkfile with the emptyfile option, followed by alter database command to remove the file.
That would work (and was my first thought too), but I think I...
March 17, 2011 at 6:39 pm
It's usually around a 15 minute outage, but I like to set aside a 30 minute window just in case I need to reboot.
You'll definitely want to test/practice the process...
March 17, 2011 at 6:35 pm
Just to clarify Lowell's reply - the page written to the transaction log only has enough room to store 8060 bytes of data. While you might be able to squeeze...
March 15, 2011 at 7:50 pm
SQLkiwi (3/15/2011)
Don't forget Australia (though not in the session itself, unless I missed that).
Nah, it's alright. We're used to being forgotten. Used to being insulted too 🙂
March 15, 2011 at 7:23 pm
Users with db_ddladmin rights on a database have the following (from http://msdn.microsoft.com/en-us/library/ms189612.aspx):
Granted: ALTER ANY ASSEMBLY, ALTER ANY ASYMMETRIC KEY, ALTER ANY CERTIFICATE, ALTER ANY CONTRACT, ALTER ANY DATABASE DDL TRIGGER,...
March 15, 2011 at 7:19 pm
What's your database's compatibility level? If it's set to 80, you'll receive this error.
March 15, 2011 at 6:52 pm
I'm going through this at the moment, and my best solution so far is to open up every DTS package, view the package properties (on the toolbar or right click...
March 15, 2011 at 4:55 am
I'm torn with nvarchar. The idealist in me loves the idea of a single unified character set, but the side of me that loves performance refuses to waste space for...
March 15, 2011 at 12:31 am
Bristolred, you are correct that x86 is limited to only 4 GB of addressable memory, of which 2 GB is reserved for the OS by default (this can be changed...
March 14, 2011 at 7:22 pm
Hi Jules,
If you create a local Windows account on both machines (MDW and REMOTE) with the same username and password (e.g. MDW\mdw_user and REMOTE\mdw_user), they should be able to connect...
March 9, 2011 at 1:48 am
Even if you were to create TABLE2, and cluster it so that it is ordered on column C, you're still not guaranteed to return the rows in order unless you...
March 8, 2011 at 7:46 pm
Hi Jules,
I went through this last week while configuring MDW in a test environment.
Assuming two servers, MDW and REMOTE on the same AD domain, the simplest solution is to...
March 8, 2011 at 5:14 pm
Viewing 15 posts - 1 through 15 (of 155 total)