THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » metadata » statistics   (RSS)
  • Geek City: How old are my statistics?

    This post is basically to answer a question asked in class this week: How can we get the last statistics update date for ALL user tables in a database? After working on the query for a while, I realized that the new metadata function I posted about here can give you that info easily: SELECT object_name(sp.object_id) as object_name,name as ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on August 31, 2013
  • Did you know? Cloning is Legal (and Available in SQL Server 2005)

      I first heard about the possibility of database cloning way back in version 7.0 and thought it sounded like a great idea. Who wouldn't love to have a bunch of identical little databases running around, of smaller size and easier manageability? Cloning a database means creating a statistics only copy of it, so that you can examine ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on November 21, 2007
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement