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 65 of 67 (662 total posts)
  • 32 bit tools on a x64 server.

    Ok, I readily admit I don't know everything about SQL Server.  But today I learned something that I would have thought I would have seen somewhere.  I was having issues getting an SSIS package to build some offline cubes (on my 32 bit workstation, and tested initially on a 32 bit server) to work on a 64 bit server.  It worked ...
    Posted to Louis Davidson (Weblog) by drsql on January 18, 2007
  • 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
Privacy Statement