Can you post :

- the tables create statement (ddl)

- the partition function ddl statement

- the partition scheme ddl statement

- with the least overhead you could generate and execute truncate statements for every table. (truncate will only work if there are no FKs pointing to the table)

- or you...

VD (7/16/2008)

---

to SQLGuru,

can you please provide more info about the iLO driver bug? We've recently had issues with an HP box restarting without ANY errors in any of the...

it's the yolk that does it :w00t: 😀

Good notice Carl.

Another remark:

Keep in mind one should also join with information_schema.tables to find out what kind of table it is. (should be "base table" in this case)

information_schema.columns returns info...

try using this for the second test:

IF(@SFound = 1) SET @sql = @sql + 'ALTER TABLE [dbo].[ptNotes] ALTER COLUMN [Type] varchar(10) NULL;'

We've all had this kind of experience...

I hope this is not on a production database system.

Don't shrink the db unless you realy need to !

SQLServer needed the log-space to support your db !

Making a log-backup frees...

btw the HowTo for lock pages in memory:

See bol: "How to: Enable the Lock Pages in Memory Option (Windows)"

http://msdn2.microsoft.com/en-us/library/ms190730.aspx

One good starting point for MS might be to post the demo-applications and the related source-code.

As everybody knows, copy-paste is your best friend 😉

We've all seen the demo on db...

That's an enhancement indeed. Thanks...

Tran_Key NOT IN ( SELECT Tran_Key

...

Maybe you should first try to upgrade to SP2 including the latest cumulative update (CU8).

If the reinstall of SSMS doesn't help out ....

you may need to reinstall...

Ansi settings may indeed have an impact.

Also check the transaction isolation level.

(although IMO that shouldn't generate another exec plan)

Same query :crazy:

Are you sure the query is 100 % equal !

(included...

did you try to drop the full PK constraint ?

ALTER TABLE your_partitioned_table

DROP CONSTRAINT PK_ ... '_constraintname

You may not be able to drop the PK if you have foreign keys that...

IMO:

- a user cal is dedicated to a user ! ( may connect to any number of instances)

- a device cal is dediceated to a (client) device ! (may connect...