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,830,602 DBAs, developers and SQL Server users

Previous headlines

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 | 12,710 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: (not yet rated)  Rate this |   Briefcase | 3,862 reads

Navigating Hadoop Resources

Learn where to get the latest installation and learning resources for the ever-evolving components of Hadoop ecosystem and how those components may complement Microsoft SQL Server common everyday tasks.  Read more...
By Daniel Klionsky 2015/10/01 | Source: | Category: big data
Rating: |  Discuss |   Briefcase | 2,613 reads

Creating Dashboards for Mobile Devices with Datazen

In this fourth installment, Arshad Ali demonstrates creating filters, publishing dashboards to the Datazen server and creating drill-through dashboards.  Read more...
By Additional Articles 2015/10/01 | Source: Database Journal | Category: mobile dashboard
Rating: (not yet rated)  Rate this |   Briefcase | 1,965 reads

Stairway to MDX - Level 15: Basic Set Functions: The Tail() Function

Return, in order, a specified number of elements from the end of a set. SSAS Maestro, SQL Server MVP and Business Intelligence Architect Bill Pearson introduces the MDX Tail() function.  Read more...
By Bill Pearson 2015/09/30 | Source: | Category: stairway series
Rating: |  Discuss |   Briefcase | 2,348 reads

Install SQL Server Management Studio with Web Installer without Internet Access

One of the new features of SQL Server 2016 is the introduction of a Web Installer for the client tools. In this article, Daniel Farina goes through the entire process of downloading and installing the client tools even on machines without internet access.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 1,383 reads

Wildcard Searches

Using wildcard to find patterns in strings going from the basics to some more complicated conditions.  Read more...
By Luis Cazares 2015/09/29 | Source: | Category: t-sql
Rating: |  Discuss |   Briefcase | 6,826 reads

A general way to maintain History tables

You will see here a way to handle history tables. This way only takes into account Date-based data cleanup but is easily generalizable.  Read more...
By Jefferson Elias 2015/09/28 | Source: | Category: maintenance
Rating: |  Discuss |   Briefcase | 6,960 reads

Learning the Query Store

Links and references to understand what the Query Store is in SQL Server 2016.  Read more...
By Site Owners 2015/09/28 | Source: | Category: sql server 2016
Rating: (not yet rated) |  Discuss |   Briefcase | 2,018 reads
Ask SQL Server Central

Question of the Day


By Steve Jones 2015/10/02 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 604 reads

What does Federation_Filtering_Value() return in T-SQL?

Top Members (last 30 days)
# Name Score Level
30 days All-time
1020 1086 Ten Centuries  
Piotr ER
918 4339 SSCarpal Tunnel  
851 1405 Ten Centuries  
397 834 SSC Eights!  
Iwas Bornready
345 5447 SSCertifiable  
Latest forum posts