The purpose of this code is to create a T-SQL output that can be execute on SQL Server (2005 and higher) to recofigure the SQL server as compared to the settings on which you have executed this code from.
2010-10-14 (first published: 2010-10-05)
1,373 reads
A Flexible Day Of Week Function where a criteria can be passed as an integer to a stored procedure.
2010-10-13 (first published: 2010-10-06)
1,387 reads
This SP will monitor T-Log space and sends mail to DBA if log space usage is above threshold value
2010-10-05 (first published: 2010-10-03)
3,501 reads
2010-10-04 (first published: 2010-09-29)
2,920 reads
I came across a project which required a list of all columns within a server and thought I would post it here in case anyone else had this requirement.
2010-09-30 (first published: 2010-09-28)
1,565 reads
2010-09-29 (first published: 2010-09-28)
1,629 reads
I was asked to do so by one of my colleague. So, I thought to share it with you how to use multiple LIKE conditions.
2010-09-16 (first published: 2010-09-15)
3,780 reads
This script shows you code that retrives schema of a routine (Stored procedure or a function).
2010-09-09 (first published: 2010-09-04)
1,981 reads
2010-09-08 (first published: 2010-09-02)
2,359 reads
Do you need to take your mind off of the SQL mess you are dealing with? Try my funny words generator.
2010-09-03 (first published: 2010-08-27)
2,656 reads
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
Is there a good syllabus for reading these two together? (Yes, it's called the...
Comments posted to this topic are about the item GPX distance and time analysis...
Comments posted to this topic are about the item The DBA is Dead; Long...
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers