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 » SQL Server   (RSS)
Showing page 64 of 65 (649 total posts)
  • The joys of a calendar table (ytd, month, and quarter summations)

    There was a question on the forums the other day that asked how to get a total for the current month, the current quarter, and year to date.  It is actually a pretty easy task when using a calendar table.  I have one you can use here (I fixed an error in it that I just found too!): ...
    Posted to Louis Davidson (Weblog) by drsql on December 9, 2006
  • Nice meeting new friends in Iowa

    Thank you for the good time last night at the Iowa .NET User Group meeting. I enjoyed spending the evening with these easy-going, but tech-savvy folks. We had a good turnout, great questions, and a fun time afterward at the 801 steak and chop house! If you are looking for my SQL Server 2005 script of love. You ...
    Posted to Richard Hundhausen: The DBAgilist (Weblog) by Anonymous on December 7, 2006
  • There is still stuff I hadn't noticed (OBJECT_ID has a parameter for type of object)

    I was building a script to build a table I had built in my dev environment including inserts so I did a bit of hunting around and came upon Vyas's script ( that is used to generate inserts from a table (script here:  Very cool stuff and worked nicely (all I ...
    Posted to Louis Davidson (Weblog) by drsql on December 3, 2006
  • Using the catalog views to see table permissions

    I was needing to get an idea of the permissions that had been granted in a couple of databases the other day, and being the GUI novice I am, couldn't find what I wanted easy enough (if it even is in there.)  So, I hunted around in the system views to see what I could find.  There are two views of major interest ...
    Posted to Louis Davidson (Weblog) by drsql on November 11, 2006
  • A script to check for the existence of data in tables or views

    This is the second time I have needed this, so that elevates it to blog status (code for mine and your reuse being the second most important reason I blog.  The most important one is the notoriety, glamour, and big bucks :) I have a database that I have recently needed to check to discover if data existed in them, and in some cases, ...
    Posted to Louis Davidson (Weblog) by drsql on November 3, 2006
  • The ultimate guide to SQL Server's datetime datatype

    I happened upon this article, which summarizes the datetime datatype and how it works in SQL Server, including common pitfalls and general recommendations. The site is run by Tibor Karaszi a fellow Solid Quality Learning mentor.
    Posted to Richard Hundhausen: The DBAgilist (Weblog) by Anonymous on October 27, 2006
  • Automatic indexing is something to tell you what indexes aren't used

    Now, I will admit up front that I haven't technically tried out all of their bits and pieces of the following tool, but over the past week I have made a lot of use of some of the indexing suggestions by ''hacking'' out the code that generates the index create statements from the sys.dm_db_missing_index_group_stats dynamic management view.  ...
    Posted to Louis Davidson (Weblog) by drsql on October 12, 2006
  • SQL Server Samples Blog

    On a private newsgroup I read, the question was asked: ''Samples in or out of the box? For the next release of SQL Server we're thinking of just shipping sample code on the web, instead of shipping on the web and also in the SQL Server box on a CD as we have done in the past.'' And I replied (amongst other things) that it would be nice if ...
    Posted to Louis Davidson (Weblog) by drsql on October 11, 2006
  • Red Gate's new refactor tool CTP has been released to the public

    A subject I have ranted about from time to time (here on the blog of course, in private I rant about this at least once a day...) is code formatting.  It is always a real pain to get some code from a user from the web (or someone else, closer to you) that is formatted in a way that makes it hard to read.  Now there is a tool for you that ...
    Posted to Louis Davidson (Weblog) by drsql on October 3, 2006
  • Another reason to hate quoted identifiers...

    I was working with the Redgate compare tool today (something I am a big fan of I might add,) using it to take a snapshot of my database so I could drop all code and do a collation change to a database (an article I updated because I discovered a new wrinkle with computed columns needing to be modified.) When I got to that point in the process ...
    Posted to Louis Davidson (Weblog) by drsql on October 1, 2006
Privacy Statement