By SQLRx Admin | SQL Administration , SQL Server , Tip of the Month
SQL Server Administration: Every so often someone will call with a terrible problem because a drive was lost or someone mistakenly deleted transaction log files. When this happens, the affected databases are not useable and are usually marked as SUSPECT or IN RECOVERY in Management Studio. Usually the best option is to restore the database […]
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 readingBy 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 readingBy SQLRx Admin | Miscellaneous , SQL Server , Tip of the Month
SQL Server Development: The COUNT_BIG function is used much like the COUNT function to return the number of items in a group. COUNT_BIG returns a bigint data type and has a maximum value returned of 9,223,372,036,854,775,807. COUNT returns an int data type and has a maximum value returned of 2,147,483,647. COUNT_BIG is useful for rowcounts […]
Continue readingBy SQLRx Admin | SQL Administration , SQL Server , Tip of the Month
SQL Server Administration: Restore a database from one file or multiple files. Use these commands to restore your databases. Practicing restoring databases proves that the backup files are usable and will polish up your skills so that you are ready to restore in the event of a crisis. If you have to restore database files […]
Continue readingBy SQLRx Admin | SQL Administration , SQL Maintenance , SQL Server , Tip of the Month
SQL Server Administration: Backup database to one file or multiple files. Use these commands to back your databases up without using a maintenance plan. Backing up to multiple files is good to use for large databases and will break up a single large backup file to several smaller files. Good to use when large backups […]
Continue readingBy SQLRx Admin | SQL Server , Tip of the Month
A new function available in SQL Server 2012 is IIF. IIF is very similar to the CASE expression and is in essence a shorthand way to write a CASE function. The IIF function returns one of two values depending on whether the first expression evaluates to TRUE or FALSE. The IIF function can be nested […]
Continue readingBy SQLRx Admin | SQL Administration , SQL Server , Tip of the Month
(SQL 2008 R2 and SQL 2012) Use the new dynamic management view sys.dm_server_services to see information about SQL Server services such as when service last started, running status, service account, etc… For more information, check out Books Online or http://msdn.microsoft.com/en-us/library/hh204542.aspx
Continue readingBy 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