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,958 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,571 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
8,417 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,129 reads
Blogs
When It’s Still Viable
By Brian Kelley
If a technology is still viable, don’t overlook it. Don’t get caught up chasing...
T-SQL Tuesday #179: The Detective’s Toolkit
By Steve Jones
It’s time for the monthly T-SQL Tuesday blog party. This month a longtime friend,...
Moving T-SQL Tuesday to Jekyll
By Steve Jones
I got a message a few months back that Microsoft was deprecating the MySQL...
Forums
What are the dimensions of a 55-inch TV?
55 inches represent the diagonal length of the TV screen. The dimensions are important...
Starting to Estimate Disk Storage for Memory-Optimized Tables
Comments posted to this topic are about the item Starting to Estimate Disk Storage...
Keep. It. Simple.
Comments posted to this topic are about the item Keep. It. Simple.
Question of the Day
Starting to Estimate Disk Storage for Memory-Optimized Tables
If I have durable memory-optimized tables, what is the starting point for estimating storage space?
See possible answers