SQLAuthority News – Best Articles on SQLAuthority.com

SQL SERVER – Cursor to Kill All Process in Database SQL SERVER – Find Stored Procedure Related to Table in Database – Search in All Stored procedure SQL SERVER – Shrinking Truncate Log File – Log Full SQL SERVER – Simple Example of Cursor SQL SERVER – UDF – Function…
Read More

SQLAuthority News – Best Downloads on SQLAuthority.com

Best Downloads on SQLAuthority.com SQL SERVER – Query Analyzer Shortcuts SQL Server Interview Questions and Answers Complete List Download SQL SERVER – Download SQL Server Management Studio Keyboard Shortcuts (SSMS Shortcuts) SQL SERVER Database Coding Standards and Guidelines Complete List Download SQL SERVER – Data Warehousing Interview Questions and Answers…
Read More

SQL SERVER – 2008 – Server Consolidation WhitePaper Download

Server Consolidation with SQL Server 2008 Writer: Martin Ellis Reviewer: Prem Mehra,Lindsey Allen, Tiffany Wissner, Sambit Samal Published: March 2009 Microsoft SQL Server 2008 supports multiple options for server consolidation, which provides organizations with the flexibility to choose the consolidation approach that best meets their requirements to centralize data services…
Read More

SQL SERVER – Deterministic Functions and Nondeterministic Functions

Deterministic functions always returns the same output result all the time it is executed for same input values. i.e. ABS, DATEDIFF, ISNULL etc. Nondeterministic functions may return different results each time they are executed. i.e. NEWID, RAND, @@CPU_BUSY etc. Functions that call extended stored procedures are nondeterministic. User-defined functions that…
Read More