The code in this procedure takes standard formula’s given by Microsoft and calculates approximate size of a table as per the fields & indexs on that table. The procdure can be quickly be used in a loop to work for entire database. Refer to article http://msdn.microsoft.com/library/default.asp?url=/library/en-us/createdb/cm_8_des_02_92k3.asp for the actual document containing the formula’s used.There are […]
2004-08-11 (first published: 2004-02-16)
2,931 reads
Generate an html-excel file with any table. Does not need Excel to generate , because does not use Excel automation
2004-02-12
431 reads
Frank returns this week with a good non academic overview of the different types of database models and some of the features/problems that are native to each.
2004-02-12
11,180 reads
Generate an html-excel file with any table. Does not need Excel to generate , because does not use Excel automation
2004-08-12 (first published: 2004-02-10)
793 reads
This article demonstrates that one way to optimize the data access portion of your app is to do the query once and cache the results. This is not advanced caching just something to get you started thinking about the possibilities.
2004-02-10
7,865 reads
In this short article that follows up on an earlier one that discussed dependency issues we have some code that will generate simple treeview type view of the relationships between procs. Mostly code, more so than usual, but we thought you might find the idea useful!
2004-02-09
7,038 reads
You point this application at a database and it generates a code unti that allows you to easily execute stored procedures and functions from Delphi. (Not Reviewed)
2004-02-09
1,528 reads
Generate an html-excel file with any table. Does not need Excel to generate , because does not use Excel automation.
2004-02-08
524 reads
Returns the number of records within a table without having to perform COUNT.
2004-10-04 (first published: 2004-02-03)
844 reads
Function to allow for checking if an IP address is a private IP address. Will convert the IP to a bigint equivalent if within the private range, otherwise it will return null if IP is a public address.Requires function IPStringToNumber which is included in the post
2004-01-23
1,292 reads
By Chris Yates
When Microsoft announced SQL Server 2025, I was curious about what would truly change...
By Steve Jones
Redgate has a research arm, called the Foundry, that has been experimenting with AIs...
By Steve Jones
Today I’m in San Francisco at Small Data SF 2025. I went to the...
Not sure if this is a tech mistake I've made or a lack of...
Several times now, I've seen a post asking for a solution. I've replied, and...
Comments posted to this topic are about the item Data > Hype
What parameters are needed to enable a slipstream installation for setup.exe (SQL Server setup)?
See possible answers