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

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,901,714 DBAs, developers and SQL Server users

Headlines today   May 25, 2018

SQL Server System Audit Report

Ensuring that your SQL Server is secure is the job of every Database Administrator. In this article I will provide a script to help perform easier audits of your system.  Read more...
By Rudy Panigas 2018/05/25 (first published: 2016/02/02) | Source: SQLServerCentral.com | Category: audit
Rating: |  Discuss |   Briefcase | 4,329 reads

Where Clustered Index Keys Dare

We’ve blogged a couple times about how clustered index key columns get stored in your nonclustered indexes. But where they get stored is a matter of weird SQL trivia. You see, it depends on how you define your nonclustered index.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 1,500 reads

Choosing Between Table Variables and Temporary Tables

People can, and do, argue a great deal about the relative merits of table variables and temporary tables. Sometimes, as when writing functions, you have no choice; but when you do you’ll find that both have their uses, and it’s easy to find examples where either one is quicker. In this article, Phil Factor explains the main factors involved in choosing one or the other, and demonstrates a few simple ‘rules’ to get the best performance.  Read more...
By 2018/05/25 | Source: Redgate | Category: tsql
Rating: (not yet rated)  Rate this |   Briefcase | 2,581 reads
Previous headlines

Using FORMAT() for Dates

Learn how the FORMAT() function works for dates. 
By Steve Jones 2018/05/24 | Source: SQLServerCentral.com | Category: format()
Rating: |  Discuss |   Briefcase | 1,394 reads

SQL in the City Streamed – Compliant DevOps: June 20 2018

Join Redgate’s livestream on June 20 and learn from Microsoft Data Platform MVPs, Steve Jones, Grant Fritchey, and Kathi Kellenberger. The schedule will include sessions to help you learn how to demonstrate compliance with regulations such as the GDPR, HIPAA and SOX. Find out more and register for free  Read more...
By 2018/05/24 | Source: Redgate | Category: compliance
Rating: (not yet rated)  Rate this |   Briefcase | 1,325 reads

Build and Automate a SQL Server Status Report on Server Restart or Scheduled

Do you know when a SQL Server instance restarts? When you manage many SQL Server instances you may not know when one restarts, so having an automated report emailed to you could be helpful to get an idea what's going on for that instance.  Read more...
By Additional Articles 2018/05/24 | Source: MSSQLTips.com | Category: database mail
Rating: (not yet rated)  Rate this |   Briefcase | 1,749 reads

How DevOps can automate the repayment of technical debt

Looking to DevOps automation to try to create the breathing room needed to break out of the vicious cycle of technical debt.  Read more...
By 2018/05/24 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 1,429 reads

Stairway to Columnstore Indexes Level 6: Updating and Deleting Data in a Columnstore Index

This level looks in detail at what happens when we update or delete data from a clustered columnstore index, the impact it has on concurrent data access, and how without careful maintenance the efficiency of columnstore indexes can degrade over time.  Read more...
By Hugo Kornelis 2018/05/23 (first published: 2016/01/20) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,222 reads

Free eBook: Performance Tuning with SQL Server Dynamic Management Views

Dynamic Management Views (DMVs) are a significant and valuable addition to the DBA's troubleshooting armory, laying bare previously unavailable information regarding the under-the-covers activity of your database sessions and transactions.  Read more...
By Additional Articles 2018/05/23 (first published: 2013/08/21) | Source: Redgate | Category: performance tuning
Rating:  Rate this |   Briefcase | 92,421 reads

SQL Server Graph Databases – Part 5: Importing Relational Data into a Graph Database

In the final article of this series, Robert Sheldon shows how to move from a relational structure to a graph structure using the Graph Database feature.  Read more...
By Additional Articles 2018/05/23 | Source: SimpleTalk | Category: sql server
Rating: (not yet rated)  Rate this |   Briefcase | 1,730 reads

From the SQLServerCentral Blogs

When Good Query Plans Go Bad

Today's story starts again with a page escalation: -- We are seeing very high CPU usage on DistServer01.  Could you please take...  Read more...
By Andy Galbraith 2018/05/25 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,597 reads

dbachecks – Improved Descriptions

With the latest release of dbachecks we have added a new check for testing that foreign keys and constraints are...  Read more...
By Rob Sewell 2018/05/25 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,541 reads
Question of the Day

Automatic Automatic Tuning

By Steve Jones 2018/05/25 | Category: azure sql database
Rating: (not yet rated) |  Discuss |   Briefcase | 312 reads

I have an Azure SQL Database server where I have a single database. I have enabled Automatic tuning on this database and it has worked well. I want to ensure...  Read more...
Latest forum posts