By SQLRx Admin | Advice , Miscellaneous , Offer , SQL Server , SQLRX
For those of you who visit our humble blog from time to time and have never actually checked out our website (www.sqlrx.com) to get acquainted with what we do, please allow me to check that box for you. SQLRX is part of a Dallas, Texas based consulting company called Integrated Services Inc (ISI). The SQLRX […]
Continue readingBy SQLRx Admin | Advice , Beginner , Miscellaneous , SQL Administration , SQL Server , Tip of the Month
If you have Full Text catalogs set up in your databases you may notice that inside your log folder there will be lots of files named SQLFTxxxxxxxxxxxx.LOG. These are known as crawl logs which are designed to log information on the full text indexing. These logs can really pile up and there is no automated […]
Continue readingBy SQLRx Admin | Intermediate , Performance Tuning , SQL Server , Tip of the Month
SQL Server Performance Tuning: New function in SQL 2016: sys.dm_exec_function_stats Returns performance statistics for cached functions. Returns information about scalar functions, including in-memory functions and CLR scalar functions but not about table valued functions. The view returns one row for each cached function plan, and the lifetime of the row is as long as the […]
Continue readingBy SQLRx Admin | Intermediate , SQL Server , Tip of the Month
January 2016 Tip of the Month: Using sys.dm_server_memory_dumps to find SQL memory dumps. When SQL experiences a serious issue it will often dump the contents of its memory to disk. This is known as a memory dump and it does generate files that are usually located in the Logs folder. I often find that many […]
Continue readingBy SQLRx Admin | Intermediate , SQL Administration , SQL Server , Tip of the Month
The SQL dedicated administrator connection(DAC) has been around since SQL 2005 and is a diagnostic connection that is designed to allow an administrator to troubleshoot SQL Server when the instance is having problems. Only members of the sysadmin role can connect using the DAC. You can connect using the DAC both through SQLCMD (SQLCMD –A […]
Continue readingBy SQLRx Admin | Beginner , SQL Administration , SQL Server , Tip of the Month
Available in SQL Server 2014 Enterprise Edition and Standard Edition Backup encryption has been introduced in SQL 2014 to allow encrypting backups without being forced to encrypt the entire database. Several encryption algorithms are supported, including Advanced Encryption Standard (AES) 128, AES 192, AES 256, and Triple DES. You can also compress the encrypted backup. […]
Continue readingBy SQLRx Admin | SQL Administration , SQLRX , Tip of the Month
Available in SQL Server 2014 Enterprise Edition The Resource Governor can now restrict the number of I/O’s sent to the disk subsystem. In the past, only CPU and Memory could be throttled, but now DBAs can also throttle I/O. This gives DBAs the ability to further control those users who insist on running reports or […]
Continue readingBy SQLRx Admin | SQL Server , Tip of the Month
Available in all Editions of SQL Server 2014 CONNECT ANY DATABASE : Using this permission you can allow a login to connect to any database (existing or future) without having to configure connect privileges on every database. GRANT CONNECT ANY DATABASE TO sqlrx GO IMPERSONATE ANY LOGIN : This allows a login to impersonate […]
Continue readingBy SQLRx Admin | Performance Tuning , SQL Administration , SQL Server , Tip of the Month
SQL Server Performance Tuning: Create indexes with included columns. I recently did some tuning work on a query that has computed columns in the SELECT. While the index that was being used by the query did contain columns used in the query’s WHERE clause performance was still not as fast as it could be. I […]
Continue reading