MSDN's Estimating The Size Of A Table

Jul 20, 2005

I was hoping I can get some help regarding subject mater located at
http://msdn.microsoft.com/library/d...des_02_92k3.asp

MyTable has 23 fields with 100,000 records.
Field1 nvarchar 90
Field2 char 6
Field3 varchar 8000
Field4 nvarchar 200
Field5 nvarchar 200
Field6 nvarchar 200
Field7 nvarchar 200
Field8 nvarchar 200
Field9 char 30
Field10 char 30
Field11 nvarchar 200
Field12 nvarchar 200
Field13 float 8
Field14 datetime 8
Field15 datetime 8
Field16 datetime 8
Field17 nvarchar 200
Field18 nvarchar 200
Field19 varchar 8000
Field20 nvarchar 200
Field21 nvarchar 200
Field22 nvarchar 200
Field23 varchar 8000

Data Types:
nvarchar = Variable-length, Storage is 2 times the # of characters entered
char = Fixed-length. Storage is n bytes
varchar = Variable-length, Storage is actual length in bytes of data entered
float = Is float Fixed-length?, my precisions are 15 digits so 8 bytes.
datetime = Is datetime Fixed-length?, Storage is 8 bytes


I need the following blanks filled in for me, please :-)

Num_Rows 100,000
Num_Cols 23
Fixed_Data_Size
Num_Variable_Cols 16
Max_Var_Size
Null_Bitmap Int(2 + ((23 + 7) / 8)) = 5?
Variable_Data_Size
Row_Size
Rows_Per_Page
Free_Rows_Per_Page 100 (no clustered index created)
Num_Pages
Table Size

View 2 Replies


ADVERTISEMENT

Estimating The Size Of A Database

Jan 29, 2008

I would like to know how to estimate the size of a database before filling it with records. I need a sample calculation. I am new to this concept.
Pls help.

View 2 Replies View Related

Estimating Database Size

Apr 22, 2008

I have created a table called EMP with three columns such as Empname varchar(50), Salary int, maritalstatus bit, bloodgroup char(10). Initially the table does not contain any rows. But i have been told that the table will contain 1 lac rows. So i have been asked to estimate the database size. I don't know how to estimate the database size without inserting the records. Pls help me how to do it?
Thanx

View 5 Replies View Related

Formula For Estimating Object Size

Apr 30, 1999

Hello , I am using SQL 7.0 , My Question is, Before creating any Tables or Index, can We use any formula to calculate or EStimate the size of the Database for the planning purpose ?

In order word

Do yo know any formula to Estimate the size of the database ?

View 1 Replies View Related

Estimating The Size Of A DB From A Physical Design

Jan 5, 1999

Can someone recommend an application that produces an estimate of the size of a database from column definitions and
estimated number of rows in each table? -- Thanks

View 1 Replies View Related

Estimating Needed Size When Replicating

Dec 10, 2004

Hi,

Can somebody tell how to make an estimation of the size needed when creating a 'consult' DB with snapshot replication ?

Thanks !

View 6 Replies View Related

Estimating Size Of Datable / Database

Aug 6, 2006

are there any rules of thumb for estimating database size / datatable size. I don't seem to find any specifically for SQL2005

View 4 Replies View Related

Estimating Memory Size/Config Requirements

Jun 4, 1999

Is there a way to see how much memory your current SQL Server install is using? I recently had to do some reconfiguring, and although it went fine, I'd like to build a spreadsheet model so I could see what different parameter values do to memory usage. I'm kinda surprised there isn't one already.

And yes, I realize that 99% of the configuration options go away in 7.0. We're going to have 6.5 here for a while yet.

View 1 Replies View Related

SQL Server Admin 2014 :: Possible To Find Table Size And In That Table Each Row Size

Jun 10, 2014

It is possible to find table size and in that table each row size.

View 4 Replies View Related

Estimating Execution Time Of A Query

Jun 8, 2000

Hi All

Is there anyway you can estimate the execution time/cost of a query prior to actually executing it?

Steve
EDF Man International
sfarmer@edfman.com

View 1 Replies View Related

Estimating Hardware And Resources For SQL Development

Jun 9, 2000

Are there any packages or routines that can assist in estimating the resources needed for an
SQL based system?

The system will be developed using Visual Basic. We have the number of records that will be
converted and the volume information for daily activity.

I am looking to find a tool that will help me size the equipment and resources needed.

Thanks

View 1 Replies View Related

Table Size And Database Size

Mar 2, 2008

Hi,
i use this script that show me the size of each table and do the sum of all the table size.

SELECT
X.[name],
REPLACE(CONVERT(varchar, CONVERT(money, X.[rows]), 1), '.00', '') AS [rows],
REPLACE(CONVERT(varchar, CONVERT(money, X.[reserved]), 1), '.00', '') AS [reserved],
REPLACE(CONVERT(varchar, CONVERT(money, X.[data]), 1), '.00', '') AS [data],
REPLACE(CONVERT(varchar, CONVERT(money, X.[index_size]), 1), '.00', '') AS [index_size],
REPLACE(CONVERT(varchar, CONVERT(money, X.[unused]), 1), '.00', '') AS [unused]
FROM
(SELECT
CAST(object_name(id) AS varchar(50)) AS [name],
SUM(CASE WHEN indid < 2 THEN CONVERT(bigint, [rows]) END) AS [rows],
SUM(CONVERT(bigint, reserved)) * 8 AS reserved,
SUM(CONVERT(bigint, dpages)) * 8 AS data,
SUM(CONVERT(bigint, used) - CONVERT(bigint, dpages)) * 8 AS index_size,
SUM(CONVERT(bigint, reserved) - CONVERT(bigint, used)) * 8 AS unused
FROM sysindexes WITH (NOLOCK)
WHERE sysindexes.indid IN (0, 1, 255)
AND sysindexes.id > 100
AND object_name(sysindexes.id) <> 'dtproperties'
GROUP BY sysindexes.id WITH ROLLUP) AS X
ORDER BY X.[name]

the problem is that the sum of all tables is not the same size when i make a full database backup.
example of this is when i run this query against my database i see a sum of 111,899 KB that they are 111MB,but when
i do full backup to that database the size of this full backup is 1.5GB,why is that and where this size come from?

THX

View 5 Replies View Related

Estimating Hardware Requirements For A SQL Server 2005 Installation

Jun 21, 2007

Is there any good online documentation describing rules of thumb for estimating and planning a SQL Server 2005 deployment in support of a Windows rich client/WCF services architecture?

TIA,

Ian

View 3 Replies View Related

SQL 2005 Resize Initial Log Size: MODIFY FILE Failed. Specified Size Is Less Than Current Size.

Sep 4, 2007


I am trying to resize a database initial log file from 500M to 2M. I€™m using€?

ALTER DATABASE <DBNAME> MODIFY FILE ( NAME = <DBLOGFILENAME, SIZE = 2 ) "



And I'm getting "MODIFY FILE failed. Specified size is less than current size." I tried going into the database properties and setting the log file to 2M, but it doesn€™t keep the changes.



Any help with this process?

View 1 Replies View Related

Something Not Right With This Query From Msdn

Sep 20, 2006

I have been trying to straighten out the select statement(underlined) in the procedure below but no luck. It is at the link below:(User-Specific Paging from ASP.NET)http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnpag/html/scalenethowto05.aspI think the "author" messed up during the copy and paste. Someone please help out. I really need its correct version. Thanks.blumonde // The BindData method constructs a SQL query that uses nested SELECT TOP // statements (as described earlier) to retrieve a specified page of data.//public void BindData(){  SqlConnection myConnection = new SqlConnection(_connStr);  String strCmd = "";  StringBuilder sb = new StringBuilder();  sb.Append("select top {0} CustomerID,CompanyName,ContactName,ContactTitle from (select top {1} CustomerID,CompanyName,ContactName,ContactTitle from Customers ");  sb.Append("as t1 order by contactname desc) ");  sb.Append("as t2 order by contactname asc");  strCmd = sb.ToString();   sb = null;  // Set pseudoparameters: TableName, KeyField and RowIndex   strCmd = String.Format(strCmd, _pageSize, _currentPageNumber * _pageSize);  // Prepare the command  SqlCommand myCommand = new SqlCommand(strCmd,myConnection);  SqlDataAdapter sa = new SqlDataAdapter(myCommand);  DataSet searchData = new DataSet("SearchData");  try  {    myConnection.Open();    sa.Fill(searchData);    MyDataGrid.DataSource = searchData;    MyDataGrid.DataBind();   }  finally  {    myConnection.Close();  }  CurrentPage.Text = _currentPageNumber.ToString();  if ( !Page.IsPostBack )  {    using (SqlConnection conn = new SqlConnection(_connStr))    {      SqlCommand cmd = conn.CreateCommand();      cmd.CommandText = "SELECT Count(*) FROM Customers";      conn.Open();      _totalRecords = (int)cmd.ExecuteScalar();      _totalPages = _totalRecords / MyDataGrid.PageSize;      TotalPages.Text = _totalPages.ToString();    }  }  else  {    _totalPages = int.Parse ( TotalPages.Text );   }  if (_currentPageNumber == 1)  {    PreviousPage.Enabled = false;    if (_totalPages > 1)      NextPage.Enabled = true;    else    NextPage.Enabled = false;  }  else  {    PreviousPage.Enabled = true;    if (_currentPageNumber == _totalPages)      NextPage.Enabled = false;    else      NextPage.Enabled = true;  }}

View 32 Replies View Related

SQL 7 (MSDN Version) And DTS

Mar 22, 1999

Hi

I have installed the MSDN SQL 7.0 final release on 2 Win NT (1 server and 1 Wkst)

When I launch DTS, I CAN export/import ACCESS <--> SQL and vice versa

I CANNOT export/import SQL7 <--> SQL7

I have this error messsage :
"The licence for installation of Microsoft SQL Server
on your source and destination connections does not permit the use
of DTS to transform data. refer to your licence agreement for more
information"

any ideas why ? Is there any limitation with MSDN CD ?

View 1 Replies View Related

MSDN On Vista???

Aug 31, 2007

Hello,

I recently got me a new laptop with Vista preinstalled. All good and well, but when I try to install a program vital for my profession, I get an error (OS not supported for this program). In the install I can configure what components to install, one of them is MSDN 2000. My question is, will SQL Server Express take over what MSDN can't on Vista (and thus running the program needing the MSDN 2000), or will windows XP be the new OS on my brand new laptop in the future. Love Vista, hate the compatibility.

View 1 Replies View Related

Msdn Forum

Mar 14, 2008



Where is the list for forums,
When i started to write for Sqlserver, i never searched or looked for forum. Same did when i was working with the c#.
Now I have to find the correct forum. So where is the list of those forums, thanks.

View 3 Replies View Related

Why 2 RS Forums On MSDN?

Jun 6, 2007

Why are there 2 RS forums on MSDN
This is the other one
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs

This one has a worse UI

View 2 Replies View Related

Problem Running SQL CLR MSDN Example

Oct 16, 2006

Hello,

Using VS 2005 SP1 beta and SQL Server 2005.

I am trying to learn how SQL CLR works by using this example:

http://msdn2.microsoft.com/en-us/library/5czye81z.aspx

When I press F5, I get this error:

A .NET Framework error occurred during execution of user defined routine or aggregate 'InsertCurrency':

System.Data.SqlClient.SqlException: Must declare the scalar variable "@CurrencyCode".

Do I need to declare @CurrencyCode in the Test.sql script?

Thanks for any suggestions,

Tom

View 7 Replies View Related

Limitations To The MSDN Vs Of SQL 2000?

Feb 2, 2007

Are there any limits to the number of user that can connect or anything like that with SQL 2000 (MSDN Vs)?

Thanks!

View 1 Replies View Related

Msdn Article On Getting @Identity Question

Sep 26, 2007

the msdn article explains how to input new data to a databse and return the primary key of the inputted row. It works perfectly. However, it explains how to insert a value, but there is a problem. It seems to set the value to be submitted in the VB code, instead of having the value be the user's input in the textbox. Look for the following line in the code below: newRow("ClientFileNumber") = "ClientFileNumber" It inputs "clientfilenumber" instead of what is actually inputted in the texbox. Does anyone know how to bypass this, to not have the words "clientfilenumber" inputted?Dim sqlconn As SqlConnection = New SqlConnection("Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|Client.mdf;Integrated Security=True;User Instance=True")
 Dim catDA As SqlDataAdapter = New SqlDataAdapter("SELECT * FROM Orders", sqlconn)
 catDA.InsertCommand = New SqlCommand("JobInsert", sqlconn)
catDA.InsertCommand.CommandType = CommandType.StoredProcedure
 catDA.InsertCommand.Parameters.Add("@ClientFileNumber", SqlDbType.VarChar, 50, "ClientFileNumber")Dim NewJobNumber As SqlParameter = catDA.InsertCommand.Parameters.Add("@Identity", SqlDbType.Int, 0, "OrdersID")
NewJobNumber.Direction = ParameterDirection.Output
 
sqlconn.Open()
 Dim catDS As DataSet = New DataSetcatDA.Fill(catDS, "Orders")
 
Dim newRow As DataRow = catDS.Tables("Orders").NewRow()
newRow("ClientFileNumber") = ""catDS.Tables("Orders").Rows.Add(newRow)
 catDA.Update(catDS, "Orders")
 
sqlconn.Close()
 
Response.Redirect("control_page_copy.aspx?NewJobNumber=" + NewJobNumber.Value.ToString())

View 1 Replies View Related

MSDN Subscription SQL Server 2000

Jan 18, 2007

If we purchase a new MSDN Professional subscription, does it come with SQL Server 2000 developer license?

View 3 Replies View Related

How Can I Tell If SQL Server Was Installed Using An MSDN Copy?

May 19, 2008

Hi all,

An internal licensing review is being carried out at my site for the first time since I joined. I have been asked to confirm that development SQL Server instances have been installed from MSDN installation disks and production instances from non-MSDN disks. I understand that serverproperty('licensetype') will show me this information in SQL Server 2000, and I am (perhaps incorrectly?) assuming that a result of "DISABLED" means MSDN was used for the installation.

In SQL Server 2005, i believe the installation does not record the necessary information in the registry, meaning serverproperty('licensetype') is of no use.

Is the question i've been asked impossible to answer? Is there any way I can find out if MSDN disks (or network copies of them) were used to install a SQL Server 2005 instance?

Many thanks.
James

View 4 Replies View Related

SQL Server 2000 - MSDN - AWE Memory

Aug 16, 2007

We use MSDN SQL 2000 , the enterprise edition for our development servers,
which have always had 2GB RAM.
Now they are bringing in a Win 2003 Enterprise with > 12GB RAM .
They want SQL SERVER 2000 to use AWE memory up to 12GB . Is there any limitation
on MSDN Ent. Edition using more memory.?

View 2 Replies View Related

The December CTP From The SQL MSDN Developer Center

Dec 26, 2006

Hi

Is this an upgrade for sql server 2005 express.

If I already have Sql server 2005 express must I still download

the whole file.

Rgds

Rob

View 2 Replies View Related

Strange Thing In All Examples At MSDN

Sep 18, 2007

Hi,
I have seen many examples at MSDN library related to SQL Querries in all queries one thing is same the way they use tables in there queries. BUT wht is this really i am not getting this, can anyone tell me.. the code and the problem is as follows:


Code Snippet
FROM Purchasing.ProductVendor JOIN Purchasing.Vendor
ON (ProductVendor.VendorID = Vendor.VendorID)In the above code u see "Purchasing.ProductVendor", I want to ask that wht is this
Purchasing Stands for, If we suppose that purxchasing is the database name then also
normally we use database name as Purchasing.dbo.ProductVendor BUT I am not getting that
what is this,
Please if someone knows then explain it to me,
Thanks.

View 2 Replies View Related

SELECT Permission Denied On Object (MSDN)

Jul 10, 2004

First off - complete newbie using MSDN.

Getting the error message
System.Data.SqlClient.SqlException: SELECT permission denied on object 'mytable', database 'master', owner 'dbo'. at System.Data.SqlClient.SqlCommand.ExecuteReader...

1. After a lot of googling I've done the following:
EXEC sp_grantlogin 'MYMACHINEASPNET' to grant the ASPNET logon access to the DB

2. Changed the
HKEY_LOCAL_MACHINESOFTWAREMicrosoftMSSQLServerMSSQLServerLoginMode
to 2 to allow mixed mode.

3. using my connection string in web.config - have experimented with different strings with/without trusted_connection and the sa uname and pwd.
(Current connection string is
"server=localhost;Integrated Security=SSPI;Database=master;Data Source=MYCOMPUTERNAME;trusted_Connection=yes"

I'm NOT using SQL Server so what commands do i need to give my db/table SELECT permissions? (and who am I giving permission to - very confused)

I had no bother accessing the server and DB from a simple C# command line program.

Been pulling my hair out for many hours now... any help would be greatly appreciated!

View 1 Replies View Related

SELECT Permission Denied On Object (MSDN) (again...)

Jul 10, 2004

(Not having a great day - didn't mean to lock that last post - apologies)

First off - complete newbie using MSDN.

Getting the error message
System.Data.SqlClient.SqlException: SELECT permission denied on object 'mytable', database 'master', owner 'dbo'. at System.Data.SqlClient.SqlCommand.ExecuteReader...

1. After a lot of googling I've done the following:
EXEC sp_grantlogin 'MYMACHINEASPNET' to grant the ASPNET logon access to the DB

2. Changed the
HKEY_LOCAL_MACHINESOFTWAREMicrosoftMSSQLServerMSSQLServerLoginMode
to 2 to allow mixed mode.

3. using my connection string in web.config - have experimented with different strings with/without trusted_connection and the sa uname and pwd.
(Current connection string is
"server=localhost;Integrated Security=SSPI;Database=master;Data Source=MYCOMPUTERNAME;trusted_Connection=yes"

I'm NOT using SQL Server so what commands do i need to give my db/table SELECT permissions? (and who am I giving permission to - very confused)

I had no bother accessing the server and DB from a simple C# command line program.

Been pulling my hair out for many hours now... any help would be greatly appreciated!

View 5 Replies View Related

How Can I Tell If A Sql Server Is MSDN Or Standard Or Enterprise Version

Nov 3, 2005

Hi,How can I tell If my sql server is MSDN or Standard or Enterpriseversion.Thank youAR

View 5 Replies View Related

New Books Online Search Functionality On MSDN...

Mar 30, 2007

Check out the new Books Online search functionality online. The link below provides a scoped search of Books Online that returns a more precise and targeted result set. You can use it to search Books Online content quickly.

http://search.live.com/macros/sql_server_user_education/booksonline

Please direct your feedback to SQLServerUE@hotmail.com.

View 3 Replies View Related

Why I Can Not See Sign In Button On Msdn Forums Website

Apr 28, 2008

I don't know why I can not see 'sign in' button on msdn forums now at my company's computer. I can see that button several days ago, but now I can not see it. Why? I only can see post but can not create a new one or reply.

At home computer everything is fine.

Thanks.

View 2 Replies View Related

SSIS 2005 MSDN Tutorial - Lesson 1 - Error

Oct 27, 2006

I am new to SSIS 2005

http://msdn2.microsoft.com/en-us/library/ms167106.aspx

SSIS 2005 MSDN Tutorial - Lesson 1 - subsection namely 'Adding and Configuring the Lookup Transformations ' - in that STEP 7 not working. Not able to select the 'columns' tab.

Anybody worked-out this Lesson1 with the step provided by MSDN.

Pls help. Thanks

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved