Let's say (hypothetically :cool:) that I have a table with 100 million rows, averaging about 800 bytes each. It has an ID field which is a GUID -- and we...

That's what I thought. Thanks for the clarification, Grant.

nick.mcdermaid (10/14/2010)

---

If you search on a covered non-clustered index on a table with a clustered index, you get a bookmark lookup where the index goes and looks up the row...

Grant,

Thanks for the reply. Sounds like there isn't complete consensus on whether GUIDs are valid for clustered indexes or not. So far, we've not seen significant performance impact where we've...

Yes, after you're restarted the server instance. You'll know it is no longer in use when the OS allows you to delete it; as long as it's attached by SQL...

Assuming tempdb logical names are the defaults (which they likely are):

USE master;

GO

ALTER DATABASE tempdb

MODIFY FILE (NAME = tempdev, FILENAME = 'H:\SQL\tempdb.mdf'); -- as in 'c:\tempdb.mdf'

GO

ALTER DATABASE tempdb

MODIFY FILE (NAME...

I simply used the...

This may be a little clunky, but it works. Downside is that it is limited to varchars of only 4 chars/digits. It also uses 4 punctuation characters that may interfere...

Yes, you have to drop old column and add a new one.

ALTER TABLE dbo.MyTable

DROP COLUMN OldComputedColumn

ALTER TABLE dbo.MyTable

...

The statements appear identical, so maybe you're overlooking the obvious...?

Are you running this against the right database? (Maybe the table dbo.XXX exists in both so it's not throwing an error?)

Are...

According to BOL, you cannot disable a DEFAULT constraint. You CAN disable a FOREIGN KEY or CHECK constraint.

{ CHECK | NOCHECK } CONSTRAINT

Specifies that constraint_name is enabled or disabled....

Now THAT is really interesting -- and strange, indeed. This is actually very useful information. Thanks for posting!

drew.allen (8/9/2010)You can actually simplify this a little and it has the added advantage that it works without resorting to your assumptions. That is, as long as the one...

Mike Menser (8/9/2010)

---

I have been searching and finding nothing. Is there a simple syntax that I can use to achieve what I need? I have an old application that has...

It's highly unlikely that DOB would store hours/minutes/seconds so you really wouldn't need to go to this trouble. But just for fun let's say the field did store the...