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 35 of 37 (362 total posts)
  • Blogging the DMV's

    Well, I am working on a project that is going to be a book on dynamic management views (and functions, but DMF is an interesting acronym, and objects, as in DMO, has a well known other meaning.  What I will post will be one object in the following format: Name of object Type: Function or View Parameters: If it is a function Scope: Really ...
    Posted to Louis Davidson (Weblog) by drsql on July 10, 2007
  • Generate huge test tables using CTE

    Sometimes I need to have a huge table to make performance tests and I want to create the table easily. I found a simple way of producing these test data using CTE in a creative way and decided to post it so I can have it at hand when needed and maybe somebody will find it useful. The trick is to have a CTE Select that generates numbers from 0 to ...
    Posted to Alberto Ferrari (Weblog) by AlbertoFerrari on July 2, 2007
  • Bulk Insert of sorted data

    In a previous post I showed how to make bulk insert faster using SSIS. During Sql Server Conference 2007 I had the great opportunity to double check it with Stefano Stefani that analyzed the problem in greater detail and finally came up with both an explanation of the problem and a simple workaround when facing the same problem with T-SQL (my ...
    Posted to Alberto Ferrari (Weblog) by AlbertoFerrari on July 2, 2007
  • Making Fast Load really fast on clustered indexed tables with SSIS

    I have been so used to use int identity fields as primary key for any table and to believe it’s the fastest way to define a clustered primary key that I never thought this can cause serious performance problems to SSIS. Until I tested it and discovered that int identity primary keys are among the slowest way to insert huge amount of data with ...
    Posted to Alberto Ferrari (Weblog) by AlbertoFerrari on April 8, 2007
  • SQL Server Search Macro (plus build your own directed search!)

    Microsoft has built a little site for searching the books online on the web (which gives you links that are more readily shared with others): That is nice, but what is nicer is that you can create your own search macros and save them.. Just click the “create your own search ...
    Posted to Louis Davidson (Weblog) by drsql on April 3, 2007
  • Getting the difference between two sets of like data

    A question came up on the forums the other day that a person wanted to compare two tables of data.  Doing this is pretty easy using several techniques:   Using EXCEPT Using NOT EXISTS Using a FULL OUTER JOIN First two sample tables which represent two sets of data that you would get from a statement, from clause, etc.  ...
    Posted to Louis Davidson (Weblog) by drsql on February 8, 2007
  • SSIS: ForEach Looping through a recordset

    I was trying to find a way to repeatedly run the same MDX CREATE GLOBAL CUBE statement 70 times, building 70 different offline cubes for sales rep type folks to carry around for a client, and I just couldn't get it. I have some experience with SSIS, mostly from writing a tutorial on how to do RSS feeds with SSIS earlier that I am not sure ...
    Posted to Louis Davidson (Weblog) by drsql on January 19, 2007
  • 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
  • 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
Privacy Statement