2017-05-16 (first published: 2017-05-05)
903 reads
2016-10-07 (first published: 2016-09-20)
1,537 reads
2015-10-21 (first published: 2013-12-26)
4,050 reads
Determine when a Stored Procedure was created and last altered
Determine when a Stored Procedure was created and last altered.
2015-02-25 (first published: 2013-12-26)
3,452 reads
Dynamically create drop user statistics scripts
Generate script to drop any unwanted user created statistics.
2015-02-24 (first published: 2013-12-26)
1,517 reads
2014-01-21 (first published: 2013-12-28)
2,243 reads
View Active Session SQL
This script can be used to view current SQL statements being executed for all or any one SPID.
2014-01-06 (first published: 2012-01-26)
4,293 reads
2013-12-02 (first published: 2013-11-18)
1,717 reads
Blogs
Modify Power BI page visibility and active status with Semantic Link Labs
Setting page visibility and the active page are often overlooked last steps when publishing...
T-SQL Tuesday #190–Mastering a New Technical Skill
By Steve Jones
It’s time for T-SQL Tuesday again and this time Todd Kleinhans has a great...
Getting Started with the MSSQL AI Agent in VS Code
By Steve Jones
Recently I was working in VS Code and I saw a walkthrough for the...
Forums
Azure elastic query credential question
I am trying to check out elastic query between two test instances we have...
Change Tracking Data Retention Options
Comments posted to this topic are about the item Change Tracking Data Retention Options
Requiring Technical Debt Payments
Comments posted to this topic are about the item Requiring Technical Debt Payments
Question of the Day
Change Tracking Data Retention Options
If I am running this code:
ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON (CHANGE_RETENTION=4 xxx);What are the possible choices for xxx? See possible answers