Checking All Date Columns in a Table(s)
Find minimum and maximum values for all date columns in a table or range of tables, using a mask.
2016-09-15 (first published: 2014-10-27)
2,857 reads
Find minimum and maximum values for all date columns in a table or range of tables, using a mask.
2016-09-15 (first published: 2014-10-27)
2,857 reads
An alternative to tree traversal, and ultimately more efficient way to look at organizational structures is presented.
2014-09-15
7,571 reads
How to get an SSRS user's AD group membership in order to filter report content
2013-06-03
8,332 reads
History table needs individual rows for each column that has been updated, i.e., a column history.
2012-12-17 (first published: 2012-12-04)
1,121 reads
By Steve Jones
Recently I’ve been looking at archiving some data at SQL Saturday. As a start,...
Buckle up, database wranglers! Nowadays, SQL DBAs hold the keys to a company's most...
By DataOnWheels
Picture this, your data ingestion team has created a table that has the sales...
Comments posted to this topic are about the item Crazy Interviews
Comments posted to this topic are about the item The Query Traceflag
Comments posted to this topic are about the item Using Machine Learning Pipeline Execution...