Skip to main content

Home/ SQL Server/ Group items tagged server

Rss Feed Group items tagged

Filter: All | Bookmarks | Topics Simple Middle
Phil Streiff

Disk Partition Alignment Best Practices for SQL Server - 1 views

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

shared by Phil Streiff 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
eralper

SQL Waitfor Delay and SQL Waitfor Time in SQL Server - 0 views

www.kodyaz.com/...aitfor-time-in-sql-server.aspx

sql waitfor t-sql sqlserver

shared by eralper on 16 Mar 11 - No Cached
  • eralper on 16 Mar 11
     
    T-SQL developers use SQL Waitfor statement to postpone or delay the execution of a t-sql script block or to set the execution time of the sql code block.
Denis Gobo

SQL Server Programming Hacks - 0 views

forum.lessthandot.com/viewtopic.php

database hacks lessthandot microsoft programming sql sqlserver wiki

shared by Denis Gobo on 01 Jun 08 - Cached
  • Denis Gobo on 01 Jun 08
     
    This is a collection of SQL hacks, right now we there are 8 sections and between 70 and 80 hacks.
‹ Previous 21 - 29 of 29
Showing 20▼ items per page