Free SQL Server Learning - Making the most out of SQL Server Agent
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

Idera - SQL safe backup

SQL Server backup compression with network fault tolerance and zero impact encryption

  • Fast, compressed & encrypted SQL backup and restore
  • SQL Server backup compression of 95%
  • At least 50% faster than native SQL backups

    • Learn more!











T-SQL Tips

All Tips
  Silent Truncation of SQL Server Data Inserts
Backward Compatibility
  Make your SQL Server database changes backward compatible when adding a new column
  Make your SQL Server database changes backward compatible when changing a relationship
  Make your SQL Server database changes backward compatible when dropping a column
  Make your SQL Server database changes backward compatible when renaming an entity
Calculations
  Calculating and verifying financial values in SQL Server
  Calculating Mathematical Values in SQL Server
  Getting a SQL Server RowCount Without doing a Table Scan
  Script to calculate the Median value for SQL Server data
Computed Columns
  Getting creative with Computed Columns in SQL Server
Configuration
  Determining SET Options for a Current Session in SQL Server
  Limit amount of data returned with the SQL Server TEXTSIZE command
Data Tier
  Introduction to Data Tier Applications in SQL Server 2008 R2
Data Types
  Overview of WITH RESULT SETS Feature of SQL Server 2012
  SQL Server Bitwise operators store multiple values in one column
Delete
  Deleting Data in SQL Server with TRUNCATE vs DELETE commands
Duplicate Data
  Delete duplicate rows with no primary key on a SQL Server table
Merge
  Comparing performance for the MERGE statement to SELECT, INSERT, UPDATE or DELETE
  SQL Server 2008 MERGE More than UPSERT
  Using MERGE in SQL Server to insert, update and delete at the same time
  Using the SQL Server MERGE Statement to Process Type 2 Slowly Changing Dimensions
OUTPUT
  SQL Server 2008 consume output directly from the OUTPUT command
  Using INSERT OUTPUT in a SQL Server Transaction
Pivot
  Script to create dynamic PIVOT queries in SQL Server
Plan Cache
  Keeping data available in the SQL Server data cache with PINTABLE
Random Data
  SQL Server stored procedure to generate random passwords
Result Set
  Rolling up multiple rows into a single row and column for SQL Server data
  SQL Server 2008 Group By Sets
Security
  Preventing TSQL code from running on a Production SQL Server
System
  Dropping multiple SQL Server objects with a single DROP statement
  Renaming SQL Server database objects and changing object owners
  SQL Server Four part naming
  SQL Server sp_ prefix when and when not to use it
Temp Tables
  Create SQL Server temporary tables with the correct collation
  Differences between SQL Server temporary tables and table variables
  SQL Server Temp Table vs Table Variable Performance Testing
Troubleshooting
  Problem using DISTINCT in case insensitive SQL Server databases
  SQL Server work around for Msg 2714 There is already an object named #temp in the database
Tutorials
  New SQL Server Database Development Tutorial
  SQL Server Insert Tutorial
  SQL Server SELECT Tutorial
Update
  Swap SQL Server column data due to inserting data into wrong columns
Variables
  Nullability settings with select into and variables
  SQL Server 2008 Inline variable initialization and Compound assignment
  When to use SET vs SELECT when assigning values to variables in SQL Server
Webcast
  Free Webcast - Building blocks for managing your SQL Server code

 
Sponsor Information
SQL Server having some performance issues? Idera SQL check. FREE SQL Server enhancement.

NEW! Top 5 hard-earned lessons of a DBA from Grant Fritchey & the DBA Team. Read it now

Is “blocking” a bad word at your company? Contact the Edgewood SQL Server Consultants for the resolution.

Spring Clean Your Data - Clean your global contact data with Melissa Data tools for SSIS. Download a free trial!

The SQL Server Security THREAT - It’s Closer Than You Think

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