Table space used in sql server

CREATE TABLE dbo.Geo
(
    geo geography

)

GO

CREATE TABLE dbo.LatLon
(
    lat decimal(9, 6)
,   lon decimal(9, 6)

)

GO

INSERT dbo.Geo
SELECT geography::Point(36.204824, 138.252924, 4326) UNION ALL
SELECT geography::Point(51.5220066, -0.0717512, 4326) 

GO 10000

INSERT dbo.LatLon
SELECT  36.204824, 138.252924 UNION
SELECT 51.5220066, -0.0717512

GO 10000

EXEC sp_spaceused 'dbo.Geo'
EXEC sp_spaceused 'dbo.LatLon'

Comments

Post a Comment

Popular posts from this blog

C# code to Check IE Proxy Settings

private static void CheckIEProxySettings() {     string strFileURL = " http://programmersvision.blogspot.in ";     HttpWebRequest WebReqt = (HttpWebRequest)HttpWebRequest.Create(strFileURL);     WebProxy WP = new WebProxy(WebReqt.Proxy.GetProxy(new Uri(strFileURL)));     WP.Credentials = CredentialCache.DefaultCredentials;     Console.WriteLine(WP.Address);     // or use this method     //CheckForProxy(new Uri(" http://http://programmersvision.blogspot.in ")); } private static void CheckForProxy(Uri resource) {     WebProxy proxy = (WebProxy)WebProxy.GetDefaultProxy();     Uri proxyUri = proxy.GetProxy(resource);     if (proxyUri == resource)     {         Console.WriteLine("There is no proxy for {0}", resource);     }     else     { ...
Read more

Convert XElement to DataTable

public DataTable XElementToDataTable(XElement x)  {    DataTable dt = new DataTable();   XElement setup = (from p in x.Descendants() select p).First();    foreach (XElement xe in setup.Descendants()) // build your DataTable      dt.Columns.Add(new DataColumn(xe.Name.ToString(),typeof(string))); // add columns to your dt   var all = from p in x.Descendants(setup.Name.ToString()) select p;    foreach (XElement xe in all)    {      DataRow dr = dt.NewRow();      foreach (XElement xe2 in xe.Descendants())        dr[xe2.Name.ToString()] = xe2.Value; //add in the values      dt.Rows.Add(dr);    }    return dt;  }
Read more