Specifically, I needed to parse a zip code (5-digit) from a client comments fields where the number was in different positions such as "Customer 999999999 should be at zip code 99999" and "99999 zipcode" and "should be zip code 99999 phone 9999999999". My stored procedure first filters on a [Comments] field string that contains variations […]
2006-11-08 (first published: 2006-06-13)
508 reads
Commenting seems to be the bane of every programmer, database or otherwise. Sachin Dedhiya brings us a look at brings some standards to how you should comment your code in a SQL Server database.
2006-06-13
7,111 reads
For several times i had faced a problem of having “special” users, that need to create and run their own DTSs. I produced this script after implementing all the steps needed to allow normal users to do and run their DTSs.I hope it will be helpful at least for some of you.
2006-06-23 (first published: 2006-06-12)
287 reads
Backs up the SQL Server EM registration from the registry. Assumes that EM is configured to save common, not by user/independently. I recommend changing EM to Store locally for all users, (not independently) and create a weekly scheduled job to backup the HKLM..\..\Registered Servers X branch.Configure EM to store settings for the local machine, all […]
2006-06-26 (first published: 2006-06-12)
321 reads
SQLServerCentral.com is offering Integration Services training at our new training center. Sign up today and learn from Brian Knight, MVP and SSIS Guru.
2006-06-12
8,548 reads
Use this Perl script to produce an audit report of both share permissions and NTFS permissions of the shared folders. To report share permissions:Use shareperms.pl -p -SMyServer1 to report on a single server.Or use shareperms.pl -p -SMyServer1,MyServer2 for multiple servers.You can also use a text file as input: shareperms.pl -p -CServers.txtTo report NTFS permissions use […]
2006-06-27 (first published: 2006-06-11)
330 reads
Lightweight and adaptable, but with proper emphasis on the design phase, the ICONIX methodology can help you avoid Constant Refactoring After Programming...
2006-06-09
1,977 reads
The following T-SQL query batch will show you which tables was changed since last execute. Tracking information: (1) changes row count /insert,update,delete/; (2) changes IDENTITY value; (3) changes physical allocations /used pages/; (4) added new tables; (5) dropped tables. The batch must be initialized before using (at least once executed). I use this batch to […]
2006-06-12 (first published: 2006-06-08)
744 reads
Training is an important part of anyone's life in technology, especially if you are a SQL Server DBA or developer. With the release of 2005, the entire paradigm of working with SQL Server has changed and you need to be working on your own personal knowledge base. Steve Jones takes a look at how you can get training and shake the funding loose as well.
2006-06-08
7,018 reads
XML is becoming more and more the mainstream for data transfers between systems. Web services and SOAP communications are built into SQL Server 2005, requiring the more and more DBAs understand how to work with XML. Raj Vasant has written a number of articles on XML and brings us a look at how XML should and should not be used.
2006-06-05
9,792 reads
By Steve Jones
Recently I was working in VS Code and I saw a walkthrough for the...
By alevyinroc
In the blink of an eye, summer has passed. I don’t know about you,...
By Chris Yates
In today’s digital landscape, data is both a strategic asset and a potential liability....
Comments posted to this topic are about the item Change Tracking Data Retention Options
Comments posted to this topic are about the item Requiring Technical Debt Payments
Comments posted to this topic are about the item Using the FP-Growth Algorithm to...
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