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,938 reads
Generate an html-excel file with any table. Does not need Excel to generate , because does not use Excel automation
2004-02-12
436 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,185 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)
798 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,866 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,043 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
530 reads
Returns the number of records within a table without having to perform COUNT.
2004-10-04 (first published: 2004-02-03)
850 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,303 reads
By Brian Kelley
There's a great article from MIT Technology Review about resetting on the hype of...
By Steve Jones
etherness – n. the wistful feeling of looking around a gathering of loved ones,...
By Steve Jones
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...
Comments posted to this topic are about the item The Max PK Length
Comments posted to this topic are about the item My experience using the GitHub...
Comments posted to this topic are about the item The Microsoft SQL Year in...
If I create a multiple column Primary Key constraint, what is the most number of bytes I can include in the constraint?
See possible answers