This isn't a SQL site nor can you easily do regular expressions from SQL. That said, sometimes regular expressions are EXACTLY what you need to solve a problem. The downside? They're tricky! This is a great resource to pass on to your development team.
2004-02-26
653 reads
This is a tool to generate C# code based on a sql script. Source code is also available for download. It's free! One caveat is that the site is in Italian.
2004-02-26
597 reads
IP addresses are represented as xxx.xxx.xxx.xxx, where xxx is an integer between 0 and 255. Each three-digit integer is called an octet, and all IP addresses comprise four octets.Help-desk applications and administrative tools often store the IP addresses for a company's PCs in a database. An IP address can be represented either as a single […]
2004-02-25
2,367 reads
This sp will return the dependency details of the select table or all tables as a resultset. This resultset will display the dependency details if it is used in 1. select * from table or2. insert/delete/update dml statement or 3. select col1, col2 from table.
2004-02-25
232 reads
This article is for developers (and is in C#), looks at how you can avoid requerying by storing data in a hashtable. Mainly code, but you may get a good idea or two from it.
2004-02-25
6,972 reads
I have been tasked with a daunting job of scripting I/U/D triggers for our new database. The job of the triggers is to Audit the activity on the tables. What column was changed to what value on what table and by whom. With over 60 tables, this is a daunting task. So off I went […]
2004-02-24
1,049 reads
I want to thank James Travis for his original and excellent work and to Razvan Socol for alerting about a similar problem that led me to improve James' code. The problem is that when searching for a word that is split between two 8kb blocks, James' code would ignore it. The solution is to look […]
2004-02-21
171 reads
The purpose of this SP is to provide a method in T-SQL to launch another T-SQL thread without havingto wait for its completion. Uses fairly basic calls to create and execute SQL Jobs. Contains helpfull notes and documentation.
2004-08-10 (first published: 2004-02-17)
2,236 reads
Looking for a good (or another) TSQL reference? This might be the one. Bruce took a good look at it and points out both the good and the bad.
2004-02-17
5,452 reads
Quest Software has recently released TOAD for SQL Server, a freeware version of its highly popular Oracle tool - TOAD
2004-02-17
837 reads
By SQLPals
SQL Server instance metadata inventory with PowerShell and SMO The purpose...
Disclosure: this post may contain links to books as an affiliate link. If you...
By Arun Sirpal
Every Claude conversation has a context window. It is the total amount of text...
Comments posted to this topic are about the item Celebrating 30 years of PostgreSQL,...
Hello, has anyone here ever provisioned and actually used an MS SQL Server with...
Comments posted to this topic are about the item No More Deadlocks
After detecting deadlocks in SQL Server 2025 and lowering the time threshold for detecting future issues, when does the Database Engine return to the 5s default interval?
See possible answers