Compare 2 datasets and output delta in one TSQL statement
There are many ways 2 compare datasets to find differences, this is one of them.
2011-11-04 (first published: 2011-10-21)
2,248 reads
compare data
RE: Index for column with a lot of Null
---------------------------------- quote: Creating a composite index will not work in my situation. This is becuase those three columns are in the Where clause of three different SPs. -------------------------------------- I still don't see why you wouldn't use a composite index. As long as the first column is referenced in the query then the index will be […]
2003-08-27
RE: Index for column with a lot of Null
Yes, this is a very highly transactional table. There are about 10 processes querying and updating this table every other seconds...
2003-08-27
Blogs
Monday Monitor Tip: Compliance Checking for Old Versions
By Steve Jones
A customer recently wanted to know if any of their instances were too old...
Making Legend Order Match Segment Order in a Power BI Stacked Column Chart
A reader of one of my previous posts pointed out that the legend order...
The Only Valid Test of a Backup is a Restore
Please, let me reiterate: The only valid test of a backup is a restore....
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers