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,425 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,550 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,356 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,046 reads
Blogs
Azure Platform Series: How to setup Azure Cloud Shell
By HamishWatson
This blog post will be a series on the Azure Platform and some things...
Daily Coping 5 June 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
Use Chocolatey to Install Multiple SQL Server 2019 Instances for Testing
I’m working on a project where it’s useful to automate environment setup and teardown...
Forums
Attach and Detach Method vs SQL Manage object method
Hi there, if you want to detach a database you would right click on...
How to generating Excel File with multi sheet by using SQL server 2012?
I need to create stored procedure or query or any thing on SQL server...
performance tuning for a subquery
Hey Guys I have a quick questions regarding a better way to write a...
Ask SSC