By Lori Brown | Performance Tuning , SQL Administration , SQL Server
I occasionally come across some pretty good sized databases that are set up with a single data file. We recently have been working with a client to break up their single data file into multiple data files so that we can spread them over several different LUNs and so that they can take advantage of […]
Continue readingBy SQLRx Admin | Lunch And Learn , SQL 2017 , SQL Server
Come see Bob Ward from Microsoft speak about “Fast and Furious: SQL 2017” at the DFW BI & Analytics Community Meeting on 12/6, 11:30-1:00 at Noah’s in Irving. You can register on the “Event” section of the ISI website at www.isi85.com . The DFW Business Intelligence and Analytics Community welcomes Bob Ward of the Microsoft […]
Continue readingBy SQLRx Admin | Helpful Scripts , Miscellaneous , SQL Server , Tip of the Month
Find out if any of tables in your database have special features enabled using the queries below. These features need to be understood and carefully managed. — CDC Enabled Tables select distinct t.name AS CDCTables from sys.tables t where t.is_tracked_by_cdc = 1 — File Tables — SQL 2012 + select distinct t.name AS FileTables from […]
Continue readingBy SQLRx Admin | Miscellaneous , SQL 2017 , SQL Server
Since we at SQLRX have been super busy this week and still need to do something for a blog post, I thought that doing a link round up of new dynamic management views that are going to be available in SQL 2017 would be a quick and good idea. I am really interested in sys.dm_db_log_info […]
Continue readingBy SQLRx Admin | Advice , Installation , Miscellaneous , SQL Server , Upgrade
In case you live under a rock or were at the dentist, Microsoft announced that SQL Server 2016 has been made generally available today June 1, 2016. See: https://blogs.technet.microsoft.com/dataplatforminsider/2016/06/01/sql-server-2016-is-generally-available-today/ Pricing is as follows: A handy feature comparison of previous versions of SQL can be located here: https://www.microsoft.com/en-us/server-cloud/products/sql-server/comparison.aspx SQL 2016 feature comparison between editions can be […]
Continue readingBy 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 | 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 | 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 | SQL Server
SQL Server Administration: SQL 2008 – SQL 2012) Use the new dynamic management view sys.dm_os_sys_memory to view memory information from the operating system. If the System Memory State = “Available physical memory is high”, this is good and indicates that the system is not experiencing external memory pressure. For more information check out http://technet.microsoft.com/en-us/library/bb510493.aspx **HT […]
Continue reading