Compatibility mode?

Sidebar: stop using DB..Table - specify the schema instead of expecting SQL Server to find the correct schema for the table.  That is dependent on the default schema...

Just a post to expose page 2 because of the forum fault in that area.

While I agree with Jeff in the sense that "if the system is designed in one way, why change it to work a different way", I think I would...

To add another 2 cents, I totally agree with David Wiseman.  Storing the full path instead of just a file name can be a horrible idea for the very reasons...

The only time that I've used ONLINE Index Rebuild was during testing on some test tables.  I've never tested for a "cancel" of an ONLINE Rebuild like you folks accidentally...

Imagine a view is created - that references a computed column which only exists to give the column a different name - and aliases the computed column...

I'll likely be alone on my take on this but "It Depends" on a whole lot of things.

When I first started at a company that I do work for, they...

Heh... not bad for something that used to be natively available on the f4 key until they came out with SQL Server 2005. 🙁  What a bummer that was (and...

Have you considered just making a large test table and testing it?

As a bit of a sidebar, I've not found any performance improvement that I can relate to the "new" CE but have a whole bunch of slowdowns that I can...

You can also add a computed column to the table - but I really don't see the need or requirement to create a column with multiple names.  It is...

Not if you understand that each row is unique and can have only one rate.  Either convention is just...

Hi

I have dataset like this

drop table if exists #dataset create table #dataset(CIF VARCHAR(255), PARENT_CIF VARCHAR(255), UP_CIF VARCHAR(255))

INSERT INTO #dataset SELECT 45218547, 54044082, 54044082 union all SELECT 54044082, 64349595, 64349595...

😀

It would appear that the author of the article has left the building. 🙁