SQL Server Hints

some hints, about SQL Server for you :)

Monday, December 22, 2008

T-SQL PIVOT Statement

http://geekswithblogs.net/lorint/archive/2006/08/04/87166.aspx
Posted by Ahmed M. Safwat at 10:42 AM

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Facebook

Ahmed M. Safwat

Create Your Badge

Translate

Search This Blog

Blog Archive

  • ►  2012 (5)
    • ►  February (3)
    • ►  January (2)
  • ►  2011 (16)
    • ►  September (1)
    • ►  August (1)
    • ►  June (9)
    • ►  May (4)
    • ►  April (1)
  • ►  2010 (3)
    • ►  May (2)
    • ►  March (1)
  • ►  2009 (9)
    • ►  November (1)
    • ►  July (3)
    • ►  May (1)
    • ►  April (4)
  • ▼  2008 (47)
    • ▼  December (15)
      • T-SQL PIVOT Statement
      • Strategies for Refactoring Cursors
      • Cursor usage and performance issues
      • T-SQL PIVOT Statement
      • Query performance
      • About Cursor
      • Project REAL: Technical Overview
      • Schema Design in Optimization
      • Performance Optimization Model
      • Blocked Process Report
      • concurrency related problems and control - Isolati...
      • Guidelines for Identifying Locking and Blocking
      • Query Performance
      • Query Performance.jpg
      • Measuring Database Performance
    • ►  November (18)
    • ►  October (4)
    • ►  September (7)
    • ►  August (3)

About Me

My photo
Ahmed M. Safwat
Ahmed Safwat Gawady, information technology expert (Software Apps Developer and Databases Consultant). Commerce graduate department of Business Administration, University of Cairo. Since graduating in 2002, he worked in the field of applications development and systems analyst . then moved in 2005 to the field of education solutions as lecturer approved from Microsoft (MCT) and since that time he had participated as executive and general director (SDLC, STLC) in many desktop applications projects, sites and smart phone apps. even he had his opportunity in 2011 to held a product management position in one of the training companies . currently he responsible for field of technical consulting and e-business management projects.
View my complete profile

Subscribe To

Posts
Atom
Posts
Comments
Atom
Comments

Links

  • Windows PowerShell Owner's Manual

Total Pageviews

Popular Posts

  • DBCC SHRINKFILE (Transact-SQL)
    A. Shrinking a data file to a specified target size The following example shrinks the size of a data file named DataFile1 in the UserDB user...
  • Database Mirroring in SQL Server 2008
    In this post -Introduction -Database mirroring Terminology -Database Mirroring Topology -Facts about database mirroring -Modes of Dat...
  • Sample Replication Peer-To-Peer SQL Server 2008 .
    What is Peer-To-Peer Replication ? By the declaration of MSDN for Peer-To-Peer Replication 'Peer-to-peer replication provides a scale-...
  • Some notes and pics about install SQL Sever 2008
    1- setup needs to upgrade windows installer in the current windows with i nstall DotNetFramework 3.5 with SP1 2- The Installer will install ...
  • UNIQUEIDENTIFIER with ROWGUIDCOL
    Example 1 : CREATE TABLE MyTable (ID UNIQUEIDENTIFIER PRIMARY KEY DEFAULT NEWID(), nam varchar(max)) insert into MyTable (nam) values (...
  • SQL Server 2008 Implementing Log Shipping
    In this post - Introduction - Process of Log Shipping - Log Shipping topology - Log Shipping Prerequisites - Step by step example - H...
  • SQL Server 2008 (T-SQL) Creating FullText Index
    this example work on adventureworks database. for working with fulltext index , we need to create index on table . the following code cre...
  • User-Defined Table Types (SQL 2008)
    In SQL Server 2008, a user-defined table type is a user-defined type that represents the definition of a table structure. You can use a user...
  • Performance Optimization Model
  • SQL Server 2012 steps installation
    Platform and services installation. - Windows Server 2008 with SP2. - Install IIS. >> Some Prerequisites for install '...
Powered By Blogger

Followers
Picture Window theme. Powered by Blogger.