2012-08-24 (first published: 2007-09-29)
1,639 reads
Get Modified Objects As on Date
This table Valued Function return the Modified Objects (SP /Views) For the Date specified.
2011-10-07 (first published: 2007-11-23)
1,359 reads
2010-10-27
3,175 reads
2010-07-29
2,608 reads
2010-01-21
3,799 reads
2010-01-15
3,299 reads
2009-11-13
3,162 reads
Ultimate Alter Script generator
In development enviornment we always get the modifications in tables from developers.As far as my concern writing scripts is tedious work for us. I hope below script will help you.
2009-10-30 (first published: 2009-10-01)
1,192 reads
2009-10-21 (first published: 2009-10-01)
2,231 reads
2008-10-10 (first published: 2008-07-20)
1,845 reads
Blogs
DBA Myths: The system sessions are the ones with a session_id 50 or less
Anecdotally any session_id that’s 50 or less is going to be a system session...
SQL Undercover TV – Encrypting SQL Backups
In this episode, David looks at how we can encrypt our SQL Server backup...
Using volumes in SQL Server 2019 non-root containers
I’ve seen a few people online asking how to use docker named volumes with...
Forums
Numeric and Decimal
Comments posted to this topic are about the item Numeric and Decimal, which is...
missing storage space
Hi I have a particular drive on one of my sql servers, it's gotten...
Issue with processing dimensions
Hi all I've got a weird one here. We have a multi-dimensional cube...
Ask SSC