2018-12-13
1,042 reads
2018-12-13
1,042 reads
How to identify backup tables within production databases that can be removed.
2018-10-05 (first published: 2018-09-28)
516 reads
2016-09-01
1,477 reads
2016-05-03
1,496 reads
Paul Randal continues his knee-jerk performance tuning series, focusing on ways to optimize performance when using temporary tables.
2016-04-25
6,231 reads
2016-04-06
1,770 reads
2015-07-21
1,775 reads
2015-04-10
2,058 reads
'Temporal' tables contain facts that are valid for a period of time. When they are used for financial information they have to be very well constrained to prevent errors getting in and causing incorrect reporting. This makes them more difficult to maintain. Is it possible to have both the stringent constraints and simple CRUD operations? Well, yes. Dwain Camps patiently explains the whole process.
2015-03-26
9,819 reads
2014-05-23
2,251 reads
By Steve Jones
I had a lot of local branches for a repo (actually a few repos)....
Are you ready to take your SQL skills from theoretical to tactical? If you've...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers