Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content by Hugo Kornelis

SQLServerCentral.com profile

   Items 1 to 20 of 22    Next 20 >>
 

Complex joins

By Hugo Kornelis 2011/12/06 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,568 reads

MERGE with ANSI

By Hugo Kornelis 2011/11/25 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,195 reads

Table space usage 3

By Hugo Kornelis 2011/12/02 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,856 reads

Table space usage 2

By Hugo Kornelis 2011/11/16 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 2,255 reads

Table space usage 1

By Hugo Kornelis 2011/11/09 | Category: database design
Rating: (not yet rated) |  Discuss |   Briefcase | 2,179 reads

HAVING EXISTS

By Hugo Kornelis 2010/09/08 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 4,010 reads

HAVING without GROUP BY

By Hugo Kornelis 2010/08/31 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 4,315 reads

Round up or down IV

By Hugo Kornelis 2010/08/24 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 3,196 reads

Round up or down III

By Hugo Kornelis 2010/08/17 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 3,339 reads

Round up or down II

By Hugo Kornelis 2010/08/10 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 3,166 reads

Round up or down I

By Hugo Kornelis 2010/08/03 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 3,262 reads

HAVING

By Hugo Kornelis 2010/06/07 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 4,178 reads

Clustered indexes

By Hugo Kornelis 2010/05/06 | Category: indexing
Rating: (not yet rated) |  Discuss |   Briefcase | 3,931 reads

Using IDENTITY as a key column

By Hugo Kornelis 2010/04/20 | Category: identity
Rating: (not yet rated) |  Discuss |   Briefcase | 4,382 reads

Fixed to varying length

By Hugo Kornelis 2009/09/04 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 3,926 reads

Reclaiming freed space

By Hugo Kornelis 2009/07/28 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 4,716 reads

IGNORE_DUP_KEY

By Hugo Kornelis 2008/11/05 | Category: design and theory
Rating: (not yet rated) |  Discuss |   Briefcase | 3,466 reads

Simulating memory pressure

By Hugo Kornelis 2008/09/01 | Category: performance tuning
Rating: (not yet rated) |  Discuss |   Briefcase | 3,593 reads

GROUP BY ALL

By Hugo Kornelis 2008/08/04 | Category: sql server 2008
Rating: (not yet rated) |  Discuss |   Briefcase | 4,352 reads
   Items 1 to 20 of 22    Next 20 >>