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 33 of 37 (362 total posts)
  • SSIS: living in a parallel world? Not yet...

    Today I come into a nice bug (misfeature?) of SSIS 2008 and I'd like to share it with you. Let's start from the beginning: One of the keys to make something speedy is to parallelize it. In TableDifference I read from two inputs, compare them and produce several outputs for new, deleted, updated rows and so on. It is the classical ...
    Posted to Alberto Ferrari (Weblog) by AlbertoFerrari on September 14, 2008
  • Commenting your code

    As I am easing back into real life from writing the book, I am in search of easy targets for blogging.  My boss mentioned this blog over on Jeff Atwood's Coding Horror Blog and it got me thinking about commenting.  His advice is to only comment "why" the code works.  I can't quite agree, because the code he claims to be ...
    Posted to Louis Davidson (Weblog) by drsql on July 30, 2008
  • On Developer Communities: Meeting Idea - Fix the Broken Code!

    Robin Edwards is the leader of the Roanoke Valley .Net User Group. They did something really cool for their last meeting (July 2008). As Robin describes it: Some of the members of RV.NUG tossed around a way to get more involvement during the meeting AND deal with the low summer attendance by coming up with something fun and easy.  We were ...
    Posted to Andy Leonard (Weblog) by andyleonard on July 17, 2008
  • SQL Server Management Studio Standard Reports

    Buck Woody has a great series going on SQL Server ManagementStudio Standard Reports. The SQL Server team did a great job developing these insightful and intuitive reports. I often show them to customers and during presentations and the response is always positive. :{> Andy
    Posted to Andy Leonard (Weblog) by andyleonard on March 11, 2008
  • 2008: Error List in 2008

    Ok, so I was looking around for a blurb about plan guides for my anti ad hoc SQL section of my book (ok, maybe not completely anti- but that isn't the point,) when I found this blog: that basically just lists some new features in 2008.  One that I hadn't seen I feel the need to ...
    Posted to Louis Davidson (Weblog) by drsql on March 5, 2008
  • 2008: Declaring and instantiating a value

    Ok, I admit it.  Sometimes the least important things are the most fun.  As I try to get my blog back up and kicking again after a few months of holiday fun coupled with some dreary personal life things (a death in the family and lots of sickness/busyness, mostly,) I felt the need to write about another little time saving feature that ...
    Posted to Louis Davidson (Weblog) by drsql on March 1, 2008
  • 2008: Rebuilding a Heap

    In 2005, rebuilding a table that was a heap (no clustered index) wasn't easy.  You could copy it to a different table, or you could add a clustered index and then drop it. In 2008, this is a far easier thing to do.  They have added to the ALTER TABLE command a method to rebuild the table, which is the same as rebuilding the clustered ...
    Posted to Louis Davidson (Weblog) by drsql on February 26, 2008
  • Changing the owner of a database

    Tonight, as I was creating my sample database for my chapter on implementing the database, I learned something new, that existed in 2005.  I had always used sp_changedbowner to change the owner of a database, but I was reading in another section about ALTER AUTHORIZATION earlier to change the owner of an object in a schema, so I said to my ...
    Posted to Louis Davidson (Weblog) by drsql on December 5, 2007
  • Installing Reporting Services 2005 on Vista

    I have a new Dell desktop. The first thing I did was install Vista 64-bit and bumped it up to 4GB of RAM. I'm now trying to install a default instance of SQL Server 2005 Developer and can't get Reporting Services to run because IIS isn't installed. After trying the click-a-bunch-of-stuff in the ''Turn Windows features on or off'' dialog, I ...
    Posted to Andy Leonard (Weblog) by andyleonard on November 29, 2007
  • Generate date dimension that support working days calculation

    I just wrote a T-SQL query based on CTE that generates support information to calculate working days in a period. Simply look at the WorkingDaySequential measure, which difference between two dates is the number of elapsed working days. In the real world: The Holidays CTE could be replaced by a real table with user-inserted data. The ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on November 27, 2007
« First ... < Previous 31 32 33 34 35 Next > ... Last »
Privacy Statement