2010-04-01 (first published: 2010-03-31)
4,375 reads
Additional Articles
Use of regular expressions in TSQL
This script creates 2 new system functions :fn__testregexp(@String,@Pattern) returns int execute the method test(@String) on the regular expressions @Pattern returns : 0 : no match 1 : match null : one of the parameters was null anything else : error from sp_OA procedure fn__replaceregexp(String,@Pattern,@Replace) returns varchar execute the method Replace(@String,@Replace) […]
2007-06-14 (first published: 2004-04-07)
1,920 reads
SP_WHO_3 Powerful Filtering/Sorting Very Efficient
Hello,I posted this a while ago to several web sites. Someone found an obscure bug in it and I fixed it (newest script attached below). When I posted it to you last time, it didn't show up in any of the categories that I had checked; hmmmm? However, when I searched google, you have it […]
2007-06-13 (first published: 2004-09-28)
1,840 reads
ActiveX - Clean Up Unused Connections
This ActiveX Script runs in DTS Designer and will clean up all unused connection objects. This allows you to rename connections at will by selecting "New Connection" and typing a new name. It also allows you to copy and paste connections then rename them. Then you can cleanup leftover connections when development is complete.
2007-06-12 (first published: 2005-01-05)
466 reads
Distribution of Enterprise Manager registrations
This was just an answer in a forum in September, but I keep getting requests for the script. So I am sharing it here for anyone that could be interested: Problem: large amount of registered servers, multiple DBA's needing updated registration info, DBA workstations added or rebuilt, many servers added at once. In cases like […]
2007-06-05 (first published: 2005-01-26)
902 reads
Script to perform http(s) post
Post data as coming from an HTML FORM with METHOD=POST to an URL and retrieve the result. The script uses the WinHttp.WinHttpRequest.5.1 object.Call like :exec dbo.usp_httppost 'http://www.sqlservercentral.com/search/turbo.asp','searchstring=ftp&btnG= Go &cArticles=on&cForums=on&cScripts=on&sitesearch=http://www.sqlservercentral.com'
2007-05-30 (first published: 2005-01-19)
1,795 reads
This SQL statement will provide script for backup
Desc : This SQL statement will provide script for backup all your jobs.-- Remark : Grow-up "maximum characters per column" (for 8192) and disable "print column headers" in 'tools' / 'options'
2007-05-29 (first published: 2005-01-12)
386 reads
how to start a program like Notepad.exe in a job
sometime I need to kill an program which does not continue to process data, and i sheduled a job to do that. After lots of times' try, I made it at last.This script add a shedule to the sheduled task list, one minutes later then the current system time. You can change it by edit […]
2007-02-28 (first published: 2004-09-19)
270 reads
Last day of the month
Get the last date of the month for the given date. Algorithm is:1. Transform given date in “first day of the month” 2. Add a month to result 3. Subtract a day from second result
2007-02-27 (first published: 2004-09-30)
219 reads
Checking SQLAgent service and starting it if not.
Because many programs I wrote depends on the SQL Agent Service and to really make sure that no one has configured this service to run manually (you see many things in life) I rely on this litle piece of code
2006-12-27 (first published: 2004-09-16)
189 reads
Blogs
In Memory of Andrew Clarke, AKA Phil Factor
By Steve Jones
One of the parts of getting older that really sucks is I seem to...
Leading Through the Noise: Harnessing Data in the Age of Digital Overload
By Chris Yates
The New Leadership Frontier In today’s digital landscape, leaders are no longer just visionaries....
A New Word: Anderance
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
Forums
taking the rcsi dive
Hi, we put together an extract that runs every 15 minutes against what i...
Parameter Sensitive Plan Optimization in SQL Server 2022
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization in...
Minimum Change Tracking Retention
Comments posted to this topic are about the item Minimum Change Tracking Retention
Question of the Day
Minimum Change Tracking Retention
If I am running this code:
ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON (CHANGE_RETENTION=xxx);What is the minimum amount of time I can set? See possible answers