solving sql server problems for millions of dbas and developers since 2006




Learn more about SQL Server tools


































Functions - System Tips

All Tips
  Different ways to get random data for SQL Server data sampling
  Using SOUNDEX and DIFFERENCE to Standardize Data in SQL Server
Aggregate
  SQL Server TSQL Aggregate Functions
Concatentation
  Concatenate SQL Server Columns into a String with CONCAT()
  Using SQL Server Concatenation Efficiently
Conversions
  Concatenation of Different SQL Server Data Types
  New Data Type Conversion Functions in SQL Server 2012
Logical
  New Logical Functions in SQL Server 2012 (IIF and CHOOSE)
Monitoring
  SQL Server 2008 System Functions to Monitor the Instance, Database, Files, etc.
Numbers
  SQL Server Rounding Functions - Round, Ceiling and Floor
Random Data
  Randomly Retrieve SQL Server Records
  Retrieving random data from SQL Server with TABLESAMPLE
Ranking
  Forgotten SQL Server Functions - VARP, SOUNDEX and NTILE
  Percent_Rank and Cume_Dist functions in SQL Server 2012
  SQL Server 2005 and 2008 Ranking Functions DENSE_RANK and NTILE
  SQL Server 2005 and 2008 Ranking Functions Row_Number and Rank
  SQL Server 2012 Analytical Functions - Percentile_Cont and Percentile_Disc
  SQL Server 2012 Functions - First_Value and Last_Value
  SQL Server 2012 Functions - Lead and Lag
Result Set
  Dynamically controlling the number of rows affected by a SQL Server query
Strings
  Deciding between COALESCE and ISNULL in SQL Server
  New FORMAT and CONCAT Functions in SQL Server 2012
  Performance Comparison of the SQL Server PARSE, CAST, CONVERT and TRY_PARSE, TRY_CAST, TRY_CONVERT Functions
  SQL Server Text Data Manipulation
  The Many Uses of Coalesce in SQL Server
System
  CHECKSUM Functions in SQL Server 2005
  SQL Server 2008 Functions for Tables, Views, Indexes, Columns, Stored Procedures
  Using the OBJECT_SCHEMA_NAME function to return the SQL Server schema name
  Using the SQL Server APP_NAME function to control stored procedure execution

 
Sponsor Information







Copyright (c) 2006-2014 Edgewood Solutions, LLC All rights reserved
privacy | disclaimer | copyright | advertise | about
authors | contribute | feedback | giveaways | user groups | community | events | first timer?
Some names and products listed are the registered trademarks of their respective owners.