in

SQLServerCentral.com

The largest free SQL Server community.

Browse by Tags

  • The Problem With Joins

    I recently came up against a pretty big problem with outer joins on SQL Server, and thought I'd talk about it a bit. First let me give you a little background on the problem. <Begin Background> It's common in data warehousing and datamarts to "band" data. By "banding"...
    Posted to Pseudo-Random (Weblog) by Mike C on 10-20-2007
  • The Great SQL 2005 SP:CacheMiss-tery

    OK, so I'm using SQL Server Profiler on SQL 2005 to determine for myself if the rules for stored procedure name resolution are the same as for SQL 2000. So like any curious SQL programmer I jump in with a simple test. I ran the following script in SQL 2000: CREATE PROCEDURE dbo.Test AS SELECT 'Test';...
    Posted to Pseudo-Random (Weblog) by Mike C on 08-08-2006
  • SQL Basics: Part 2, Nonclustered Indexes

    Nonclustered Indexes If you caught the first article in the series, you know that clustered indexes are pretty handy. But sometimes you need to rapidly retrieve data without physically re-ordering your table. Going back to the clustered index analogy, some books (phone books, dictionaries, etc.) benefit...
    Posted to Pseudo-Random (Weblog) by Mike C on 05-14-2006
  • SQL Basics: Part 1, Clustered Indexes

    I've found that many article writers (myself included) make a lot of assumptions about basic concepts. I've also discovered that many times these assumptions leave some readers (especially newly minted DBA's, developers and others just learning the trade) with a lot of unanswered questions...
    Posted to Pseudo-Random (Weblog) by Mike C on 05-07-2006
Page 1 of 1 (4 items)
Copyright Red Gate Software
Powered by Community Server (Commercial Edition), by Telligent Systems