Search results for query: *

Hi, do you have tips on allocating space in SQL Server for a database to accommodate about 9,000,000 records and 3,000 fields (divided in multiple tables of course)? How much space do you recommend? Is there a formula to calculate physical space for any given table size (say 1,200,000 x 50)? Thanks

Thanks, SonOfEmidec1100. I think your solution works fine for me.

Thanks, SQLBill. You got my point and I think your solution works fine for me. I will just periodically do this chore.

Thanks. But this doesn't solve my problem. My problem is not to retore database from any given backup. What I wanted is to trim the .bak file itself. For example, the .bak file now contains 26 versions of my backups dated from 7/1/2003 to 7/26/2003. I want to get rid of all backups before...

I have a database regularly backed up in a .bak file. Over time this file grows larger and larger taking up a lot spaces. I want to trim it down a little bit by getting rid of some earlier versions of backup within the .bak file. Can I do that and how? Thanks

I have a database regularly backed up in a .bak file. Over time this file grows larger and larger taking up a lot spaces. I want to trim it down a little bit by getting rid of some earlier versions of backup. Can I do that and how? Thanks

I have great difficulty to align text in Access2000's msgbox so I wonder if there is a way to set the font displayed in the msgbox to be some kind of evenly-spaced font. Any ideas?

Thanks, it works! I also found another way to do it: reference to DAO and use currentDB.openReordSet, looks like this way the adOpenStatic is default.

Hi, I have a function associated with a form button (Access2000), part of it (see blow) is to find record count in a select query: Private Sub Register_Click() .... Dim rs As ADODB.Recordset Set rs = New ADODB.Recordset rs.Open "select branch_id from branches&quot...