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

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,913,820 DBAs, developers and SQL Server users

Previous headlines

SQL Server Management Studio Tips

Complete guide about hidden gems of SSMS 
By Konstantin Taranov 2019/03/22 (first published: 2017/08/14) | Source: SQLServerCentral.com | Category: management studio (ssms)
Rating: |  Discuss |   Briefcase | 4,707 reads

Can deleting rows make a table…bigger?

Michael J. Swart posted an interesting question: he had a large table with 7.5 billion rows and 5 indexes. When he deleted 10 million rows, he noticed that the indexes were getting larger, not smaller.  Read more...
By Additional Articles 2019/03/22 | Source: Brent Ozar Unlimited Blog | Category: indexing
Rating: (not yet rated)  Rate this |   Briefcase | 2,229 reads

SQL Server Reporting Services Lookup, LookupSet and MultiLookup Functions

I noticed the Lookup function in SQL Server Reporting Services. In this tip we look at all three SSRS lookup functions: Lookup, LookupSet and MultiLookup.  Read more...
By Additional Articles 2019/03/22 | Source: MSSQLTips.com | Category: reporting services (ssrs)
Rating: (not yet rated)  Rate this |   Briefcase | 1,646 reads

SQL in the City Summits – UK, US & Down Under

Redgate are inviting senior data professionals to attend one of the upcoming SQL in the City Summit events taking place in April, May and June. If you’re interested in learning how your business can benefit from implementing Compliant Database DevOps this event is for you. Find out who’s presenting and register for a Summit near you today. Register now  Read more...
By 2019/03/22 | Source: Redgate | Category: event
Rating: (not yet rated)  Rate this |   Briefcase | 384 reads

Dynamically Generate Replication Tasks with Biml and Custom Connectors

This article walks through using Biml with 3rd party connectors to replicate external data to SQL Server in SSIS.  Read more...
By Jerod Johnson 2019/03/21 | Source: SQLServerCentral.com | Category: replication
Rating: |  Discuss |   Briefcase | 236 reads

Resumable Online Index Create and Rebuild Operations

Index maintenance can be a real headache for database administrators as tables grow larger and maintenance windows shrink. In this article, Greg Larsen demonstrates resumable index operations available with SQL Server 2017 and 2019. This feature helps DBAs work around those small maintenance windows by allowing certain index operations to be paused and restarted again later.  Read more...
By Additional Articles 2019/03/21 | Source: SimpleTalk | Category: sql
Rating: (not yet rated)  Rate this |   Briefcase | 1,543 reads

Help us define the state of SQL Server monitoring in 2019

Last year we ran the industry’s first ever state of SQL Server monitoring survey, the results not only gave great insight for the community but helped us shape our product development to ensure we were meeting the needs that you were asking for. So what has changed in a year? Tell us for your chance to win a $250 Amazon voucher.   Read more...
By Additional Articles 2019/03/21 | Source: Redgate | Category: monitor
Rating: (not yet rated)  Rate this |   Briefcase | 1,886 reads

Stairway to AlwaysOn Level 5: Analyse and Deploy a Failover Cluster Instance

In Level 5 of this stairway, we help you understand and deploy a Failover Cluster Instance (FCI).  Read more...
By Perry Whittle 2019/03/20 (first published: 2015/02/11) | Source: SQLServerCentral.com | Category: cluster
Rating: |  Discuss |   Briefcase | 4,423 reads

Free eBook: Inside the SQL Server Query Optimizer

This free eBook from Redgate Software will take you from the fundamentals of Statistics, Cost Estimation, Index Selection, and the Execution Engine, and guide you through the inner workings of the Query Optimization process, and throws in a pragmatic look at Parameterization and Hints along the way.  Read more...
By Press Release 2019/03/20 (first published: 2012/12/11) | Source: SQLServerCentral.com | Category: books
Rating:  Rate this |   Briefcase | 54,387 reads

Transfer Data to the Cloud Using Azure Data Factory

In this tip we look at how to configure Azure Data Factory to move data from an on-premises SQL Server database to an Azure SQL Database.  Read more...
By Additional Articles 2019/03/20 | Source: MSSQLTips.com | Category: cloud computing
Rating: (not yet rated)  Rate this |   Briefcase | 1,641 reads

Question of the Day

Cleaning up tempdb

By Steve Jones 2019/03/22 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 394 reads

I am trying to remove some of the extra tempdb files that I have on an instance. I tried ALTER DATABASE tempdb REMOVE FILE tempdb32, but I got this message.

Msg... 
Latest forum posts