SQL Administration Archives - Page 4 of 16

Feb 08

Notification for Restored Database

By Ginger Daniel | Backup and Restore , Database Mail , SQL Administration , SQL Server

According to best practices for a SQL environment, you should never place your test or development databases on a production server. However sometimes best practices are ignored, sometimes the DBA’s advice is disregarded (ahem…), or sometimes an organization simply does not have the financial resources to spin up separate servers for testing or development. Whatever […]

Feb 01

Large MSDB Database From sysmaintplan_logdetail Table

By Lori Brown | Advice , Beginner , SQL Administration , SQL Maintenance , SQL Server

I am recycling this blog post from 2015….”Why?”, you might ask…..Well, I am still running into instances with this exact issue. Soooo, here we go….again. Enjoy. 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 […]

Jan 25

List All Extended Properties For All Objects In A Database

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

I was recently looking at a way to easily identify if any objects in a database were In-Memory. Since many times I am tasked with taking on systems that I have never seen before, I have learned that it is important to have ways of checking to see if some of the more specialized features […]

Jan 11

Inconsistent Tempdb Growth

By Ginger Daniel | SQL Administration , SQL Server , Trace Flags

Tempdb database is a system database that is shared across all databases and all connections in SQL Server. As a general rule, I configure all my client’s servers to have multiple tempdb files with consistent sizes and consistent auto growth set according to best practices. The number of tempdb files created equals the number of […]

Dec 21

AlwaysOn – Connection Handshake Failure

By Ginger Daniel | SQL Administration , SQL Server

While doing some work on a test environment recently I realized the AlwaysOn Group was failing. (On a production system I would have had several Alerts set to notify me of any issues). The dashboard on my test instance showed that the secondary replica was not synchronizing and from clicking on the blue warning links […]

Dec 14

Rx for Demystifying Index Tuning Decisions – Part 8

By Jeffry Schwartz | Missing Indexes , Performance Tuning , Query Tuning , SQL Administration , SQL Development , SQL Server

Review Due to the holiday week, this part will be shorter than usual. In Parts 1 through 7 of this blog series the author discussed various aspects of SQL Server indices such as: Types of indices and their variations, e.g., clustered, nonclustered, filtered, and covering Physical versus logical index access methods, e.g., seeks, scans, key/RID lookups, […]

Dec 07

Rx for Demystifying Index Tuning Decisions – Part 7

By Jeffry Schwartz | Missing Indexes , Performance Tuning , Query Tuning , SQL Administration , SQL Development , SQL Server

Review In Parts 1 through 6 of this blog series the author discussed various aspects of SQL Server indices such as: Types of indices and their variations, e.g., clustered, nonclustered, filtered, and covering Physical versus logical index access methods, e.g., seeks, scans, key/RID lookups, singleton lookups, and range scans Why index tuning should begin with […]

Nov 16

Rx for Demystifying Index Tuning Decisions – Part 4

By Jeffry Schwartz | Missing Indexes , Performance Tuning , Query Tuning , SQL Administration , SQL Server

Review In Parts 1 through 3 of this blog series the author discussed various aspects of SQL Server indices such as: Types of indices and their variations, e.g., clustered, nonclustered, filtered, and covering Physical versus logical index access methods, e.g., seeks, scans, key/RID lookups, singleton lookups, and range scans Why index tuning should begin with […]

Oct 26

Rx for Demystifying Index Tuning Decisions – Part 1

By Jeffry Schwartz | Expert , Missing Indexes , Performance Tuning , Query Tuning , SQL Administration , SQL Development , SQL Server

Overview Indices are one of the most troubling and mysterious areas for DBAs and developers. Most understand that adding a badly needed index can yield dramatic query performance improvements, but how does one know what is needed? Many believe more indices are better, regardless of the number. Most fear deleting ANY existing indices, even when […]

« Previous 1 2 3 4 5 6 … 16 Next »

Category Archives for "SQL Administration"