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

Guest Columnist: Timothy A Wiseman

SQLServerCentral.com profile

   Items 1 to 9 of 9   
 

Exploring the Varbinary Type

A brief look at the Varbinary data type and its uses in SQL Server for beginners.  Read more...
By Timothy A Wiseman 2013/02/07 | Source: SQLServerCentral.com | Category: data types
Rating: |  Discuss |   Briefcase | 5,893 reads

Single User Performance of SQLite v. SQL Server

A look at the performance of SQL Server compared to SQLite for single user applications.  Read more...
By Timothy A Wiseman 2012/07/19 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 2,204 reads

An Informal Look at Database Performance

A review on the basic steps to correct a poorly performing query  Read more...
By Timothy A Wiseman 2010/09/08 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 11,824 reads

Going From Many Schemas To One Schema

A Technique to deal with moving data from multiple schemas into one table  Read more...
By Timothy A Wiseman 2010/08/09 | Source: SQLServerCentral.com | Category: etl
Rating: |  Discuss |   Briefcase | 6,296 reads

Finding Values With Numerous Columns

Techniques for finding values in a denormalized table.  Read more...
By Timothy A Wiseman 2008/12/02 | Source: SQLServerCentral.com | Category: search
Rating: |  Discuss |   Briefcase | 8,054 reads

On Indexes and Views

A short description of requirements to fully utilize the indexes on views.  Read more...
By Timothy A Wiseman 2008/09/09 | Source: SQLServerCentral.com | Category: indexed views
Rating: |  Discuss |   Briefcase | 12,086 reads

Undocumented Extended and Stored Procedures

Some useful undocumented extended and stored procedures in SQL Server 2005  Read more...
By Timothy A Wiseman 2009/11/20 (first published: 2008/05/09) | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 30,221 reads

CTEs in Report Creation

A discussion on using CTEs to speed the development and maintenance of reports and enhance readability.  Read more...
Rating: |  Discuss |   Briefcase | 5,825 reads

Reading Ad Hoc Text Files with OpenDataSource

Discusses the techniques and reasons to use opendatasource for reading text files in SQL Server 2005.  Read more...
By Timothy A Wiseman 2007/12/13 | Source: SQLServerCentral.com | Category: opendatasource
Rating: |  Discuss |   Briefcase | 8,075 reads
   Items 1 to 9 of 9