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
Larry Schmidt
Another Way to Look at Trees
An alternative to tree traversal, and ultimately more efficient way to look at organizational structures is presented.
2014-09-15
7,555 reads
SSRS Report Content Filtering by User Group
How to get an SSRS user's AD group membership in order to filter report content
2013-06-03
6,893 reads
Update Trigger to Store Only Updated Column and Former Value
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
Blogs
Daily Coping 13 Apr 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Converting a SQL Server Docker image to a WSL2 Distribution
Windows Subsystem for Linux is probably my favourite feature of Windows 10. It gives...
Everyone Run a SQL Saturday in 2021
By Steve Jones
With SQL Saturdays being rebooted, and the SQLSaturday.com website live, it’s time for events....
Forums
Error installing SQL Server 2014 (both 32 & 64 bit versions)
During installation of SQL Express Server 2014 i have this error Title: Microsoft SQL...
Linked server to Access accdb database
Hi all We've got a linked server from SQL 2016 to an accdb...
performance tuning
Hi everyone, Any good suggestion to tune below query: --CREATE NONCLUSTERED INDEX nonclust_code...
Ask SSC