Skip to main content

Home/ SQL Server/ Group items tagged sql server

Rss Feed Group items tagged

Filter: All | Bookmarks | Topics Simple Middle
Denis Gobo

Getting The Percentage Of NULLS And Values In A SQL Server Table - 1 views

blogs.lessthandot.com/...title-1

code database programming sql sql server sqlserver

shared by Denis Gobo on 05 Aug 08 - Cached
  • Denis Gobo on 05 Aug 08
     
    Sometimes you want to know what the percentage is of null values in a table for a Column Or you might want to know what the percentage of all values in a Column is grouped by value You can get these answers by running the code below
Hostforlife Hosting

How to Find Corrupt Records of The Pages - 1 views

europeanwindowshosting.hostforlife.eu/...rupt-Records-of-The-Pages.aspx

sql server hosting tutorial

shared by Hostforlife Hosting on 10 Aug 15 - No Cached
  • Hostforlife Hosting on 10 Aug 15
     
    Say one of the pages in your table is corrupt and while repairing the corrupt pages, you may eventually end up loosing some data. You may want to find out which records are on the page.
anonymous

Disk Partition Alignment Best Practices for SQL Server - 1 views

msdn.microsoft.com/...dd758814.aspx

shared by anonymous on 17 May 10 - Cached
  • Windows Server 2008 attempts to align new partitions out-of-the-box, yet disk partition alignment remains a relevant technology for partitions created on prior versions of Windows.
  • A sector is the minimum chunk of data that can be read or written to a hard drive. Historically, sector size has been fixed at 512 bytes.
  • Newer drives may offer 1 KB, 2 KB, or 4 KB sectors.
  • ...2 more annotations...
  • Bytes Per Cluster :               65536
  • The Bytes Per Cluster value, which contains the file allocation unit size, is highlighted here
‹ Previous 21 - 29 of 29
Showing 20▼ items per page