Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Welcome to

A Microsoft SQL Server community of 1,805,297 DBAs, developers and SQL Server users

Headlines today   May 28, 2015

Retrieving a Binary File from Your Database

In this second article I provide the means to restore a binary file to its original state.   Read more...
By Eric Notheisen 2015/05/28 | Source: | Category: clr
Rating: |  Discuss |   Briefcase | 2,712 reads

Take our SQLServerCentral Users Survey

Each year SQLServerCentral runs a survey to get some insight into what who our readers are, what they like about the site, and what can be improved. Please take a few minutes to complete this survey by June 12 and get the opportunity to win one of three $50 Amazon vouchers.  Read more...
By Press Release 2015/05/28 (first published: 2015/05/26) | Source: | Category: survey
Rating: (not yet rated)  Rate this |   Briefcase | 4,854 reads

Converting and Using Text Dates as SQL Server Dates

This tip describes some T-SQL techniques for converting a mmddyyyy string to a SQL Server date, handling rows with missing date strings, and comparing converted date strings.  Read more...
By Additional Articles 2015/05/28 | Source: | Category: dates and conversion
Rating: (not yet rated)  Rate this |   Briefcase | 2,738 reads
Previous headlines

Stairway to Advanced T-SQL Level 5: Turning Data On Its Side Using PIVOT Operator

The PIVOT operator was added to the Transact-SQL language in SQL Server 2005. It allows you to turn your row data on its side, so it can be presented as column data. This is useful when you want take unique column values and have them displayed as column headings, where the column headings are associated with summarized values displayed below each column heading. In this article I will be exploring how to use the PIVOT operator.   Read more...
By Gregory Larsen 2015/05/27 | Source: | Category: stairway series
Rating: |  Discuss |   Briefcase | 4,814 reads

Free eBook: Troubleshooting SQL Server: A Guide for the Accidental DBA

Three SQL Server MVPs (Jonathan Kehayias, Ted Krueger and Gail Shaw) provide fascinating insight into the most common SQL Server problems, why they occur, and how they can be diagnosed using tools such as Performance Monitor, Dynamic Management Views and server-side tracing. The focus is on practical solutions for removing root causes of these problems, rather than "papering over the cracks".  Read more...
By Press Release 2015/05/27 (first published: 2013/08/07) | Source: Redgate | Category: troubleshooting
Rating:  Rate this |   Briefcase | 56,248 reads

Using the T-SQL PERCENTILE Analytic Functions in SQL Server 2000, 2005 and 2008

Percentiles give meaning to measurements by telling you the percentage of the population being measured who get higher or lower values. They are now easier to calculate in SQL, and are useful for reporting; but are the new analytic functions faster and more efficient than the older methods? Dwain Camps demonstrates, and investigates their relative performance.   Read more...
By Additional Articles 2015/05/27 | Source: SimpleTalk | Category: percent_rank
Rating: (not yet rated)  Rate this |   Briefcase | 3,105 reads

Storing a Binary File in a Database

In this article you will see how to convert a file to a binary stream and insert it into SQL Server with SQLCLR.  Read more...
By Eric Notheisen 2015/05/26 | Source: | Category: binary conversion
Rating: |  Discuss |   Briefcase | 5,793 reads

Webinar: How to safely manage application and database changes with continuous delivery

Join Brian A. Randell, Grant Fritchey and Steve Jones in this panel discussion to hear tips, ideas and share your questions on managing application and database deployments with continuous delivery. This Free webinar will be on May 27th at 4PM BST, register while space is available.  Read more...
By Press Release 2015/05/26 (first published: 2015/05/21) | Source: Redgate | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 7,504 reads

SQL Monitor Custom metric: Average I/O stalls

This is a good general indicator of performance problems. High stall times indicate I/O problems, which can be attributed to busy physical disks or queries that return large data sets to the client.  Read more...
By Press Release 2015/05/26 | Source: Redgate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 2,852 reads
Ask SQL Server Central

From the SQLServerCentral Blogs

Extending your metadata with Extended Properties

Ever wanted to put a comment on a table? Or maybe even a column? How about an expiration date on...  Read more...
By Kenneth Fisher 2015/05/28 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,827 reads

Creating an Azure SQL Database

By David Postlethwaite Once you have logged in to the Azure Management Portal you can start to  create an Azure SQL...  Read more...
By David Postlethwaite 2015/05/28 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,709 reads
Question of the Day

Operator Description

By Junior Galvão - MVP 2015/05/28 | Category: execution plan
Rating: (not yet rated) |  Discuss |   Briefcase | 667 reads

Which of the Execution Plan operators can be recognized as a logical and physical operator when we use the aggregate functions: Min, Max, Sum, Count or Avg?

Top Members (last 30 days)
# Name Score Level
30 days All-time
Jacob Wilkins
540 849 SSC Eights!  
Junior Galvão - MVP
467 780 Right there with Babe  
458 1449 Ten Centuries  
Shiva N
450 1843 SSCommitted  
Jeff Moden
361 37459 SSC-Dedicated  
Latest forum posts