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

Rss
Headlines today   July 28, 2015

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: SQLServerCentral.com | Category: jobs
Rating: |  Discuss |   Briefcase | 383 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: SQLPerformance.com | Category: msdb
Rating: (not yet rated)  Rate this |   Briefcase | 158 reads
Previous headlines

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: SQLServerCentral.com | Category: set-based loop
Rating: |  Discuss |   Briefcase | 8,564 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: SQLServerCentral.com | Category: backup to azure
Rating: (not yet rated) |  Discuss |   Briefcase | 466 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 | 2,886 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: SQLServerCentral.com | Category: san
Rating: |  Discuss |   Briefcase | 14,546 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,212 reads

SQL Explained

A short explanation and infographic of what SQL is. For the non-SQL people in your life.  Read more...
By Additional Articles 2015/07/24 | Source: Other | Category: sql
Rating:  Rate this |   Briefcase | 5,309 reads

Is It Worth Writing Unit Tests?

What's the overhead for writing unit tests? Ed Elliot breaks it down, looking at the ways in which unit tests both take more time and save time.  Read more...
By Ed Elliott 2015/07/23 | Source: SQLServerCentral.com | Category: unit testing
Rating: |  Discuss |   Briefcase | 5,232 reads

Large SQL Server Database Backup on an Azure VM and Archiving

For a large SQL Server database on an Azure VM, backing up the data can have some challenges. In this article, Murshed Zaman focuses on the two most common challenges: size and speed.  Read more...
By Additional Articles 2015/07/23 | Source: SQLCAT | Category: azure vm
Rating:  Rate this |   Briefcase | 3,781 reads
 
Ask SQL Server Central



From the SQLServerCentral Blogs

Include File Name in Content Using Power Query

When importing data from a flat file using Power Query, you’d want to combine multiple files and include file name...  Read more...
By Samuel Vanga 2015/07/28 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 115 reads

Excel BI Tip #28: Using member expressions in the CUBEVALUE Function

As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...  Read more...
By DataOnWheels 2015/07/28 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 120 reads
Question of the Day

NOT IN

By Sergey Gigoyan 2015/07/28 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 76 reads

What number of rows are returned in this select statement?

CREATE TABLE #tmpNewValue
(
Value INT
);
CREATE TABLE #tmpOldValue
(
Value INT
);


INSERT INTO #tmpNewValue(Value) VALUES (1),(3),(7),(5),(4)
INSERT INTO #tmpOldValue(Value) VALUES (3),(7),(NULL),(6)

SELECT Value
FROM #tmpNewValue
WHERE Value NOT...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
Rajan Patel
623 651 SSChasing Mays  
2.
Iwas Bornready
519 4928 SSCarpal Tunnel  
3.
sergey.gigoyan
482 482 SSC-Addicted  
4.
meena.ramamani 93602
373 936 SSC Eights!  
5.
Piotr Ryszkowski
309 2123 SSCrazy  
Latest forum posts