Interesting stuff. Thank you Mr Guru.

I would also ask you to bear in mind that although partitioning can work if one or more of the file groups is offline, this relies on partition elimination at...

Maybe. I hope I get a proper answer - I'm kinda nervous about posting about...

Ian Scarlett (9/9/2009)

---

Adding the column constraint outside the column defintion has to use the slightly different syntax alter table #temp ADD fred int null, CONSTRAINT DFx DEFAULT (0) for fred...

ALTER TABLE dbo.TableName ALTER COLUMN Quota INTEGER NOT NULL;

It may be an awesome and flawless product. I might have to check it out too.

I'd like to think there will always be a place for (appropriately remunerated) hand-tuning...

Bob Hovious (9/9/2009)(1) The presence of the byte is itself a flag of some sort.

After all it DOES tell you whether an index was an original...

No, no - crontab = awesomeness 🙂

[font="Courier New"]Msg 2627, Level 14, State 1, Line 1

Violation of PRIMARY KEY constraint 'PK_BusinessStrategy_UserID'. Cannot insert duplicate key in object 'dbo.Puns'.

[/font]

Nice...

For...

I see. ARe you able to rename the file from Windows explorer? That will...

Sorry. Let me illustrate my thinking:

CREATE TABLE dbo.Test

(

col1 INTEGER NOT NULL CONSTRAINT...

Yes 🙂

PaulB (9/9/2009)

---

Oh yes, you can automate it.

1... pack provided sql code into a .sql file

2... write a shell script that would set environmentals and log into sqlplus then execute sql...

If you do go the file group backup route, be sure you fully understand the restore options and the need to start and restore with the PRIMARY file group. ...