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 (658 total posts)
  • New, simpler AdventureWorks sample database

    Trainers and presenters have been wanting a sample database that is less complex than AdventureWorks, but more interesting than Northwind. Thanks to my friends at SolidQ for letting me know about AdventureWorksLT (Light) ... (Click to see a larger view) You can download AdventureWorksLT from CodePlex or Microsoft.
    Posted to Richard Hundhausen: The DBAgilist (Weblog) by Anonymous on April 20, 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
  • SQL Server 2005 Worst Practices

    Thanks for attending my talk last night and letting me share my SQL Server 2005 Worst Practices. I hope I didn't embarass anyone too badly by highlighting your practice in my talk! Here are the slides, script, and sample project from last night's talk.
    Posted to Richard Hundhausen: The DBAgilist (Weblog) by Anonymous on January 19, 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
  • 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
Privacy Statement