SQLServerCentral - Guest Columnist: Timothy A Wiseman

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,370 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,123 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,745 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,261 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,005 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 | 11,792 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 | 29,891 reads

CTEs in Report Creation

A discussion on using CTEs to speed the development and maintenance of reports and enhance readability. Read more...

By Timothy A Wiseman 2008/03/31 | Source: SQLServerCentral.com | Category: common table expression (cte)

Rating:

|

Discuss |

Briefcase | 5,637 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 | 7,837 reads