Posts
83
Comments
600
Trackbacks
40
SQL Server
How can I update Multiple Tables at once
posted @ Thursday, April 03, 2008 9:49 AM | Feedback (4)
Because you're mine, I walk the line
posted @ Thursday, July 26, 2007 3:45 PM | Feedback (4)
Alias to be or not to be
posted @ Tuesday, March 27, 2007 2:59 PM | Feedback (2)
SET Versus SELECT (Or, Who Really Cares Anyway)
posted @ Monday, February 12, 2007 2:36 PM | Feedback (3)
Hierarchies with a twist...rocks, no salt
posted @ Monday, November 13, 2006 4:36 PM | Feedback (7)
How do I find all the tables referenced by Stored Procedures or Functions
posted @ Friday, September 22, 2006 12:32 PM | Feedback (6)
Stored Procedure Logging
posted @ Thursday, September 21, 2006 9:38 AM | Feedback (4)
Finding Trade and Receipt fallout
posted @ Wednesday, September 20, 2006 1:31 PM | Feedback (4)
How do I track data changes in a database
posted @ Thursday, August 10, 2006 1:59 PM | Feedback (4)
T-SQL HTML? Parser
posted @ Thursday, July 27, 2006 2:29 PM | Feedback (6)
How do I create a file with a header and trailer?
posted @ Thursday, June 29, 2006 1:03 PM | Feedback (2)
OSQL Doesn't work like Query Analyzer ( Or Query Analyser for that matter...)
posted @ Monday, June 26, 2006 12:57 PM | Feedback (6)
To the chagrin of Jeff or How to format data in T-SQL
posted @ Monday, October 10, 2005 5:05 PM | Feedback (2)
How can I automate the copying of a table?
posted @ Tuesday, August 16, 2005 1:40 PM | Feedback (3)
Once I'm done processing files, How can I archive them?
posted @ Thursday, June 30, 2005 3:40 PM | Feedback (9)
How do I use the DOS Command dir in T-SQL
posted @ Tuesday, June 28, 2005 10:33 AM | Feedback (13)
Extract Just Numbers from a String
posted @ Wednesday, June 22, 2005 5:05 PM | Feedback (3)
How do I add many rows of Data using 1 Stored Procedure
posted @ Wednesday, June 22, 2005 1:28 PM | Feedback (0)
Ghost records.....ooooooo....scary
posted @ Tuesday, June 21, 2005 1:21 PM | Feedback (7)
Database Design based on existing data
posted @ Monday, June 13, 2005 10:38 AM | Feedback (0)
SUBSTRING with Delimiters
posted @ Wednesday, June 08, 2005 12:32 PM | Feedback (1)
Fun with Dates (Date Conversion examples)
posted @ Thursday, June 02, 2005 12:07 PM | Feedback (23)
Remove a User From All Databases on a server
posted @ Monday, May 23, 2005 2:57 PM | Feedback (1)
Weekends, Holidays and other reasons to Party
posted @ Thursday, May 12, 2005 2:36 PM | Feedback (11)
Find a word in a string
posted @ Monday, May 09, 2005 3:51 PM | Feedback (4)
Object Dependency Hierarchal Relationships
posted @ Thursday, April 28, 2005 3:06 PM | Feedback (2)
Error = [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'DESC'.
posted @ Monday, April 25, 2005 9:04 AM | Feedback (10)
CREATE TYPE2 UNIQUE WHERE NULL INDEX
posted @ Wednesday, April 20, 2005 1:23 PM | Feedback (3)
DTS too hard to export data (How to export a table with a header using bcp)
posted @ Wednesday, April 13, 2005 3:07 PM | Feedback (3)
New twist on Delimited string per ID using many columns...AND this time into a table
posted @ Wednesday, February 23, 2005 3:30 PM | Feedback (0)
Show me The TOP n Number of things based on a key
posted @ Thursday, February 10, 2005 10:02 AM | Feedback (3)
How do I search a database for the umpteenth time
posted @ Tuesday, February 08, 2005 1:20 PM | Feedback (4)
Mimic Oracles INSTR Function
posted @ Wednesday, February 02, 2005 1:03 PM | Feedback (11)
But MOM! Do I have to use sp_executesql
posted @ Thursday, January 27, 2005 10:13 AM | Feedback (6)
Search SQL Server for a table in any databse
posted @ Thursday, January 13, 2005 12:03 PM | Feedback (5)
Build a Comma Delemited String For All Rows
posted @ Wednesday, January 05, 2005 2:22 PM | Feedback (4)
Real World SQL Server Disaster Recovery
posted @ Tuesday, December 21, 2004 12:36 PM | Feedback (3)
Weekend and Holidaze
posted @ Monday, December 20, 2004 1:17 PM | Feedback (0)
What Happened to my DATA?!?!!?!?!?
posted @ Wednesday, October 20, 2004 3:39 PM | Feedback (2)
Bi-Directional Updates - No Thanks
posted @ Tuesday, September 21, 2004 1:20 PM | Feedback (3)
A "Non IDENTITY" IDENTITY Column
posted @ Tuesday, June 29, 2004 1:55 PM | Feedback (0)
SQL SERVER TOP 10
posted @ Friday, June 18, 2004 11:30 AM | Feedback (2)
Export out entire database
posted @ Thursday, June 17, 2004 2:16 PM | Feedback (8)
Computed Columns? Worth their Salt?
posted @ Wednesday, June 16, 2004 8:59 AM | Feedback (8)
Surrogate Keys….The Devil’s spawn (OK Not really)
posted @ Wednesday, June 09, 2004 11:02 AM | Feedback (26)
TQL?
posted @ Tuesday, May 25, 2004 10:19 AM | Feedback (9)
Dynamic Predicates?
posted @ Wednesday, May 05, 2004 3:27 PM | Feedback (6)
Deltas
posted @ Friday, April 23, 2004 11:49 AM | Feedback (0)
Reasons to not use SELECT * (and when to use it)
posted @ Thursday, April 22, 2004 11:00 AM | Feedback (6)
Sanitize input files
posted @ Tuesday, March 23, 2004 9:02 AM | Feedback (0)
The Interview
posted @ Thursday, February 12, 2004 1:56 PM | Feedback (10)
Interogate Sprocs
posted @ Thursday, February 05, 2004 2:12 PM | Feedback (13)