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 36 of 37 (362 total posts)
  • 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
  • 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
  • Easier access to metadata coming soon to a SQL Server near you

    This is not a scoop or anything, but it is quite newsworthy.  It is also a good way to kick off my sqlblog Kalen Delaney - Metadata PowerSimon Sabin - object_name() to be extended in SP2 A very common request is to have some of the system functions to work in any database.  Kalen posted a piece of feedback on ...
    Posted to Louis Davidson (Weblog) by drsql on September 25, 2006
  • Visio does not handle Schema? Let's force it to do!

    I love VISIO to make database modeling, it gives very nice and colorful diagrams that I use for the documentation. I hate VISIO as it is really far from perfect, among all the others one thing it lacks is the ability to generate a database using SCHEMA information. As I like schemas I decided to find a way to bypass VISIO limitations, here ...
    Posted to Alberto Ferrari (Weblog) by AlbertoFerrari on September 6, 2006
  • SqlBulkTool

    SqlBulkTool is a command line utility that is used to quickly create a mirror of a database. It reads its configuration from an XML file containing source and destination command strings and a list of all the tables to mirror and then handles the work of copying the database in an automated and highly parallelized way. The parallelism can use the ...
    Posted to Alberto Ferrari (Weblog) by AlbertoFerrari on July 14, 2006
Privacy Statement