Skip to main content

Home/ SQL Server/ Group items tagged sql

Rss Feed Group items tagged

Denis Gobo

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

  •  
    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
Denis Gobo

Dynamic Search Conditions in T-SQL - 0 views

  •  
    search
mesbah095

Guest Post Online - 0 views

  •  
    Article Writing & Guestpost You Can Join this Site for Your Article & guest post, Just Easy way to join this site & total free Article site. This site article post to totally free Way. Guest Post & Article Post live to Life time only for Current & this time new User. http://guestpostonline.com
Hostforlife Hosting

How to Find Corrupt Records of The Pages - 1 views

  •  
    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.
Phil Streiff

Disk Partition Alignment Best Practices for SQL Server - 1 views

  • 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 - 40 of 41 Next ›
Showing 20 items per page