Free SQL Server Learning - Get a six month training plan for the Accidental DBA
solving sql server problems for millions of dbas and developers since 2006



SQL Server DBA Tips SQL Server Developer Tips SQL Server Business Intelligence Tips SQL Server Career Tips SQL Server Tip Categories SQL Server Tutorials SQL Server Webcasts SQL Server Whitepapers SQL Server Tools SQL Server Questions and Answers MSSQLTips Authors About MSSQLTips SQL Server User Groups SQL Server Events I am MSSQLTips MSSQLTips Advertising Options

MSSQLTips Facebook Page MSSQLTips LinkedIn Page MSSQLTips RSS Feed MSSQLTips Pinterest Page MSSQLTips Twitter Page MSSQLTips Google+ Page






















SQL Product Highlight

Red Gate Software - SQL Server performance monitoring that makes prioritizing simple

SQL Monitor offers straightforward server monitoring through a web-based UI, to help you prioritize your workload:

  • Real-time SQL Server performance updates
  • Alerts within 15 seconds of a SQL Server problem
  • Embedded advice on how to solve performance problems
  • Web-based, so you can track server performance away from your desk
  • Quick to install
  • NEW: library of custom metric scripts written by SQL Server MVPs, for extra coverage

Start monitoring your servers today with a free trial.

Learn more!

























Functions - System Tips

All Tips
  Using SOUNDEX and DIFFERENCE to Standardize Data in SQL Server
Aggregate
  SQL Server TSQL Aggregate Functions
Concatentation
  Using SQL Server Concatenation Efficiently
Conversions
  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
  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
Find and fix SQL Server problems before they happen - SQL diagnostic manager now with predictive analysis!

Get your SQL Server database under version control now! Find out why...

What grade do you think your SQL Servers get? Find out with Edgewood's Health Check consulting services.

Solving SQL Server problems for millions of DBAs and Devs since 2006. Join now.

Optimizing SQL Server performance can be a daunting task. Or is it?

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

Edgewood Solutions LLC | MSSharePointTips.com | MSSQLTips.com