A service from Red Gate
Home SQL .NET SysAdmin Opinion Blogs Forums Books
Sign in  | Join  | Help
SQL Home
Paul Nielsen Switching rows and columns in SQL
by Paul Nielsen | 04 February 2010 |  4 comments |
When they use SQL Server, one the commoner questions that Ms Access programmers ask is 'Where's the TRANSFORM/PIVOT command? So how do you swap colums and rows in an aggregate table? Do you really need to use a CLR routine for this? Read more...
Buck Woody Mission Critical: SQL Server 2008 Performance Tuning Task List
by Buck Woody | 04 February 2010 |  1 comment |
In which Buck Woody imagines how the US military would have tackled DBA checklists for 'mission-critical' databases. And having imagined it, lo, it came to be. The CTL for the DBA with short-back-and-sides. Read more...
Kathi Kellenberger Writing Efficient SQL: Set-Based Speed Phreakery
by Kathi Kellenberger | 04 February 2010 |  30 comments |
Phil Factor's SQL Speed Phreak challenge is an event where coders battle to produce the fastest code to solve a common reporting problem on large data sets. It isn't that easy on the spectators, since the programmers don't score extra points for commenting their... Read more...
TITLE PUBLISHED RATING VOTES
 Simple Query tuning with STATISTICS IO and Execution plans 04 February 2010 16 votes
 Finding Stuff in SQL Server Database DDL 04 February 2010 11 votes
 Implementing User-Defined Hierarchies in SQL Server Analysis Services 02 February 2010 2 votes
 SQL Search- The Search and the Sequel 02 February 2010 5 votes
 Exceptional PowerShell DBA Pt 2 - The Morning Checklist 21 January 2010 45 votes
 Managing Data Growth in SQL Server 21 January 2010 18 votes
 Laying out SQL Code 21 January 2010 33 votes
 Brad's Sure DBA Checklist 20 January 2010 113 votes
 Celko's SQL Stumper: The Class Scheduling Problem 19 January 2010 8 votes
 13 Things You Should Know About Statistics and the Query Optimizer 07 January 2010 72 votes
 Database Maintenance Plans in SSMS: An Overview 06 January 2010 12 votes
 Monitoring SQL Server Virtual Log File Fragmentation 06 January 2010 11 votes
 Five Basic Steps for Implementing an Analysis Services Database 05 January 2010 8 votes
 The SQL of Scrabble and Rapping 25 December 2009 27 votes
 Working with the bcp Command-line Utility 10 December 2009 24 votes
 SQL Server Partitioning without Enterprise Edition 10 December 2009 16 votes
 Exceptional PowerShell DBA Pt1 - Orphaned Users 26 November 2009 40 votes
 Eating SQL Server Installations for Breakfast 24 November 2009 14 votes
 Managing Transaction Logs in SQL Server 12 November 2009 59 votes
 Pivoting, Un-pivoting and Aggregating: A Quick Spin Around the Block 12 November 2009 42 votes
  Learn SQL Server (36 articles)

  Database Administration (67 articles)
  T-SQL Programming (87 articles)

  Performance (18 articles)
  Backup and Recovery (18 articles)

  SQL Tools (44 articles)
  SSIS (12 articles)

  Reporting Services (12 articles)

  SQL Home

  Learn SQL Server (36 articles)

  SQL Training

  Database Administration (67 articles)

  T-SQL Programming (87 articles)

  Performance (18 articles)

  Backup and Recovery (18 articles)

  SQL Tools (44 articles)

  SSIS (12 articles)

  Reporting Services (12 articles)

Phil Factor
Finding Stuff in SQL Server Database DDL
 You'd have thought that nothing would be easier than using SQL Server Management Studio (SSMS) for searching... Read more...



 View the blog
Beginning SQL Server 2005 Reporting Services Part 1
 Steve Joubert begins an in-depth tour of SQL Server 2005 Reporting Services with a step-by-step guide... Read more...

Ten Common Database Design Mistakes
 Database design and implementation is the cornerstone of any data centric project (read 99.9% of... Read more...

Beginning SQL Server 2005 Reporting Services Part 2
 Continuing his in-depth tour of SQL Server 2005 Reporting Services, Steve Joubert demonstrates the most... Read more...

SQL Server Full Text Search Language Features
 SQL Full-text Search (SQL FTS) is an optional component of SQL Server 7 and later, which allows fast... Read more...

Creating CSV Files Using BCP and Stored Procedures
 Nigel Rivett demonstrates some core techniques for extracting SQL Server data into CSV files, focussing... Read more...

Over 150,000 Microsoft professionals subscribe to the Simple-Talk technical journal. Join today, it's fast, simple, free and secure.

Join Simple Talk


Privacy policy | Terms and conditions | ©2005-2010 Red Gate Software
About | Site map | Become an author | Newsletters | Contact us