Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: jieyin
  • Content: Threads
  • Order by date
  1. jieyin

    Estimate physical space for SQL Server database

    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
  2. jieyin

    How to trim .bak file

    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
  3. jieyin

    How to trim .bak file

    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
  4. jieyin

    Is there a way to control MsgBox font?

    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?
  5. jieyin

    how come ADODB recordset always return NOTHING

    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...

Part and Inventory Search

Back
Top