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

Welcome to SQLServerCentral.com

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

Rss
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: SQLServerCentral.com | Category: clr
Rating: |  Discuss |   Briefcase | 692 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: SQLServerCentral.com | Category: survey
Rating: (not yet rated)  Rate this |   Briefcase | 3,891 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: MSSQLTips.com | Category: dates and conversion
Rating: (not yet rated)  Rate this |   Briefcase | 1,150 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: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 4,466 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 | 55,975 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 | 2,869 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: SQLServerCentral.com | Category: binary conversion
Rating: |  Discuss |   Briefcase | 5,495 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,347 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,772 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 | 873 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 | 863 reads
Question of the Day

Operator Description

By Junior Galvão - MVP 2015/05/28 | Category: execution plan
Rating: (not yet rated) |  Discuss |   Briefcase | 152 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?

  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
Jacob Wilkins
547 845 SSC Eights!  
2.
Junior Galvão - MVP
469 773 Right there with Babe  
3.
SimonH
458 1449 Ten Centuries  
4.
Shiva N
450 1843 SSCommitted  
5.
Jeff Moden
363 37455 SSC-Dedicated  
Latest forum posts