Lori Brown, Author at SQLRx

About the Author

Lori is an avid runner, cross fitter and SQL enthusiast. She has been working for SQLRX for 15 years and has been working with SQL in general for 25 years. Yup...she is an old hand at this stuff.

Sep 03

Tip of the Month: WAIT_AT_LOW_PRIORITY option for Index Rebuilds

By Lori Brown | SQL Administration , SQL Maintenance , SQL Server , Tip of the Month

— By Lori Brown @SQLSupahStah Available in SQL Server 2014 Enterprise Edition since can only be done using ONLINE rebuilds. Index rebuilds have been enhanced with the WAIT_AT_LOW_PRIORITY option. It is used to set the duration in minutes to wait as well as behavior when blocking happens. When setting WAIT_AT_LOW_PRIORITY you also must set MAX_DURATION […]

Aug 07

Find Permission Changes In The Default Trace

By Lori Brown | Helpful Scripts , SQL Administration , SQL Server , SQLRX

— By Lori Brown @SQLSupahStah I recently had someone contact me who needed to figure out when a user’s database permissions were changed. Apparently, a domain account that had been working for months doing things in a specific database suddenly could not do its normal work. On checking, we found that all of the user’s […]

Jul 23

Do You Know When To Ask For Help?

By Lori Brown | Advice , Budgeting , Offer , SQL Server , SQLRX

— By Lori Brown @SQLSupahStah This is a bit off from our normal technical blog posts but, hey, if you can’t go out on a limb on your own blog, what good is it? After doing cleanup on systems over the years, I started thinking about why some servers seem to be so poorly configured. […]

Jul 09

SQL Server Column Level Encryption and Query Performance

By Lori Brown | Helpful Scripts , SQL Administration , SQL Development , SQL Server

— by Lori Brown @SQLSupahStah In my last blog post I showed how to implement TDE encryption on a database and the performance impact of doing so. https://sqlrx.wordpress.com/2015/06/25/sql-server-tde-encryption-and-query-performance/ Today’s post will show how to implement encryption at the column level and the performance impact as well as a way to help make queries using encrypted […]

Jul 02

Large MSDB Database From sysmaintplan_logdetail Table

By Lori Brown | Miscellaneous , SQL Administration , SQL Maintenance , SQL Server

— By Lori Brown @SQLSupahStah I recently received a panicked call from a client who had a SQL instance go down because the server’s C drive was full. As the guy looked he found that the msdb database file was 31 GB and was consuming all of the free space on the OS drive causing […]

Jun 25

SQL Server TDE Encryption and Query Performance

By Lori Brown | Miscellaneous , SQL Administration , SQL Server

— By Lori Brown @SQLSupahStah I recently was tasked with finding out how implementing TDE on a database along with encrypting several columns in a heavily used table was going to affect application code and query performance. Here are the steps I took to implement TDE encryption along with some query run statistics. I also […]

Jun 11

Enhanced ColumnStore Indexes in SQL 2014

By Lori Brown | Miscellaneous , SQL Administration , SQL Server

Available in SQL 2012 & 2014 Enterprise Edition ColumnStore Indexes were introduced in SQL 2012 and are designed to improve performance in data warehouses. These indexes are good for batch processing and read only queries that use large data sets. Tables that are bulk loaded are good candidates. ColumnStore Indexes stores data in a columnar […]

Jun 04

SQL 2014 Statistics Enhancement – Incremental Statistics

By Lori Brown | SQL Server

Available in SQL 2014 Enterprise Edition since only used for partitioned indexes Statistics are VERY important to the SQL database engine and are what helps the optimizer make good execution plans. So, maintaining statistics is a super important part of any DBA’s job. In the past updating statistics on large tables can be very resource […]

Jun 03

Changes to System Views in SQL 2014

By Lori Brown | Helpful Scripts , Miscellaneous , Performance Tuning , SQL Server , Tip of the Month

There are two new system views and two system views that have new columns added in SQL 2014. Most notable is sys.databases since this is widely used. sys.xml_indexes – Has 3 new columns: xml_index_type, xml_index_type_description, and path_id. https://msdn.microsoft.com/en-us/library/ms176003.aspx sys.databases – Has 3 new columns: is_auto_create_stats_incremental_on, is_query_store_on, and resource_pool_id. https://msdn.microsoft.com/en-us/library/ms178534.aspx sys.column_store_row_groups – New view. Provides clustered […]

« Previous 1 … 7 8 9 10 Next »

All Posts by Lori Brown

About the Author