It creates documentation for all user tables in a specific database. A server name/ database name was added on the top of the HTML file also a column datatype field was added to the HTML file. Now the @strHTML can have 8000 chars, before only 4000 - still for tables with a lot of columns […]
2003-10-27
694 reads
Sound like old hat ... but this procedure accepts the two database names as input parameters; therefore, it must dynamically generate the SQL and use Exec(@command) to execute it. It also reports on tables that exist in one database but not the other ... Finally, it uses count(*) to provide more accuracy than using sysindex […]
2003-10-24
339 reads
This function lists the column name and column id for primary key columns for a given table.
2003-10-24
1,593 reads
This script converts string-based IP addresses to their numeric equivalents so that it is easy to do arithmatic on them such as find an IP address that is within a range.NOTE: This function calls the split function which is included in the post.
2003-10-20
1,602 reads
Are you managing big databases with a lot of tables like SAP as I'm?Do you use sp_spaceused, as I'm?Do you want to know your n biggest tables as I'm?Then don't search any longer.I'm using this script every day for may maintenance jobs.I generates, like sp_spaceused, out of sysindexes the n biggest tables without any cursor, […]
2003-10-20
323 reads
I routinely need to retrieve and package query result sets in an XML package. The built in functions supported by SQL Server 2000 are effective, but are often more of a pain than a help. This routine can be used in a simple select statement to XML encode the contents of a column during the […]
2003-10-14
271 reads
2003-10-10
99 reads
Calculates the factorials of numbers between 1 - 31.High level is 31 because maximum stored procedure, function, trigger, or view nesting level is limited to 32.
2003-10-08
683 reads
This script will generate a set of DBCC DBREINDEX commandsthat can be executed to rebuild the indexes. Additional information is provided to assist with sizing of the fillfactors.
2003-10-03
648 reads
Here is a revised version of the crosstab query I submitted last week. This new version avoids the WHILE loop (which was used in my pervious version) and is thus COMPLETELY SET-ORIENTED for better performance.
2003-10-03
827 reads
By Brian Kelley
Here is another short video (~ 15 minutes). This is by the author of...
By Steve Jones
I had a briefing for the 2026 PASS Data Community Summit, which is just...
Your AI is busy. But do you know what it's worth? Most companies can...
Jl. Kemanggisan Utama Raya No.37, RT.7/RW.8, Kemanggisan, Kec. Palmerah, Kota Jakarta Barat, Daerah Khusus...
Hello, We maintain an inventory table that captures monthly snapshots of item inventory levels....
Comments posted to this topic are about the item Azure SQL Hyperscale Unveiled
What are vectors in SQL Server 2025, as related to the new AI features?
See possible answers