Tag Archives for " SQL Administration "

Sep 14

Find Tables That Have Special Features Enabled

By 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 reading
Jun 01

SQL Server 2016 RTM Available!!

By 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 reading
Feb 03

New Dynamic Management View

By 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