SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,892,638 DBAs, developers and SQL Server users

Rss
Headlines today   October 19, 2017

SQL Server Performance Benchmarking with Patterns

A SQL Server, SQL Azure and Hekaton performance bench marking application that uses patterns.  Read more...
By Paul Brewer 2017/10/19 | Source: SQLServerCentral.com | Category: performance
Rating: |  Discuss |   Briefcase | 291 reads

Simple SQL: Random Thoughts

How does one get a truly random sample of data of a certain size from a SQL Server database table. Well, there are simple non-portable tricks one can use, such as the NewID() function, but then refining those can be tricky. Take the Rand() function for a start. Can it really provide you with a truly random number? Why doesn't the TABLESAMPLE clause give you a set number of rows? Joe Celko scratches his head a bit, explains some of the issues and invites some suggestions and tricks from readers.  Read more...
By Additional Articles 2017/10/19 | Source: SimpleTalk | Category: t-sql
Rating: (not yet rated)  Rate this |   Briefcase | 883 reads

Discover database DevOps and more at PASS Summit

PASS Summit lands in Seattle from October 31 to November 3 this year, bringing with it the latest thinking and developments in the SQL Server world. This blog post from Annabel Bradford gives the details of what Redgate willl be presenting on, when this year's Redgate Rocks party will be, and how you can get involved with the team!  Read more...
By 2017/10/19 | Source: Redgate | Category: pass summit
Rating: (not yet rated)  Rate this |   Briefcase | 382 reads
Previous headlines

Deeper into Nonclustered Indexes: Stairway to SQL Server Indexes Level 2

By this stage, you should be familiar with the basics of SQL Server indexes. We've discussed what an Index actually is, as well as some of the most common types you're likely to encounter. Now that we've seen some simple examples of how Indexes can be useful, we're going to delve deeper into nonclustered indexes, as we'll see how they can improve the performance of more complex queries.  Read more...
By David Durant 2017/10/18 (first published: 2014/11/26) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 28,055 reads

Free eBook: Understanding SQL Server Concurrency

When you can’t get to your data because another application has it locked, a thorough knowledge of SQL Server concurrency will give you the confidence to decide what to do.  Read more...
By Press Release 2017/10/18 (first published: 2013/07/17) | Source: Redgate | Category: concurrency
Rating:  Rate this |   Briefcase | 88,599 reads

SQL Server AlwaysOn Availability Groups Using an Azure Template

There is already a template on the Azure marketplace for setting up an AlwaysOn Availability Group. In just a few easy steps you can get a working AlwaysOn Availability Group setup, configured and running - this post describes the steps to quickly set it up.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 1,005 reads

Introduction to Statistics

This article will give a brief overview of how statistics are generated, stored, and used in SQL Server.  Read more...
By Johnny Bieber 2017/10/17 | Source: SQLServerCentral.com | Category: statistics
Rating: |  Discuss |   Briefcase | 1,173 reads

A Freecon Halloween at the PASS Summit

If you're attending the PASS Summit in 2017, there's a Freecon day on Tuesday you can attend.  Read more...
By Press Release 2017/10/17 (first published: 2017/10/13) | Source: SQLServerCentral.com | Category: events
Rating: (not yet rated) |  Discuss |   Briefcase | 269 reads

Key Lookups and ColumnStore Indexes

Erik figures out why SQL Server really doesn't like combining these two things in a query plan.  Read more...
By Additional Articles 2017/10/17 | Source: Brent Ozar Unlimited Blog | Category: key lookup
Rating: (not yet rated)  Rate this |   Briefcase | 1,988 reads

Loading Data using R and PowerBI

I'm not a fan of R visuals in PowerBI. I recently learned I can use R to load data and native PowerBI visuals to display the data. Here's how.  Read more...
By Nick Burns 2017/10/16 | Source: SQLServerCentral.com | Category: r language
Rating: |  Discuss |   Briefcase | 603 reads
 

From the SQLServerCentral Blogs

Avoid “Constants” in T-SQL

Unlike some other languages, T-SQL doesn’t have the concept of a constant. As good coders, we’ve all at some point tried...  Read more...
By matthew.mcgiffen 73574 2017/10/19 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,398 reads

SQL Server Temporal Tables

Temporal data storage, which was defined in the ANSI SQL:2011 standard, describes an architecture in which relational databases maintain row-level...  Read more...
By Tim Mitchell 2017/10/19 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 847 reads
Question of the Day

sp_helptext

By Steve Jones 2017/10/19 | Category: sp_helptext()
Rating: (not yet rated) |  Discuss |   Briefcase | 276 reads

What's the limit on text in each row returned by sp_helptext()?

  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
GilaMonster
49804 414248 SSC Guru  
2.
Jeff Moden
45676 379767 SSC Guru  
3.
Steve Jones - SSC Editor
28176 248958 SSC Guru  
4.
Lynn Pettis
19463 167649 SSC Guru  
5.
Grant Fritchey
18908 162637 SSC Guru  
Latest forum posts