SQLServerCentral - Guest Columnist: Timothy A Wiseman

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

Rating:

|

Discuss |

Briefcase | 11,560 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,222 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 | 7,907 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,126 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,561 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,468 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,559 reads