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,952 reads
Generate an html-excel file with any table. Does not need Excel to generate , because does not use Excel automation
2004-02-12
440 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,213 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)
810 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,872 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,065 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
541 reads
Returns the number of records within a table without having to perform COUNT.
2004-10-04 (first published: 2004-02-03)
858 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,330 reads
By James Serra
An architecture scenario Imagine separate Sales, Finance, Shared Data, and Executive Analytics workspaces. Sales...
Security on your SQL Server is important. That doesn’t need any explaining. But where...
It’s that time of year again! EightKB is back on August 20th at 13:00...
Comments posted to this topic are about the item Backing Up a DMK
Comments posted to this topic are about the item The Quiet Part
Comments posted to this topic are about the item BIT_COUNT in SQL Server
In SQL Server 2025, I have a database with a Database Masker Key (DMK). I want to back up this key and keep a copy offline. When do I have to open this key before running the backup?
See possible answers