THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » metadata   (RSS)
Showing page 2 of 3 (25 total posts)
  • Geek City: What do you intend with that lock?

    Way back in the olden days, prior to SQL Server 7, I already knew that the lock manager was one of the most complex and resource intensive parts of SQL Server. Keeping track of every lock held, who was waiting for that lock, who could be granted the lock, and who was next in line for the data if the lock was released was a lot for SQL Server to ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on September 11, 2009
  • Geek City: ALTERing a Partition Function

    Finally, a real geeky post. I received two questions in as many weeks about what really happens to existing partitions when you alter the underlying partition function. The big question being… does altering a partition function cause any data movement? The answer, as usual, is “It depends” Most people who work with partitioning are aware that the ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on August 16, 2009
  • Geek City: Two Compression Questions and Parameter Metadata

    I am teaching the SQL 2008 version of my course for the first time this week. My life is still is disarray and spare time is practically non-existent.  During the evenings after I class I am trying to get caught up on several projects that I fell way behind on over the last month when most of my time was spent in the hospital. Blogging ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on March 10, 2009
  • Geek City: Clearing a Single Plan From Cache in SQL Server 2008

      I just today found out about something that was in plain sight in the Books Online... but the documentation is so vast, I haven't discovered everything yet. I blogged about clearing a single plan from cache in SQL Server 2005 a while back, and mentioned a rumor that there would be a new way to do this in SQL Server 2008. And then just ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on October 31, 2008
  • Geek City: Reducing Cache Bloat and a Metadata Bug

    I've been running some tests with the new SQL Server 2008 configuration option 'optimize for ad hoc workloads' which is intended to reduce cache bloat due to holding onto plans for single use ad hoc queries. This option will allow a new type of cached object to be stored, which isn't the only plan, but merely a stub. There will be a corresponding ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on October 29, 2008
  • Did You Know: How Compatible are the Compatibility Views?

    You're probably aware that the metadata interface changed completely in SQL Server 2005, and we no longer have direct access to the system tables. Instead, Microsoft provided us with two sets of views: the catalog views and the compatibility  views. The catalog views are the preferred interface going forward, as they are fully documented ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on September 14, 2008
  • Geek City: System Objects

    As you might know, metadata is one of my favorite topics, and I've written quite a bit about metadata and system objects. A very frequent question is: What exactly IS a system object? There are quite a few different definitions you could use. You could say a system object is one that was installed with your SQL Server installation. You could ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on August 11, 2008
  • Geek City: Why I still need Sysprocesses

    I've said many times that my favorite new feature in SQL Server 2005 is the new metadata, in particular the new Dynamic Management Objects. When I have to do troubleshooting on a SQL Server 2000 system, it is worse than painful, not to have my favorite tools like sys.dm_tran_locks, sys.dm_exec_cached_plans andsys.dm_exec_query_plan. By now, on the ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on June 29, 2008
  • Geek City: What's Worse Than a Table Scan?

    I have frequently heard SQL Server developers and DBAs gasp when a query plan is indicating that SQL Server is performing a table scan, thinking that is the worst thing that could ever happen to a query. The truth is, it's far from the worst thing and in addition, not all table scans are created equal. One thing that is far worse that a table ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on May 25, 2008
  • Did You Know? My DVD is in Production!

      The editing for Lesson 1 is done and the production run of my DVD has started. We're expecting shipping to start in about 2 weeks. In addition, we've extended the pre-order price for another 5 days, so any orders that come in before Valentine's Day will get the special reduced price. Because this is taking a bit longer than we hoped, we ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on February 8, 2008
Privacy Statement