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 » Transactions   (RSS)
  • Geek City: How Many Rows?

    In my last post, I told you I'd post something technical before I left for Sweden. I almost made it. I wrote this in the Seattle airport, but wasn't able to post it until I got to Stockholm. For as long as I've been working with SQL Server, I've been hearing/reading questions about how to quickly get a count of the number of rows in a table. ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on December 7, 2009
  • 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
Privacy Statement