Archive

RSSDesign (2)

Date Title Rating
2008-06-17 The Trouble with Triggers None
2008-03-08 An Era of Increased Expectations... None

RSSSQL Server 2008 (10)

Date Title Rating
2008-06-22 A nice MSDN article on SQL 2008 Data Warehousing None
2008-04-23 SQL 2008 Geometry type tidbits None
2008-04-16 Costing and Statistics, continued... None
2008-03-14 Progress on the SQL 2008 CTP6 Installation Problems None
2008-03-08 Query Optimization DMV du jour - sys.dm_exec_query_optimizer_info None
2008-01-29 Operator of the Day: Sequence Project None
2008-01-27 Subqueries in the Query Optimizer None
2008-01-22 SQL Server IN Plans and the query plan cache None
2008-01-19 User Question: Plan Cache Pollution None
2008-01-16 Howdy! Come on in! None

RSSUncategorized (37)

Date Title Rating
2008-07-23 New blog location None
2008-07-06 My blog will be moving None
2008-07-03 What's Conor been doing? None
2008-06-02 Outer joins and ON clauses vs. WHERE clauses None
2008-05-12 Contradictions within Contradictions None
2008-04-21 COUNT(1) vs. COUNT(star) None
2008-04-16 COUNT(star) vs COUNT(column) vs. COUNT(DISTINCT) vs. COUNT(col) OVER(...) None
2008-04-09 Statistics, Damned Lies, and Statistics - What is Statman? None
2008-04-08 Slow Outlook 2007 on Vista (x64) None
2008-03-31 How to write non-JOIN WHERE clauses None
2008-03-29 ON vs. WHERE - where should you put join conditions? None
2008-03-26 Local-Global Aggregation None
2008-03-23 Hunting for SQL 2008 SPARSE Column Easter Eggs None
2008-03-17 1753, datetime, and you None
2008-03-17 SQL 2008 CTP Installation Problems - Largely Fixed None
2008-03-12 Inserts against views - An introduction None
2008-03-06 CTP6 Install Problems Update None
2008-03-02 SQL 2008 CTP6 Filtered Indexes in Action - disjunction of ranges and index choice None
2008-02-25 Filtered Indexes Make Me Drool... None
2008-02-24 SQL 2008 CTP6 installation DOA. None
2008-02-23 grrr... installation woes with SQL 2008 CTP5/6 None
2008-02-21 SQL Server Scalar Operator Costing aka "umm, what costing?" None
2008-02-19 Statistics Backgrounder None
2008-02-18 Operator of the Day: Streaming Table-Valued Functions (aka the Dynamic Management View/Function) None
2008-02-16 RAND() and other runtime constant functions, redux None
2008-02-13 GROUPING SETS, ROLLUPs, and CUBES, oh my! None
2008-02-11 Wrapping my head around RAND() in SQL Server None
2008-02-10 Operator of the Day: Segment None
2008-02-07 EXISTS Subqueries: SELECT 1 vs. SELECT * None
2008-02-06 Database Virtualization - The Dirty Little Secret Nobody is Talking About... None
2008-02-05 VirtualPC/VMWare on your SQL box? None
2008-02-02 Partition Elimination 202 None
2008-01-31 An Introduction to Partition Elimination None
2008-01-30 DBCC MEMORYSTATUS - Memory objects and the SQL Server Query Optimizer None
2008-01-29 A Call for Data Warehouse War Stories... None
2008-01-27 SQL Server Query Optimization and Data Warehouses None
2008-01-22 INteresting... None

Total

49 posts

0 raters

Theme design by Nukeation based on Jelle Druyts