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,865,731 DBAs, developers and SQL Server users

Headlines today   August 23, 2016

What is the impact of setting SET ANSI_WARNINGS OFF?

Setting ANSI_WARNINGS OFF to avoid NULL value elimination warnings can have an impact on the data quality and system behaviour.  Read more...
By Nakul Vachhrajani 2016/08/23 | Source: | Category: set options
Rating: |  Discuss |   Briefcase | 1,642 reads

Trace Flag 2389 and the new Cardinality Estimator

Erin Stellato shows the combined effect of different versions of the cardinality estimator and trace flag 2389 on an ascending key model.  Read more...
By Additional Articles 2016/08/23 | Source: | Category: trace flag
Rating: (not yet rated)  Rate this |   Briefcase | 1,385 reads
Previous headlines

A Tutorial With the Azure CLI (Command-Line Interface) and Azure SQL Database

In this article, we will show how to install Azure CLI and then create an Azure SQL Server and a SQL Database.  Read more...
By Daniel Calbimonte 2016/08/22 | Source: | Category: command
Rating: |  Discuss |   Briefcase | 427 reads

Software Animism

Have you ever accused an application of deliberately trying to make your life a misery? Simple Talk's Tony Davis talks animism in this week's editorial, and wants to hear your stories in the comments for the chance to win a $50 Amazon gift card.  Read more...
By Additional Articles 2016/08/22 | Source: SimpleTalk | Category: simple talk
Rating: (not yet rated)  Rate this |   Briefcase | 2,179 reads

Writing Better T-SQL: Top-Down Design May Not be the Best Choice – Part II

A second part to the series by Mickey Stuewe on writing better T-SQL looks at some of the issues of using views in a complex query.  Read more...
By Mickey Stuewe 2016/08/19 (first published: 2015/06/23) | Source: | Category: t-sql
Rating: |  Discuss |   Briefcase | 10,323 reads

Call for Articles

SQLServerCentral is looking for articles on a few topics. Read more to find out how to submit a draft.  Read more...
By Press Release 2016/08/19 (first published: 2016/08/12) | Source: | Category: sqlservercentral
Rating: |  Discuss |   Briefcase | 726 reads

Windows Containers and Docker

Windows Server 2016 features support for containers. These are not Linux-based, but containers that run on Windows and run Windows on the inside. These conform to the Open Container Initiative (OCI). They allow you to run applications insulated from the rest of the system, within portable containers that include everything an application needs to be fully functional. As they did with Linux, containers will change the nature of the software supply chain for Windows users.  Read more...
By Additional Articles 2016/08/19 | Source: SimpleTalk | Category: windows containers
Rating: (not yet rated)  Rate this |   Briefcase | 4,229 reads

Beyond prediction with R & SQL Server

Predictive / prescriptive analytics is regarded the highest level of advanced analytics. In this post, we emphasise the importance of exploratory analytics to derive meaningful insight.  Read more...
By Nick Burns 2016/08/18 | Source: | Category: r language
Rating: |  Discuss |   Briefcase | 1,345 reads

Why Not Just Create Statistics?

Erik Darling looks at why you should be more interested in up to date statistics, and also why statistics outside of indexes aren’t really the most helpful thing.  Read more...
Rating:  Rate this |   Briefcase | 2,984 reads

Stairway to SQL Server Extended Events Level 4: Extended Events Engine - Essential Concepts

In this level, we're going to dig a little deeper into the Extended Events engine, its architecture, and fundamental components. It will give you a deeper understanding of why, in general, an Extended Events session is inherently lower in overhead than an equivalent SQL Trace. We'll also investigate how to design our event sessions to minimize any unnecessary overhead during event data collection, even when we need to create relatively complex event sessions to investigate difficult performance problems.  Read more...
By Erin Stellato 2016/08/17 | Source: | Category: stairway series
Rating: |  Discuss |   Briefcase | 756 reads
Ask SQL Server Central

From the SQLServerCentral Blogs

Query Store, Force Plan and Dropped Objects

I love the Query Store. Seriously. It’s a huge leap forward in the capabilities of Azure SQL Database and SQL...  Read more...
By Grant Fritchey 2016/08/23 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 897 reads

Can You Trust Your Cloud?

“How do I know my data is secure?” “A lot of companies have been hacked lately, why would I want to...  Read more...
By Bradley Schacht 2016/08/23 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,079 reads
Question of the Day

Rounding Rules

By Steve Jones 2016/08/23 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 796 reads

If I run this code:


I get the result of 0.3. What happens if I set the value of @i = 1.7 as in this code?

DECLARE... 
Top Members (last 30 days)
# Name Score Level
30 days All-time
798 1209 Ten Centuries  
GP Van Eron
615 1693 SSCommitted  
451 1856 SSCommitted  
373 521 Mr or Mrs. 500  
361 364 Old Hand  
Latest forum posts