Timothy A Wiseman

Timothy A Wiseman is a Database Administrator for SAIC with a focus on efficiency and readability of the database and its surrounding ecosystem. In addition to administering the core SQL Server system, he has experience working with Python and Microsoft Access in conjunction with SQL Server. He holds a Bachelor's of Science in Mathematics as well as an MCDBA and MCITP.

Interests: SQL Server, Python, Go, Mathematics, Legal Issues

An Informal Look at Database Performance

by Timothy A Wiseman

SQLServerCentral.com

Performance Tuning

A review on the basic steps to correct a poorly performing query

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(51)

Log in or register to rate

You rated this post out of 5. Change rating

2010-09-08

12,488 reads

Discuss

Going From Many Schemas To One Schema

by Timothy A Wiseman

SQLServerCentral.com

ETL (Extract Transform and Load)

A Technique to deal with moving data from multiple schemas into one table

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(20)

Log in or register to rate

You rated this post out of 5. Change rating

2010-08-09

6,406 reads

Discuss

Undocumented Extended and Stored Procedures

by Timothy A Wiseman

SQLServerCentral.com

Stored Procedures

Some useful undocumented extended and stored procedures in SQL Server 2005

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(89)

Log in or register to rate

You rated this post out of 5. Change rating

2009-11-20 (first published: 2008-05-09)

33,505 reads

Discuss

Finding Values With Numerous Columns

by Timothy A Wiseman

SQLServerCentral.com

Search

Techniques for finding values in a denormalized table.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(26)

Log in or register to rate

You rated this post out of 5. Change rating

2008-12-02

9,128 reads

Discuss

sp_update_job for all jobs.

by Timothy A Wiseman

SQLServerCentral.com

Agent jobs

Runs a custom sp_update_job statement against every job on the server.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(4)

Log in or register to rate

You rated this post out of 5. Change rating

2008-10-23 (first published: 2008-08-24)

1,917 reads

Discuss

On Indexes and Views

by Timothy A Wiseman

SQLServerCentral.com

Indexed Views

A short description of requirements to fully utilize the indexes on views.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(27)

Log in or register to rate

You rated this post out of 5. Change rating

2008-09-09

12,798 reads

Discuss

LongPrint

by Timothy A Wiseman

SQLServerCentral.com

Print

Simple script overcomes the 8000 character limitation in the T-SQL print Command

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(10)

Log in or register to rate

You rated this post out of 5. Change rating

2008-07-28 (first published: 2008-05-28)

4,288 reads

Discuss

CTEs in Report Creation

by Timothy A Wiseman

SQLServerCentral.com

Common Table Expressions (CTE)

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

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

Log in or register to rate

You rated this post out of 5. Change rating

2008-03-31

6,171 reads

Discuss

Reading Ad Hoc Text Files with OpenDataSource

by Timothy A Wiseman

SQLServerCentral.com

OpenDataSource

Discusses the techniques and reasons to use opendatasource for reading text files in SQL Server 2005.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(25)

Log in or register to rate

You rated this post out of 5. Change rating

2007-12-13

10,387 reads

Discuss

Blogs

Day of Data Baton Rouge Slides and Code

Thanks to everyone for attending my talk today at Day of data Baton Rouge...

Using Claude Code as a Database SRE Agent with the Everpure Fusion MCP Server

By Anthony Nocentino

Here’s the scenario: one of my SQL Server instances migrated to the DR array....

The Book of Redgate: Products

We are product focused at Redgate Software. Here is another of our values that...

Read the latest Blogs

Forums

ALAMAT BANK BCA KCU TARAKAN TLP/WA 08218200203

Hub Cs:08218200203 Jl. Yos Sudarso Pantai No.08, Karang Rejo, Kec. Tarakan Bar., Kota Tarakan,...

Alamat Bank BCA KCU BALIKPAPAN Telp 08218200203

Hub.Via,WhatsApp:08218200203 Jl. Jenderal Sudirman No.139, Klandasan Ilir, Kec. Balikpapan Kota, Kota Balikpapan, Kalimantan Timur...

Alamat Bank BCA KCU PALANGKARAYA Telp 08218200203

By layanan_Bca88

Hub.Via,WhatsApp:08218200203 Jl. Jend. A. Yani No.47, Langkai, Kec. Pahandut, Kota Palangka Raya, Kalimantan Tengah...

Visit the forum

Question of the Day

BIT_COUNT() III

In SQL Server 2025, I run this code:

select bit_count(-1)

What is returned?

See possible answers