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

This isn't quite correct - neither CTEs or Views are executed (materialized).  Both will be incorporated into the outer query - and then the execution plan is generated.

Now, if...

Thank you for...

p.s.  CTEs are inherently NOT reusable anywhere except the query that they live in.  They can be referenced as many times as you need to with the understanding that they...