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,446 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,446 reads
An alternative to tree traversal, and ultimately more efficient way to look at organizational structures is presented.
2014-09-15
7,555 reads
How to get an SSRS user's AD group membership in order to filter report content
2013-06-03
6,893 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,050 reads
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Windows Subsystem for Linux is probably my favourite feature of Windows 10. It gives...
By Steve Jones
With SQL Saturdays being rebooted, and the SQLSaturday.com website live, it’s time for events....
During installation of SQL Express Server 2014 i have this error Title: Microsoft SQL...
Hi all We've got a linked server from SQL 2016 to an accdb...
Hi everyone, Any good suggestion to tune below query: --CREATE NONCLUSTERED INDEX nonclust_code...