T-SQL Tuesday #025: Trick or ...?

13 December 2011 by Bob Pusateri in SQL Server , SQLServerPedia Syndication , TSQL Tuesday with one comment

This month’s T-SQL Tuesday is hosted by Allen White (blog | @SQLRunr) and is an invitation to show off a nifty T-SQL trick you use to make your job easier. Here’s one of my favorites as of late:

Some of the source systems we copy from shard their data across multiple similar tables. For [...]

One comment

T-SQL Tuesday #24: Functions v. Procedures

8 November 2011 by Bob Pusateri in SQL Server , TSQL Tuesday with zero comments

This month bring us the 24th edition of T-SQL Tuesday (24 already? wow….). This time around our topic comes from Brad Schulz (blog) and has to do with stored procedures and functions. Brad’s asking us to write whatever we’d like about either of them.

While from the bird’s-eye view both functions (the table-valued [...]

Leave a comment

T-SQL Tuesday #23: WHERE The JOIN Ends

4 October 2011 by Bob Pusateri in SQLServerPedia Syndication , TSQL Tuesday with 2 comments

This month’s T-SQL Tuesday topic comes to us courtesy of Stuart Ainsworth (blog|@codegumbo), and is early due to the PASS Summit being next week. Perhaps those planning next year’s summit will do a better job to make sure they don’t interfere with any blogging parties :)

Stuart’s topic for the month is joins, [...]

2 comments

T-SQL Tuesday #22: Pseudo-XML

13 September 2011 by Bob Pusateri in TSQL Tuesday with 3 comments

This month the 22nd T-SQL Tuesday comes to us courtesy of Robert Pearl (blog | @PearlKnows), and he’s asking us to write about formatting data for presentation to end users. He describes end-users as “boss, supervisor, department head, the analyst, employees, or customers”. I’m going to take the liberty of extending this to [...]

3 comments

T-SQL Tuesday #21: Bad Decisions

9 August 2011 by Bob Pusateri in SQL Server , SQLServerPedia Syndication , TSQL Tuesday with zero comments

Howdy folks and Happy T-SQL Tuesday Wednesday! Contrary to popular belief, both myself and my blog are not dead, it’s just that preparations for my upcoming wedding have taken up nearly all of my spare time. Once I return from my honeymoon I hope to be back to blogging as usual!

This month’s topic [...]

Leave a comment
 
  Older Entries »