Bob Probst

Bob Probst has asked 5 questions and find answers to 10 problems.

Stats

About

When I'm not managing a data warehouse for a mid-sized financial institution I'm shooting pool and playing boardgames.

I'm also crazy about my little shaver.

Bob Probst questions

Corrupted database table with invalid query: what has it done and will it roll back?
Calculate the last day of the prior quarter
Rule of thumb on when to use WITH RECOMPILE option
Fastest way to update 120 Million records

Bob Probst answers

Database Architecture for "Badge" System & Arbitrary Criteria (MySQL/PHP)
SQL Switch/Case in 'where' clause
Comparing values of 2 tables and listing the rows that are different
SQL Server 2008 R2 Geography Distance?
Is there a better way to debug SQL?
Representing time periods in the UI and database
Pivot Table and Concatenate Columns
How can I drop a table if it exists in SQL Server 2000?
Easiest way to decrypt PGP-encrypted files from VBA (MS Access)
SQL Wildcard instead of key in SELECT statement