Home Menu
  • Home
  • About – Tomas Lind
  • Contact
  • Blog Series
    • Technical Analysis (TA)
  • T-SQL
    • T-SQL Scripts
    • Templates
  • Consulting Services
  • Software
Tomas Lind

Posts in Category ‘Dynamic Management Objects’

Dynamic Management Views and Objects

  • 2015/07/14
  • 0 comments

sys.dm_exec_cached_plans

The dynamic management view sys.dm_exec_cached_plans returns information on query plans currently in memory. This information can be useful for a lot of reasons: checking total memory allowed for cached plans, which plans aren’t getting reused, searching for certain query plan … Read more →

  • Posted in: Dynamic Management Objects, Monitoring, Tips & Tricks
  • 2015/05/15
  • 0 comments

Capturing Blocked Queries

In a previous post, I presented a solution for monitoring and logging long running queries in SQL Server. In this post I’ll show an extended version of that solution that also sends an email when a request has been blocked … Read more →

  • Posted in: Alerts, Blocking, Dynamic Management Objects, Monitoring
  • 2015/05/05
  • 0 comments

Capturing Long Running Queries

Long running queries in a database may or may not be a problem, depending on the type of system. In a data warehouse solution, queries that runs for several minutes may be perfectly normal and nothing to worry about. But … Read more →

  • Posted in: Dynamic Management Objects, Monitoring, Statistics
  • 2014/12/10
  • 1 comment

Mass editing of SQL Server objects

Ever had the need to replace a piece of code in multiple SQL Server objects (Stored Procedure, Trigger, Function or Views)? Here’s a method to search for a string in all objects, replace it with some other code, and to … Read more →

  • Posted in: Dynamic Management Objects, T-SQL, Tips & Tricks
  • 2014/03/04
  • 0 comments

Logging changes to sys.configurations

Some server wide settings can have major negative impact if they are changed in your SQL Server environment. So as a DBA it is a good practice to monitor changes to these setting, and to raise alerts when they are … Read more →

  • Posted in: Configuration, Dynamic Management Objects, System Stored Procedures
  • 2014/02/20
  • 4 comments

List SQL server roles by users

SQL Server roles can be used to give users server wide privileges. The server roles are sysadmin, securityadmin, serveradmin, setupadmin, processadmin, diskadmin, dbcreator and bulkadmin. The mapping between users and server roles can be found in the system view sys.server_role_members. … Read more →

  • Posted in: Dynamic Management Objects, Permissions, Security
  • 2014/02/18
  • 0 comments

A replacement for syslogins

The system table sys.syslogins was marked as deprecated in SQL Server 2005, and is included up until 2012 for backwards compability only. So what is the replacement of sys.syslogins? As it turns out, there is no exact match in SQL … Read more →

  • Posted in: Dynamic Management Objects, Permissions, Security
  • 2014/01/28
  • 15 comments

An alternative to xp_fixeddrives

Want to know the disk space available on your database server from T-SQL? This can be done in many ways, here I’ll present two of them. The first way is by using xp_fixeddrives. With the release of SQL Server 2008R2 … Read more →

  • Posted in: Dynamic Management Objects, System Stored Procedures
  • 2013/11/28
  • 0 comments

sp_describe_first_result_set

The system stored procedure sp_describe_first_result_set was introduced in SQL Server 2012 and it returns meta data about the first submitted T-SQL statement.

  • Posted in: Dynamic Management Objects, T-SQL

confided data manager

Get compliant with the GDPR!


High Coast Database Solutions

High Coast Database Solutions

sql server consulting services


Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Top Posts & Pages

  • How to align columns in Notepad++
  • Manual failover in a SQL Server cluster
  • Export data from Excel to SQL Server
  • List SQL server roles by users
  • CDC Cleanup job

Recent Posts

  • Get element max value from folder with XML files
  • Dynamic Data Masking (DDM) – Mask query results
  • The T-SQL Merge statement
  • From SQL Server to MSMQ using PowerShell
  • Identity columns that are about to overflow

Archives

Categories

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org

Instagram

This error message is only visible to WordPress admins

Error: No connected account.

Please go to the Instagram Feed settings page to connect an account.

  • © 2022 Tomas Lind
  • Proudly powered by WordPress
  • Theme: Waipoua by Elmastudio
Top ↑