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

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,889,782 DBAs, developers and SQL Server users

Rss
Headlines today   August 24, 2017

Curious Case of SUM Function

How a simple SUM statement could change an output.  Read more...
By Utsav Verma 2017/08/24 | Source: SQLServerCentral.com | Category: sum()
Rating: |  Discuss |   Briefcase | 522 reads

Why Missing Index Recommendations Aren’t Perfect

Before you apply those little missing indexes, read this.  Read more...
By 2017/08/24 | Source: Brent Ozar Unlimited Blog | Category: missing indexes
Rating: (not yet rated)  Rate this |   Briefcase | 916 reads

Register for the Redgate Hub Launch Livestream on September 6

To celebrate the launch of the new Redgate Hub, Data Platform MVP Steve Jones is hosting an educational livestream event alongside the team at Redgate HQ. They’ll introduce you to everything the Redgate Hub has to offer by highlighting some recent technical articles and how-to guides with in-depth live presentations. Register now.  Read more...
By 2017/08/24 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 401 reads
Previous headlines

Stairway to SQL Server Extended Events Level 1: From SQL Trace to Extended Events

Over the course of this stairway series, we're going to explore in detail the use of Extended Events as a diagnostic data collection tool, to track down causes of poor performance in SQL Server. This first level will start from a point known and familiar to many DBAs, namely the use of SQL Trace to track down and investigate long-running queries.  Read more...
By Erin Stellato 2017/08/23 (first published: 2015/12/23) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 6,070 reads

Free eBook: Defensive Database Programming

Resilient T-SQL code is code that is designed to last, and to be safely reused by others. The goal of defensive database programming, the goal of this book, is to help you to produce resilient T-SQL code that robustly and gracefully handles cases of unintended use, and is resilient to common changes to the database environment.  Read more...
By Press Release 2017/08/23 (first published: 2013/08/28) | Source: Redgate | Category: defensive programming
Rating: (not yet rated)  Rate this |   Briefcase | 84,983 reads

Installing SQL Server Agent on SUSE Linux

Manvendra Singh explains how to install SQL Server Agent on SUSE Linux server, so that you can create SQL Server Jobs to schedule repetitive work.  Read more...
By Additional Articles 2017/08/23 | Source: MSSQLTips.com | Category: sql server agent
Rating: (not yet rated)  Rate this |   Briefcase | 1,314 reads

Load Extended Events via Powershell

Learn how you can load Extended Events with PowerShell, nice and fast.  Read more...
By Aakash Patel 2017/08/22 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 534 reads

How to Find Out Which Database Object Got Deleted

Greg Larsen shows you how to use the Transaction ID value to identify the object_id for a deleted table.  Read more...
By Additional Articles 2017/08/22 | Source: Database Journal | Category: sql
Rating: (not yet rated)  Rate this |   Briefcase | 1,930 reads

Azure DWH part 14: PolyBase to access to Non relational data

In this article, we will learn how to work with PolyBase using Azure SQL DWH.   Read more...
By Daniel Calbimonte 2017/08/21 | Source: SQLServerCentral.com | Category: polybase
Rating: |  Discuss |   Briefcase | 305 reads

Is It Time To Stop Using IsNumeric()?

The old system function IsNumeric() often causes exasperation to a developer who is unfamiliar with the quirks of Transact SQL. It seems to think a comma or a number with a 'D' in the midde of it is a number. Phil Factor explains that though IsNumeric has its bugs, it real vice is that it doesn't tell you which of the numeric datatypes the string parameter can be coerced into, and because it doesn't check for overflow. Phil comes to the rescue with a couple of useful alternatives, one of which works whatever version of SQL Server you have, and which tell you what datatype the string can be converted to.  Read more...
By Additional Articles 2017/08/21 | Source: SimpleTalk | Category: isnumeric()
Rating: (not yet rated)  Rate this |   Briefcase | 3,156 reads
 

Ask SQL Server Central

From the SQLServerCentral Blogs

Bad Parameter Sniffing Decision Flow Chart

Lots of people are confused by how to deal with bad parameter sniffing when it occurs. In an effort to...  Read more...
By Grant Fritchey 2017/08/24 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 536 reads

Randomness in Security Configuration

We were deploying a new web service. Because of the nature of the service, we wanted it to listen on...  Read more...
By Brian Kelley 2017/08/24 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 473 reads
Question of the Day

Executing commands in SQLCMD

By Steve Jones 2017/08/24 | Category: sqlcmd
Rating: (not yet rated) |  Discuss |   Briefcase | 225 reads

I connect to my instance like this:


sqlcmd -S .\SQL2016
I then enter "SELECT @@VERSION" at the prompt. I see this:



How do I execute the statement?

  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
GilaMonster
75536 301877 SSC Guru  
2.
Jeff Moden
63590 280166 SSC Guru  
3.
Steve Jones - SSC Editor
39458 186855 SSC Guru  
4.
Lynn Pettis
28729 124312 SSC Guru  
5.
Lowell
27225 99681 SSC Guru  
Latest forum posts