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

Guest Columnist: GSquared

SQLServerCentral.com profile

   Items 1 to 4 of 4   
 

Hierarchies in SQL, Part II, the Sequel

In a followup to his first article on Hierarchies, Gus Gwynn takes a look at the performance of a few different methods of querying a hierarchy. Learn how the HierarchyID stacks up.  Read more...
By GSquared 2012/08/21 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 7,103 reads

Hierarchies in SQL

One very common structure that needs to be handled in T-SQL is the hierarchy. One of our prominent members of the community discusses how you can handle hierarchies in SQL Server.  Read more...
By GSquared 2010/12/10 (first published: 2009/01/28) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 30,586 reads

Audit Trails and Logging Part II

Continuing with Part II of his auditing series, Gsquared takes a look at active auditing techniques for your SQL Server.  Read more...
By GSquared 2008/06/10 | Source: SQLServerCentral.com | Category: auditing
Rating: |  Discuss |   Briefcase | 9,743 reads

Audit Trails and Logging Part I

Auditing becomes more important every day as new requirements for data access are implemented. New author Gsquared, well known in the forums, brings us a look at types of audits and some details on passive auditing techniques.  Read more...
By GSquared 2008/06/09 | Source: SQLServerCentral.com | Category: auditing
Rating: |  Discuss |   Briefcase | 13,362 reads
   Items 1 to 4 of 4