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,817,531 DBAs, developers and SQL Server users

Headlines today   July 29, 2015

Stairway to SQL Server Security Level 10: Row-Level Security

Unlike some other industrial-strength database servers, SQL Server lacks a built-in mechanism for protecting individual data records, called row-level security. This stairway level explores why you might want to use such a low-level granularity of data access security and how you can implement row-level security.  Read more...
By Don Kiely 2015/07/29 | Source: | Category: stairway series
Rating: (not yet rated) |  Discuss |   Briefcase | 343 reads

Free eBook: SQL Server Hardware

SQL Server Hardware will provide the fundamental knowledge and resources you need to make intelligent decisions about choice, and optimal installation and configuration, of SQL Server hardware, operating system and the SQL Server RDBMS.  Read more...
By Press Release 2015/07/29 (first published: 2013/07/24) | Source: Redgate | Category: hardware
Rating:  Rate this |   Briefcase | 45,919 reads

Demystifying Oracle's Clustering Factor

One of the more confusing statistics in Oracle is one called the clustering factor. Associated with an index, it's actually dependent on the table data, more specifically the distance between 'jumps' for a given index key. Commonly, a 'jump' is the number of blocks between rows containing the given index key starting with the first block found containing that key. If that sounds confusing don't despair, David Fitzjarrell explains in detail.   Read more...
By Additional Articles 2015/07/29 | Source: Database Journal
Rating: (not yet rated)  Rate this |   Briefcase | 222 reads
Previous headlines

Visualize the timeline of your SQL jobs using Google graph and email

Generate an HTML page with the timeline of your SQL jobs using Google graph and sp_send_dbmail  Read more...
By Theo Ekelmans 2015/07/28 | Source: | Category: jobs
Rating: |  Discuss |   Briefcase | 5,565 reads

The Importance of Maintenance on MSDB

MSDB is a system database used by SQL Server. MSDB stores all sorts of data, such as backup history, log shipping monitor history, SSIS packages and Service Broker queue data to name a few. Just like user databases, MSDB needs regular maintenance, including index optimizations and, more importantly, regular purging. In this article, Tim Radney looks at how neglecting your MSDB can negatively impact on your environment.   Read more...
By Additional Articles 2015/07/28 | Source: | Category: msdb
Rating:  Rate this |   Briefcase | 3,647 reads

Introducing the Set-based Loop

Set-based programming doesn’t mean “no loops” or a single statement. Finding out the best ways to traverse a full hierarchy.  Read more...
By Luis Cazares 2015/07/27 | Source: | Category: set-based loop
Rating: |  Discuss |   Briefcase | 9,770 reads

Learning Backup to Azure

References and links to get you started in backing up your database to the Azure blob storage.  Read more...
By Site Owners 2015/07/27 | Source: | Category: backup to azure
Rating: (not yet rated) |  Discuss |   Briefcase | 538 reads

Can Code Review Be Automated?

Code must be checked, but how? Phil Factor shares his thoughts on automating SQL code reviews.  Read more...
By Additional Articles 2015/07/27 | Source: SimpleTalk | Category: code review
Rating: (not yet rated)  Rate this |   Briefcase | 3,376 reads

SAN and NAS protocols and how they impact SQL Server

Discusses the various SAN and NAS protocols (FC, iSCSI, NFS) and how choosing one over the other can impact your SQL Server Performance.  Read more...
By Gregory Jackson 2015/07/24 (first published: 2012/04/24) | Source: | Category: san
Rating: |  Discuss |   Briefcase | 14,771 reads

SQL Style Habits: Attack of the Skeuomorphs

Although we like to think that our programming techniques are progressive and in tune with the bleeding edge of software development practices, too often they are directly influenced by restrictions faced when computers first became mainstream in the post-war decades. In this article Joe Celko looks at the history of mainframes, FORTRAN I and COBOL.   Read more...
By Additional Articles 2015/07/24 | Source: SimpleTalk | Category: joe celko
Rating:  Rate this |   Briefcase | 3,394 reads
Ask SQL Server Central

From the SQLServerCentral Blogs

AdventureworksCI Step 4 Pushing to GitHub

This is part of a series on how to take the Adventureworks database and bring it in line with modern...  Read more...
By Ed Elliott 2015/07/29 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 122 reads
Question of the Day

SELECT @local_variable

By Naveen PK 2015/07/29 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 152 reads

What is the output for the below query?



INSERT INTO #Values Values (2),(1),(4),(3)

SELECT @x = Value
FROM #values
order by value desc

SELECT @x AS AssignedValue

Top Members (last 30 days)
# Name Score Level
30 days All-time
Rajan Patel
635 663 SSChasing Mays  
Iwas Bornready
564 4973 SSCarpal Tunnel  
502 502 Mr or Mrs. 500  
Piotr Ryszkowski
389 2203 SSCrazy  
meena.ramamani 93602
374 937 SSC Eights!  
Latest forum posts