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 66 (651 total posts)
  • Deploy RDL files to multiple SQL Server 2005 Reporting Services servers

    Last week, while teaching a SQL Server 2005 Reporting Services class, I built this simple C# Windows forms application to help ''push'' an RDL report to multiple servers. It is a simple application that calls the CreateFolder and CreateReport Web methods on the ReportService2005 Web service. It's easy enough to customize for ...
    Posted to Richard Hundhausen: The DBAgilist (Weblog) by Anonymous on December 26, 2006
  • Does XLOCK always prevent reads by others?

    I was going back through my files of draft blogs for the past 6 months (particularly looking for things that are wrong in my book,) and I found this one that covers something that I found really fascinating.)  In this thread, a person was attempting to create a pessimistic lock by applying an XLOCK in a hint.  Seemed reasonable to me, ...
    Posted to Louis Davidson (Weblog) by drsql on December 13, 2006
  • 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
Privacy Statement