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...

you can view the partitioned objects using these queries:

USE [DPartitioning]

/*

show partitioned objects

*/

select distinct

p.[object_id],

TbName = OBJECT_NAME(p.[object_id]),

index_name = i.[name],

...

IMO you are turning your cat inside out.:ermm:

If you stick to this bad design, your queries will not perform well !!

resulting in slow applications and over utilised servers.

If you install...

be sure to include the objects schema ! (even if it is dbo)

don't use reserved words in your objects or always use brackets !

In your case it was object "user"...