Sign up for daily SQL Server insight.
Sign up
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Authors
About us
Contact us
Newsletters
Write for us
Keep up to date - daily newsletter:
Sign up
Welcome to SQLServerCentral.com
A Microsoft SQL Server community of 1,899,998 DBAs, developers and SQL Server users
Show more
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,203 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,740 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
|
714 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,172 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,708 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,581 reads
Free eBook: SQL Server Execution Plans, Second Edition
Every day, out in the various online forums devoted to SQL Server, and on Twitter, the same types of questions come up repeatedly: Why is this query running slowly? Why is SQL Server ignoring my index? Why does this query run quickly sometimes and slowly at others? My response is the same in each case: have you looked at the execution plan?
Read more...
By
Press Release
2018/04/18 (first published: 2013/07/30)
|
Source:
Redgate
|
Category:
execution plans
Rating:
Rate this
|
Briefcase
|
103,331 reads
Why sp_prepare Isn’t as “Good” as sp_executesql for Performance
Erik Darling shows how execution plan estimates suffer.
Read more...
By
Additional Articles
2018/04/18
|
Source:
Brent Ozar Unlimited Blog
|
Category:
execution plans
Rating:
(not yet rated)
Rate this
|
Briefcase
|
2,374 reads
Fixing system database corruption with setup.exe
Corruption of the system databases is a serious matter. Setup.exe is a brute force method of replacing them.
Read more...
By
Kenneth Fisher
2018/04/17
|
Source:
SQLServerCentral.com
|
Category:
database corruption
Rating:
|
Discuss
|
Briefcase
|
634 reads
Recover Data in SQL Server AWS RDS with the Help of BACPAC
With Amazon RDS, it’s easy to have a SQL Server running in minutes. There are some limitations, though. Seth Delconte explains a workaround to overcome one of the limitations: the inability to restore a second copy of a database to recover missing data.
Read more...
By
Additional Articles
2018/04/17
|
Source:
SimpleTalk
|
Category:
aws
Rating:
(not yet rated)
Rate this
|
Briefcase
|
1,951 reads
Browse all
Question of the Day
Manage the suspect_pages Table on SQL Sever 2017
By
Junior Galvão - MVP
2018/04/20
|
Category:
suspect pages
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
432 reads
The suspect_pages table is used for maintaining information about suspect pages, and is relevant in helping to decide whether a restore is necessary. The suspect_pages table resides which system database?
Read more...
Show more
Latest forum posts
Unable to get format file to work
By
Jeff Moden
|
Apr 22, 2018
Posted to
SQL Server Newbies
Select All Records Where Date Falls Within Next Week
By
Jeff Moden
|
Apr 22, 2018
Posted to
SQL Server 2017 - Development
Transaction Replication & AlwaysOn
By
studySQL
|
Apr 22, 2018
Posted to
SQL 2012 - General
Server role and user mapping lost when apply Dacpac
By
binutb
|
Apr 22, 2018
Posted to
SQL Server 2017 - Administration
How to summing up value based on a different value range
By
george-178499
|
Apr 22, 2018
Posted to
SQL Server Newbies
New SQL Server articles, scripts and tips every weekday. Get the SSC Newsletter:
Sign up
Copyright © 2002-2018 Redgate. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.