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

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,888,317 DBAs, developers and SQL Server users

Rss
Headlines today   July 24, 2017

The Case of the Space at the End

A gripping expose into the deep, dark world of ANSI_PADDING! What could be more exciting?  Read more...
By Adam St. Pierre 2017/07/24 | Source: SQLServerCentral.com | Category: ansi_padding
Rating: |  Discuss |   Briefcase | 1,130 reads

Extending DevOps practices to SQL Server databases – Branching & Merging with VSTS

Join Microsoft Data Platform MVP Steve Jones for the next Database DevOps demo webinar on July 25. He’ll be plugging Redgate tools into Visual Studio Team Services and showing how you can branch and merge your database changes. Sign up now.  Read more...
By 2017/07/24 (first published: 2017/07/20) | Source: Redgate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 4,272 reads

Testing DML Statements for In-Memory OLTP

Erin Stellato takes a thorough look at the way DML statements might benefit from In-Memory OLTP, especially with natively compiled stored procedures.  Read more...
By Additional Articles 2017/07/24 | Source: SQLPerformance.com | Category: dml
Rating: (not yet rated)  Rate this |   Briefcase | 1,125 reads
Previous headlines

SQL Server Management Studio add-ins

Complete list of useful and must have add-ins for SQL Server Management Studio - 32 SSMS add-ins  Read more...
By Konstantin Taranov 2017/07/21 | Source: SQLServerCentral.com | Category: ssms
Rating: |  Discuss |   Briefcase | 2,068 reads

SQL Server User-Defined Functions

User-Defined Functions (UDFs) are an essential part of the database developers' armoury. They are extraordinarily versatile, but just because you can even use scalar UDFs in WHERE clauses, computed columns and check constraints doesn't mean that you should. Multi-statement UDFs come at a cost and it is good to understand all the restrictions and potential drawbacks. Phil Factor gives an overview of User-defined functions: their virtues, vices and their syntax.  Read more...
By Additional Articles 2017/07/21 | Source: SimpleTalk | Category: t-sql
Rating: (not yet rated)  Rate this |   Briefcase | 3,231 reads

Resolve Network Binding Order Warning in failover cluster

In this article, I’m going to show a procedure to resolve an issue that I found while running cluster validation report. you may receive below warning message that includes information about the cause of the warning, which can help you to resolve the issue.  Read more...
By Ganapathi varma Chekuri 2017/07/20 | Source: SQLServerCentral.com | Category: sql cluster
Rating: |  Discuss |   Briefcase | 257 reads

Find Database Connection Leaks in Your Application

Michael Swart shows how to investigate and fix database connection leaks, an application issue that can lead to connection timeouts.  Read more...
By Additional Articles 2017/07/20 | Source: SQLPerformance.com | Category: connection
Rating: (not yet rated)  Rate this |   Briefcase | 2,810 reads

Stairway to Advanced T-SQL Level 8: Functions to Generate Date and Time values

When you build applications that store records in SQL Server you will most likely have to store date and time values as part of the data. To manage all the different date related tasks you might need to perform Microsoft has introduced a number of date functions. In this stairway I will be exploring those date and time functions.  Read more...
By Gregory Larsen 2017/07/19 (first published: 2015/10/21) | Category: stairway series
Rating: |  Discuss |   Briefcase | 7,234 reads

Free eBook: SQL Server Internals: In-Memory OLTP

In this free eBook, Kalen Delaney explains how Microsoft's new In-memory OLTP engine works. In her book, learn how to use lock- and latch-free data structures to allow non-blocking data processing, and find out how to migrate existing tables to Hekaton.  Read more...
By Press Release 2017/07/19 (first published: 2015/05/13) | Source: Redgate | Category: ebook
Rating:  Rate this |   Briefcase | 37,735 reads
 

Ask SQL Server Central

From the SQLServerCentral Blogs

Think twice before using table variables

T-SQL Tuesday For T-SQL Tuesday this month Raul Gonzalez has asked us all to blog about lessons learnt the hard way: http://www.sqldoubleg.com/2017/07/03/tsql2sday-92-lessons-learned-the-hard-way/ My...  Read more...
By matthew.mcgiffen 73574 2017/07/24 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,269 reads

Point Counterpoint: Why Virtualize a SQL Server?

I get asked all the time – “why virtualize SQL Server if I’m content with my physical servers today?” The normal...  Read more...
By kleegeek 2017/07/24 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,028 reads
Question of the Day

AG Sync Folders

By Steve Jones 2017/07/24 | Category: alwayson availability group
Rating: (not yet rated) |  Discuss |   Briefcase | 483 reads

I create a new Availability Group for a few SQL Server instances and use \\Sales01\Sync as the Initial Sync Folder. All of my replicas are up to date, can I...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
GilaMonster
74636 224757 SSC Guru  
2.
Jeff Moden
65755 215332 SSC Guru  
3.
Steve Jones - SSC Editor
41246 146631 SSC Guru  
4.
Lynn Pettis
29504 95024 SSC Guru  
5.
Grant Fritchey
26812 98489 SSC Guru  
Latest forum posts