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,831,363 DBAs, developers and SQL Server users

Headlines today   October 7, 2015

Level 4 - Building the Hyper-V VM

In this level of the Stairway to Server Virtualization, learn how to build a Hyper-V virtual machine for SQL Server.  Read more...
By David Klee 2015/10/07 | Source: | Category: virtualization
Rating: |  Discuss |   Briefcase | 2,170 reads

Follow-Up on Cursor Options

In this follow-up to a previous article, Aaron Bertrand reiterates that – while you should never just accept the defaults – you really should think about which options are most applicable to your scenario.  Read more...
By Additional Articles 2015/10/07 | Source: | Category: cursor options
Rating: (not yet rated)  Rate this |   Briefcase | 2,230 reads
Previous headlines

SSIS Design Pattern - Staging Fixed Width Flat Files

Learn how to load fixed width flat files to staging tables in this article from Samuel Vanga.  Read more...
Rating: |  Discuss |   Briefcase | 3,107 reads

Shorten Audits, Tighten Security with Minion Enterprise

Minion Enterprise can help you with security management in an enterprise.  Read more...
By Press Release 2015/10/06 | Source: | Category: press release
Rating: |  Discuss |   Briefcase | 475 reads

Automatic UNDO in Oracle

Automatic UNDO Management isn't voodoo or black magic, although it can seem that way when it isn't clearly understood. How does Oracle decide how many UNDO segments to create at startup, and what is the underlying goal of the process? David Fitzjarrell investigates.  Read more...
By Additional Articles 2015/10/06 | Source: Database Journal | Category: oracle
Rating: (not yet rated)  Rate this |   Briefcase | 1,552 reads

Write Cleaner T-SQL Using Version Control

If we only use version control as a way to back up our code then it is pure overhead but actually there are real benefits. We can use source control to write better, cleaner, more readable code.  Read more...
By Ed Elliott 2015/10/05 | Source: | Category: source control
Rating: |  Discuss |   Briefcase | 4,909 reads

Learning about FOR JSON

Links and information about the FOR JSON clause in SQL Server 2016.  Read more...
By Site Owners 2015/10/05 | Source: | Category: for json
Rating: |  Discuss |   Briefcase | 2,751 reads

Power Query Formula Language in Power BI Desktop

The Power Query Formula Language (PQFL) is a functional language that drives the Power BI transformations, and allows you to create mashup queries from scratch. In this article, Rob Sheldon demonstrates how to use it in Power BI Desktop to extract data from its source, filter rows, specify the columns, clean the data, and create visualisations.  Read more...
By Additional Articles 2015/10/05 | Source: SimpleTalk | Category: power bi
Rating:  Rate this |   Briefcase | 1,575 reads

SQL Server Stored Procedures and SET options

SET options on stored Procedures work a bit different when compared with ad-hoc queries. These differences in behavior are often overlooked when developing the procedures and generating deployment scripts. This mistake can lead to undesired behavior in the application.  Read more...
By Nakul Vachhrajani 2015/10/02 (first published: 2013/08/29) | Source: | Category: stored procedures
Rating: |  Discuss |   Briefcase | 14,150 reads

How to Avoid Conditional JOINs in T-SQL

Relational databases go out of their way to execute SQL, however bad the crimes against Codd and relational theory within the query might be. The 'conditional join' can be executed, but at great cost. As always, it is much better to sit back and restate the problem in a set-based way - Dwain Camps explains.   Read more...
By Additional Articles 2015/10/02 | Source: SimpleTalk | Category: t-sql
Rating:  Rate this |   Briefcase | 5,113 reads
Ask SQL Server Central

From the SQLServerCentral Blogs

Do you write ugly T-SQL?

Are your scripts littered with commented blocks of T-SQL code? select fname,lname from usertable where id=1 --and lname like 'smith%' /* -- Who knows why...  Read more...
By cjsommer 2015/10/07 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 3,971 reads

Load Testing Your Storage Subsystem with Diskspd – Part II

In this post we’re going discuss how to implement load testing of your storage subsystem with DiskSpd. We’re going to...  Read more...
By Anthony Nocentino 2015/10/07 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 720 reads
Question of the Day

Composite foreign key

By Igor Micev 2015/10/07 | Category: foreign key
Rating: (not yet rated) |  Discuss |   Briefcase | 689 reads

There is a table dbo.AllEvents with a composite primary key ([EventID], [TenantName], [Identifier]). Table dbo.LinkDWHTables has the columns [AllEvents_EventID], [AllEvents_TenantName], [AllEvents_Identifier] with identical data types.
I try to create the following... 
Top Members (last 30 days)
# Name Score Level
30 days All-time
1035 1101 Ten Centuries  
Piotr ER
893 4492 SSCarpal Tunnel  
838 1405 Ten Centuries  
Iwas Bornready
409 5511 SSCertifiable  
397 834 SSC Eights!  
Latest forum posts