Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Welcome to

A Microsoft SQL Server community of 1,859,687 DBAs, developers and SQL Server users

Headlines today   May 31, 2016

Third Party Visuals in Power BI Desktop

Power BI is as extensible as it is powerful In this article you will see how to impress your users with added visuals  Read more...
By Adam Aspin 2016/05/31 | Source: | Category: power bi
Rating: |  Discuss |   Briefcase | 1,027 reads

Is a RID Lookup faster than a Key Lookup?

For T-SQL Tuesday #78, Aaron Bertrand takes a look at whether RID Lookups are faster than Key Lookups, with a small battery of fairly simple duration tests.  Read more...
By Additional Articles 2016/05/31 | Source: | Category: rid lookup
Rating: (not yet rated)  Rate this |   Briefcase | 2,038 reads
Previous headlines

Stairway to Columnstore Indexes Level 1: A First Look At Columnstore Indexes

This level introduces of you to the fundamentals of columnstore indexes, introdused in SQL Server 2012 to manage the indexing of very large tables.  Read more...
By Hugo Kornelis 2016/05/30 (first published: 2015/02/25) | Source: | Category: stairway series
Rating: |  Discuss |   Briefcase | 10,979 reads

Connecting to SQL Data Warehouse

The most frustrating thing with any new system is often just working out how to connect to it. Oddly, you can’t use SSMS with SQL Data Warehouse, but it is fine with SSDT, SSIS, Power BI desktop, sqlcmd, BCP, and a range of Microsoft cloud services - there are PowerShell Cmdlets too. Rob Sheldon provides the details.  Read more...
By Additional Articles 2016/05/30 | Source: SimpleTalk | Category: sql data warehouse
Rating: (not yet rated)  Rate this |   Briefcase | 1,461 reads

Dynamically Query a 100 Million Row Table-Efficiently

This article describes methods of creating dynamic queries without the use of dynamic SQL to efficiently access large tables.  Read more...
By Gary Strange 2016/05/27 (first published: 2015/02/24) | Source: | Category: t-sql
Rating: |  Discuss |   Briefcase | 23,146 reads

Automatically Creating UML Database Diagrams for SQL Server

SQL Server database developers seem reluctant to use diagrams when documenting their databases. It is probably because it has, in the past, been difficult to automatically draw precisely what you want, other than a vast Entity-relationship diagram. However, you can do it without buying any third-party tool, just using some existing Java-based open-source tools; and can even automate it entirely, using SQL and PowerShell. Phil Factor shows how.  Read more...
By Additional Articles 2016/05/27 | Source: SimpleTalk | Category: diagrams
Rating: (not yet rated)  Rate this |   Briefcase | 2,958 reads

Diagnosing parallelism-related latching

Diagnosing and resolving parallelism-related latching and blocking in SQL Server using DMV’s, the activity monitor, procedure execution plans, and index tuning.   Read more...
By David Fundakowski 2016/05/26 | Source: | Category: parallelism
Rating: |  Discuss |   Briefcase | 1,246 reads

A tour through tool improvements in SQL Server 2016

Ayo Olubeko talks through the improvements being made to SQL Server tooling in 2016.  Read more...
By Additional Articles 2016/05/26 | Source: SQLCAT | Category: sql server 2016
Rating: (not yet rated)  Rate this |   Briefcase | 3,293 reads

Stairway to SQL Server Extended Events Level 3: Working with the Extended Events UI

In the next installment of our stairway to Extended Events, we delve into the Live Data and Target Data Viewers.  Read more...
By Erin Stellato 2016/05/25 | Source: | Category: extended events
Rating: |  Discuss |   Briefcase | 984 reads

Free eBook: Performance Tuning with SQL Server Dynamic Management Views

Dynamic Management Views (DMVs) are a significant and valuable addition to the DBA's troubleshooting armory, laying bare previously unavailable information regarding the under-the-covers activity of your database sessions and transactions.  Read more...
By Additional Articles 2016/05/25 (first published: 2013/08/21) | Source: Redgate | Category: performance tuning
Rating:  Rate this |   Briefcase | 67,574 reads
Ask SQL Server Central

From the SQLServerCentral Blogs

Bad Data Can Kill

Bad data can kill. Literally. I’m not talking about the impact of bad data on the bottom line of business,...  Read more...
By Tim Mitchell 2016/05/31 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,260 reads

Identity increment is jumping in SQL Server database

Please look at the below screenshot to understand what jumping of identity value is (It is taken from SQL 2014...  Read more...
By 2016/05/31 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,271 reads
Question of the Day

Implicit Conversion

By Sasidhar Pulivarthi 2016/05/31 | Category: union
Rating: (not yet rated) |  Discuss |   Briefcase | 832 reads
How many rows will be returned by the following query in SQL 2014 Developer Edition?

DECLARE @tbl TABLE ( id INT, Name VARCHAR(5) );

        1 AS Id
      , 'ABC' AS... 
Top Members (last 30 days)
# Name Score Level
30 days All-time
996 1017 Ten Centuries  
Iwas Bornready
868 7816 SSCertifiable  
520 1984 SSCommitted  
384 384 Old Hand  
362 613 SSChasing Mays  
Latest forum posts