This is the standard sp_helptext from SQL Server 2000 modified slightly to return the object definition as an XML document.The document is structured in the following format:I admit it was not a lot of work since I merely modified the final SELECT statement from Microsoft's own procedure, but I still find this very useful.The only […]
2003-09-26
220 reads
This a modification to the script given by Preethi.It generates prime numbers to the upper bound you specify.Modifications are using following facts from algebra:1. All prime numbers greater than 3 can be written in the form 6 * X +/- 1.2. Instead of checking the module for ALL numbers
2003-09-25
405 reads
This article by Jon Winer offers some tips to help you get the most of SQL Full Text Search.
2003-09-25
12,621 reads
@strUser_nm is the owner of the table. If the modifyname table does exist, it will alter it with the same structure as the sourcename table. If the modifyname table exists, it compares the columns and add any that are missing. The procedure passes an output parameter. This is used to know if we need to […]
2003-09-22
491 reads
This script will rename all FK constraint names in your database. It will give them a user friendly name that can be used in error messages, etc. The FK contraint names will be formatted as FK_ChildTableName_ParentTableName_soid. Note: You first need to enable 'Allow modifications to be made directly to the system catalogs'. This can be […]
2003-09-19
1,187 reads
We've had a soft launch under way for the past week, but now we'd like to sell the rest of the books stacked up at Andy's house! $15 plus shipping will get you a book that you'll be proud to put on your bookshelf. Read this to get latest pricing and answers to the most recent questions we've gotten.
2003-09-19
2,973 reads
Directly accessing system tables is discouraged - so what's the alternative? Using the Information Schema should allow you to create code that survives upgrades. Beyond that, what can you do with it? Joe has four great examples to get you started.
2003-09-18
14,700 reads
This is a comment on/modification of the Usp_FindAllDBSizes script on Sept 17th.Why use an inner loop when you can use a select stmt?
2003-09-17
113 reads
Chris discusses some issues he had trying to use SQL dates from within Java. Interesting stuff and brings up the point that if you have dates stored in local time, having users in multiple time zones can be a large headache.
2003-09-17
12,506 reads
Andy reviewed v1.51 almost two years ago, this week he looks at the latest release that includes one feature he really wanted - the ability to compare and sync text columns.
2003-09-12
8,557 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