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

   Items 1 to 20 of 13769    Older >>
 

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 | 2,858 reads

The Hidden Patterns in Data

Looking at statistics and data to draw conclusions can be hard. Steve Jones comments on an interesting way of analyzing data from TED.  Read more...
By Steve Jones 2015/05/28 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 67 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 | 5,020 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 | 2,916 reads

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,883 reads

Byte Me: State Of Flow

Flushing the cache.  Read more...
By Bob Lang 2015/05/27 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 100 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,308 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,176 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,845 reads

Hack Us

A challenge from United intrigues Steve Jones. How many other companies would make a challenge like this?  Read more...
By Steve Jones 2015/05/26 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 109 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,542 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 | 5,020 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,886 reads

The Cascading (CROSS) APPLY

An old trick nowadays but one which is still underused here on SSC is the cascading CROSS APPLY – where output from one CROSS APPLY is used as input for another.  Read more...
By Chris Morris 2015/05/25 (first published: 2013/04/16) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 18,428 reads

Memorial Day 2015

A short note on Memorial Day  Read more...
By Steve Jones 2015/05/25 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 57 reads

The Scientific Method: a call to action

Gail Shaw issues a rallying call for the SQL Community to adopt the Scientific Method when investigating and reporting on SQL Server behavior.  Read more...
By Gail Shaw 2015/05/25 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 151 reads

Optimizing Batch Process in SQL Server

SQL Server batch processes are usually run from SQL Agent in the background. Often, the responsibility for creating these tasks belongs entirely to the developer. Dennes Torres demonstrates that DBAs can advise and assist with this type of batch job to help reduce their impact on the working system.  Read more...
By Additional Articles 2015/05/25 | Source: SimpleTalk | Category: batch processing
Rating: (not yet rated)  Rate this |   Briefcase | 4,270 reads

Native Audits

This week Steve Jones asks if you're using the SQL Audit feature built into SQL Server.  Read more...
By Steve Jones 2015/05/22 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 93 reads

Big Data for SQL folks: The Technologies (Part I)

Will RDBMs be obsolete? Should Data Professionals care about Big Data technologies? What is NoSQL? What is Hadoop? Big Data-the whole story.  Read more...
By Frank A. Banin 2015/05/22 (first published: 2013/06/26) | Source: SQLServerCentral.com | Category: big data
Rating: |  Discuss |   Briefcase | 20,684 reads

Developer-Tester Relationships

In a development team, there are times when the relationships between developers and testers can become strained. How can you turn this potential conflict into something more positive? Is it part of the skill of team-working to find ways of avoiding friction, or should one blame a system that relies on good social skills to work well?  Read more...
By Additional Articles 2015/05/22 | Source: SimpleTalk | Category: soft skills
Rating:  Rate this |   Briefcase | 6,306 reads
   Items 1 to 20 of 13769    Older >>