have you used a cache file , is it up to date ?

Hi Sergiy

I can demonstrate what I am explaining in my video , no gimmicks just plain tables and rows.If you have a few minutes , please add me on skype...

merge operator doesn't require the same column structure or number, it can be used to combine results from table that have different number of columns , I am not sure...

covering indexes and included columns are fine for OLTP systems but for DW where the base tables are already in 100 of GB or TB it doesn't become viable. Design...

Mainly I think the reason this discussion is dragging on is because there is a misconception of how indexes work for OLTP system vs DW systems. best practices for 1...

Here are the scripts , I usually create the video to show the steps to reproduce the issue, mostly for those cases where it more important to...

Big table resides in a single file , it can be made to sit in multiple files but without any control over which row goes into which file ( proportinal...

select * from sys.columns where column_id in (

select column_id from sys.index_columns where index_id =(

select index_id from sys.indexes

where object_name(object_id)='DELIVERY_IN')

and object_name(object_id)='DELIVERY_IN'

)

and object_name(object_id)='DELIVERY_IN'

a virtual machine hosted on a cloud provider like Azure or AWS would help , all you need is a internet connection at that point, but you are at the...

One can always hope 🙂

I wonder if we should test OLTP performance using data sets instead of actual row by row operations that will be encountered in production.

Its one of...

Horizontal table partitioning , link with performance characteristics document below

http://enabledbusinesssolutions.com/blog/does-partitioning-improve-performance/

Hi Sergiy

Clustered index only works when searching on the key column, it fails for all other DW use cases. A DW doesn't perform seeks it performs scans ( nobody fetches...

Partitioning can improve performance mainly in the following ways

-For very large tables partition elimination does provide real benefits

-Disk placement of files - striping the data where different months...

I guess there is no harm in leaving it as is , but i noticed that File and FileGroup backups can no longer be restored once this happens because...

I tried the above link and it gives the message

The filegroup 'Defunct_FG' cannot be removed because it is not empty.

Way to recreate the issue ,

- Create a...