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

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,910,542 DBAs, developers and SQL Server users

Headlines today   December 19, 2018

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/12/19 (first published: 2015/11/04) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 4,087 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/12/19 (first published: 2013/08/21) | Source: Redgate | Category: performance tuning
Rating:  Rate this |   Briefcase | 103,682 reads

Getting Sneaky With Forced Parameterization

In which Erik works around the documented limitations with CROSS APPLY.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 1,032 reads
Previous headlines

Visualise SQL Server IO Stats

Visualise and compare the output of set statistics io on with Power BI to assist with performance tuning.  Read more...
By Philip Robinson 2018/12/18 | Source: SQLServerCentral.com | Category: power bi
Rating: |  Discuss |   Briefcase | 838 reads

SQL Server AlwaysOn Availability Groups Monitoring and Alerting - Part 2

In this tip we look at some additional scripts that you can use to monitor your SQL Server AlwaysOn Availability Groups.  Read more...
By Additional Articles 2018/12/18 | Source: MSSQLTips.com | Category: always on
Rating: (not yet rated)  Rate this |   Briefcase | 1,717 reads

New Case Study: Ensuring HIPAA compliance with SQL Provision

New case study from Redgate. Since adopting SQL Provision, KEPRO, a leading US healthcare organization, have been able to achieve HIPAA compliance, save 15-20 hours a week in provisioning processes, and reclaim terabytes of disk space.   Read more...
By 2018/12/18 | Source: Redgate
Rating: (not yet rated)  Rate this |   Briefcase | 1,485 reads

TOP vs Max/Min: Is there a difference?

Is there a difference between using TOP and MAX/MIN to return and end value to a table?  Read more...
By Mike Byrd 2018/12/17 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,317 reads

Power BI Introduction: Visualizing SQL Server Audit Data — Part 9

SQL Server Audit is a powerful feature that can help you comply with regulations such as HIPAA and SOX, but it’s not easy to view the data collected. In this article, Robert Sheldon demonstrates how Power BI can be used to view and filter SQL Server Audit results.  Read more...
By Additional Articles 2018/12/17 | Source: SimpleTalk | Category: power bi
Rating: (not yet rated)  Rate this |   Briefcase | 2,152 reads

Database DevOps without compromising the data

Database DevOps has arrived and is here to stay. However this has also brought friction with the increasing importance of data privacy and protection. Redgate’s Compliant Database DevOps whitepaper outlines how you can introduce DevOps processes and their benefits while also keeping your information and data safe.  Read more...
By 2018/12/17 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 1,464 reads

Streamline Log Shipping Failovers: DR Made Just For You…

A look at a SQL script solution that can help you easily fail over and back from log shipping scenarios.  Read more...
By Micah Nikkel 2018/12/14 (first published: 2015/09/08) | Source: SQLServerCentral.com | Category: log shipping
Rating: |  Discuss |   Briefcase | 2,887 reads

From the SQLServerCentral Blogs

SQL Server Availability Group FailoverDetection Utility PowerShell Function Improvements – Named Instances, Archiving Data, Speed

In my last post I wrote about a new function for gathering the data and running the FailoverDetection utility by...  Read more...
By Rob Sewell 2018/12/19 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,359 reads

Turbo Charged Staging\Caching Tables With In Memory OLTP

Since SQL 2012 some really awesome new technologies have been introduced into the engine that are massively underused. Everyone is...  Read more...
By Gavin Draper 2018/12/19 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,577 reads
Question of the Day

Data Frame Statistics

By Steve Jones 2018/12/19 | Category: r language
Rating: (not yet rated) |  Discuss |   Briefcase | 306 reads

I have a data frame of the all time home run hitting leaders in baseball. I want to get some quick statistical looks at the data frame (HR.hitters). What function...  Read more...
Latest forum posts