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,557 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,592 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,720 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,570 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,910 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,341 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,349 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,794 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,941 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,015 reads
Ask SQL Server Central

Question of the Day


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

What does Federation_Filtering_Value() return in T-SQL?

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