Ever wonder if there was a way to quickly and easily know which sp_configure options were dynamic, besides having to read the BOL? What? Am I the only one? OK, fine, but at least I knew of a way to get that done as well as to return the current running values without having to … Read more
Remember how I told you we would talk about the sysindexes system table? Well today is the day! Two quick notes: First, this system table is scoped at the database level (not the instance level). Second, this system table will be removed from a future version of SQL Server. What is this table for? This … Read more
Today we will be talking about the sysobjects system table. This system table is scoped at the database level (not the instance level), so take note of that when you are building scripts. You always need to be mindful about the scope of the system tables otherwise it will lead to some unexpected results. As … Read more
Did you ever wish that you could access the information contained inside of Perfmon counters by using some simple T-SQL statements and not resorting to using WMI code or xp_cmdshell? Well today is your lucky day! Well, mostly your lucky day. Read on to find out why sysperfinfo may be the greatest thing ever for … Read more
Yesterday we talked about the sysdatabases system table and today’s entry is about the sysservers system table. As with other system tables, this one has the same disclaimer that this system table will be removed from a future version of SQL Server. So, yeah, you have been warned. What is this table for? From the … Read more
Yesterday we talked about the sysusers system table, and today we are going to talk about the sysdatabases system table. This table is scoped at the instance level and in case you need a reminder this system table will be removed from a future version of SQL Server. What is this table for? This table … Read more
