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

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,899,998 DBAs, developers and SQL Server users

Rss
Headlines today   April 23, 2018

Cancelling DBCC SHRINKFILE with EMPTYFILE

A fun experiment using DBCC SHRINKFILE to rebalance data.  Read more...
By Steve Jones 2018/04/23 | Source: SQLServerCentral.com | Category: dbcc shrinkfile
Rating: |  Discuss |   Briefcase | 519 reads

How to Programmatically Identify When Your SQL Server Was Last Started

Greg Larsen shows you a quick trick to programmatically script a way to identify when SQL Server was last started.  Read more...
By Additional Articles 2018/04/23 | Source: Database Journal | Category: administration
Rating: (not yet rated)  Rate this |   Briefcase | 1,790 reads

Spring into the Latest Features at the Luxemborg User Group

The next meeting of the Luxemborg SQL Server User Group has some great sessions planned.  Read more...
By Additional Articles 2018/04/23 | Source: SQLServerCentral.com | Category: user groups
Rating: |  Discuss |   Briefcase | 51 reads

Custom Metrics for Detecting Problems with Ad-hoc Queries

A common SQL Server crime is the unnecessary overuse of ad-hoc queries by applications. In this article, Phil Factor shares some custom queries for monitoring problems that can be caused by this.  Read more...
By 2018/04/23 | Source: SimpleTalk | Category: monitoring
Rating: (not yet rated)  Rate this |   Briefcase | 1,244 reads
Previous headlines

Making Deployments Simpler with Re-runnable Scripts

Make sure your SQL Server database release scripts to make life easier.  Read more...
By Ed Elliott 2018/04/20 (first published: 2015/11/17) | Source: SQLServerCentral.com | Category: releases
Rating: |  Discuss |   Briefcase | 5,270 reads

How to Show the Execution Plan of a Running Query

By looking at a query execution plan, you can determine which steps are used to resolve the query. But what if you just want to find out what the query plans are for only the queries that are currently running?  Read more...
By Additional Articles 2018/04/20 | Source: Database Journal | Category: execution plans
Rating: (not yet rated)  Rate this |   Briefcase | 2,966 reads

Do you check your backups?

Backups. Are you confident you can restore? Do you have a process that ensures you can recover your systems? Learn how one system works in the cloud.  Read more...
By Michael Higgins 2018/04/19 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 738 reads

SQL Server Graph Databases – Part 2: Querying Data in a Graph Database

Along with Graph Databases, Microsoft has introduced the new MATCH function for querying them. Robert Sheldon explains how to use the new function.  Read more...
By Additional Articles 2018/04/19 | Source: SimpleTalk | Category: sql server graph database
Rating: (not yet rated)  Rate this |   Briefcase | 2,315 reads

5 challenges to scaling DevOps at enterprise level

Many large enterprises launch small DevOps initiatives within certain departments, but subsequently find that scaling DevOps across the organization faces a number of challenges that must be overcome.  Read more...
By 2018/04/19 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 1,795 reads

Stairway to Columnstore Indexes Level 5: Adding New Data To Columnstore Indexes

Earlier levels have shown how Columnstore Indexes work effectively with static data. In most tables however, data is hardly ever static. We are constantly inserting new rows, and updating or deleting existing rows. If you think about what this means for a columnstore index, you will realize that this comes with some unique challenges.  Read more...
By Hugo Kornelis 2018/04/18 (first published: 2015/11/04) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,598 reads
 

From the SQLServerCentral Blogs

Webinar: 6 Principles of the GDPR and SQL Provision

On April 24, I’ll be hosting a webinar that talks about the GDPR and how you can help ensure compliance...  Read more...
By Steve Jones 2018/04/23 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,699 reads

I’ve gotten a transaction log full error but when I look it’s not full??

Every now and again I’ll get an error telling me a transaction log is full. This can be for any...  Read more...
By Kenneth Fisher 2018/04/23 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,541 reads
Question of the Day

Do I need an event?

By Steve Jones 2018/04/23 | Category: extended events (xe)
Rating: (not yet rated) |  Discuss |   Briefcase | 331 reads

I decide I want to setup an Extended Events session. I create a session with one event and one target with this code:


CREATE EVENT SESSION [BareBones] ON SERVER
ADD EVENT...  Read more...
Latest forum posts