2010-04-01 (first published: 2010-03-31)
4,374 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,915 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,833 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)
464 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)
899 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,791 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)
384 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)
260 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)
216 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)
187 reads
Blogs
A DevOps Workshop Tomorrow in Atlanta
By Steve Jones
Tomorrow is the Redgate DevOps Day in Atlanta. You can still sign up, so...
Stop Wasting Time Rebuilding Indexes Every Night
By Kevin3NF
Too many IT teams run index rebuild jobs on autopilot. Every night. Every index....
SQL Data Type Conversions: Your Key to Clean Data & Sharp Queries
If you're a data analyst juggling varied datasets, mastering SQL data type conversions isn't...
Forums
Execution Plan Operators
Comments posted to this topic are about the item Execution Plan Operators
Merge spans with Dates Logic
--for a given member if the startdate and endate is continous we need to...
Merge data from two different source until the data is available from both sourc
I have two sources , one coming from datalake and another is file. we...
Question of the Day
Execution Plan Operators
When looking at an execution plan in SSMS, what types of operators are shown?
See possible answers