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,408 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,544 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
5,839 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,037 reads
Blogs
Weekly reading #22
By damianwidera
A little bit late but it is here! It is Wednesday already and we...
A simple powershell script to look up server hardware and OS information
By SQLPals
This is a simple powershell script to query and display hardware and OS information...
Collecting Server Performance Metrics: Performance Monitor
Whether you’re a DBA/administrator looking to tune a server, planning for hardware updates, or...
Forums
Evergreen SQL Server
Comments posted to this topic are about the item Evergreen SQL Server
Do you really know what’s happening with your servers?
Comments posted to this topic are about the item Do you really know what’s...
Going from long to wide
Comments posted to this topic are about the item Going from long to wide
Ask SSC