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

Previous headlines

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,389 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 | 2,030 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 | 3,210 reads

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,429 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,650 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 | 2,069 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,710 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,228 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,581 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,962 reads

Question of the Day

Automatic Automatic Tuning

By Steve Jones 2018/05/25 | Category: azure sql database
Rating: (not yet rated) |  Discuss |   Briefcase | 374 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