By SQLRx Admin | Helpful Scripts , SQL Server , Tip of the Month
Your SQL database uses statistics to choose the most efficient plan for retrieving or updating data, so you want them accurate and up-to-date. Otherwise, it can cause the SQL Server engine to take the wrong path, and taking the wrong path means slower performance. Check out the code below to see when your stats were last […]
Continue readingBy SQLRx Admin | Helpful Scripts , SQL Administration , SQL Maintenance , SQL Server , Tip of the Month
Every DBA has encountered a database that has a mystery statement that will unexpectedly cause either the transaction log or a table to grow out of control and fill the drive. Here is a way to find out who is running what statement that is causing the problem. Find out what statements are causing database […]
Continue readingBy SQLRx Admin | Helpful Scripts , SQL Administration , SQL Server , Tip of the Month
Database backups are a critical part of SQL Server disaster planning. It’s also critical to know
that your backups are viable.
By SQLRx Admin | Helpful Scripts , SQL Administration , Tip of the Month
DBA’s need to know when it is safe to stop services or to do other work. It is preferable to do such things when no jobs are running to prevent job failures and data integrity issues. Check out the query below to help. SQL Server Administration: Find the next time that any enabled job will run. Run the […]
Continue readingBy SQLRx Admin | Helpful Scripts , SQL Administration , SQL Server , Tip of the Month
If you are a DBA who needs to know how much space tables take in your databases to monitor growth trends and plan for maintenance, we have the query for you.
Continue readingBy SQLRx Admin | Helpful Scripts , Miscellaneous , SQL Server , Tip of the Month
SQL Server T-SQL: Working with time values in queries has always presented challenges. Especially when you need only part of a datetime value. Either truncating or rounding time has usually been done by converting a datetime value to a string and then using the parts that are needed. The functions below can be used to […]
Continue readingBy SQLRx Admin | Helpful Scripts , SQL Administration , SQL Server , Tip of the Month
SQL Server Administration: Monitor disk space free with a simple routine. Make sure that you have room on your drives to hold the work being performed. If you run out of disk space, your SQL Server will stop accepting requests. In the code below, the @Threshold variable is designed to hold a value in MB […]
Continue readingBy SQLRx Admin | Helpful Scripts , SQL Administration , SQL Server , Tip of the Month
SQL Server Administration: List all principal and object permissions with the following query. Use this to periodically check that permissions have been properly set for access to objects in your databases. SELECT USER_NAME(p.grantee_principal_id) AS principal_name, dp.type_desc AS principal_type_desc, p.class_desc, OBJECT_NAME(p.major_id) AS object_name, p.permission_name, p.state_desc AS permission_state_desc FROM sys.database_permissions p INNER JOIN sys.database_principals dp […]
Continue readingBy SQLRx Admin | Helpful Scripts , SQL Server , Tip of the Month
SQL Server Development: Take apart delimited strings with ease with a function that is commonly found in Visual Basic. Pass a delimited string into the fnSplit function and it will output the string as a table that can be queried. The function is called by this statement: SELECT * FROM dbo.fnSplit(‘SQLRx,Solves,Performance,Problems’,’,’) It will output a […]
Continue reading