The Daily Dose

The Prescription for SQL Server

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
Jan 23

What’s new in SQL Server 2014?

By SQLRx Admin | SQL Server

This article excerpt, by Johan Åhlén, originally appeared here: http://bit.ly/1dARmgI Just when we thought that nothing could get any better than SQL Server 2012, Microsoft announced news around SQL Server 2014. There’s even a SQL Server 2014 website where you can get a free trial. So, what’s new and cool? Hekaton In-memory Database Capabilities Hekaton makes it […]

Continue reading
Aug 04

Get a List of CLR’s Registered to a Database

By SQLRx Admin | SQL Administration , SQL Server , Tip of the Month

Get a list of CLR’s registered to a database.  This is helpful when migrating or troubleshooting.  For more information on CLR’s check out Books Online or http://msdn.microsoft.com/en-us/library/ms131089(SQL.100).aspx   SELECT o.name AS ObjectName, a.name AS Assembly, o.type_desc AS ObjectType FROM   sys.assembly_modules am JOIN   sys.objects o ON am.object_id = o.object_id JOIN   sys.assemblies a ON a.assembly_id = am.assembly_id […]

Continue reading
>