Sign in or Join FriendFeed
FriendFeed is the easiest way to share online. Learn more »
Rob Boek

Rob Boek

SQL Server Database Developer/Administrator in Portland, OR.
The Arizona students who climbed down to the sidelines must feel a little stupid right now. Go Ducks!
The Arizona students who climbed down to the sidelines must feel a little stupid right now. Go Ducks!
A collection of anonymously contributed client horror stories from designers. - Rob Boek
Understanding Transaction Isolation Levels in SQL Server - http://www.sqlpointers.com/2009...
Want To Try Out Google Chrome OS For Yourself? Here’s How. - http://www.techcrunch.com/2009...
Christian Bolton on SQL Server memory - http://www.brentozar.com/archive...
Fiddler Web Debugger - A free web debugging tool - http://www.fiddler2.com/fiddler...
What do you think about transactional replication to partition a 20TB table? Separate tables that match prtn scheme then switch and rename.
Sabina Stobrawe: Divorce lift - http://adsoftheworld.com/media...
@pilotbob IN gets rewritten by the optimizer as a series of ORs. When to switch depends on a lot of things. It's worth testing at 4-5+
May 22, 2010: SQL Saturday #27 at University of Portland - http://upcoming.yahoo.com/event...
Map
@pilotbob If you have a lot of items, using JOIN join or EXISTS against a table is better than IN. Consider adding an index to a temp table.
@pilotbob literals in an IN list are limited by the batch size. An alternative is to use a table variable and IN (SELECT id FROM @table).
#PDC09 sessions are online and available to all. Here's "Data Programming and Modeling for the .NET Dev" http://microsoftpdc.com/Session...
Flowchart Helps You Determine What Crap to Eat - http://newyork.grubstreet.com/2009...
@DBAishness At least it looks like it will be in SQL11. Should save a few steps in the cluster automated build process.
@billgraziano remember talking about #sqlpass attendees getting netbooks? Look what the #PDX09'ers get: http://microsoftpdc.com/tablet
Just subscribed to @DBAishness's blog (http://littlekendra.com) and added it to my list of SQL Server blogs: http://robboek.com/2009...
@DBAishness Any particular reason you want to use a guid?
@blythemorrow I think they (databases) can sense fear from the rhythms in your typing - and the keyboard to mouse click ratio.
OH @donbox: Love the database! The database loves you! Do not fear it! It senses fear!
I *love* that chrome lets you detach a browser tab and video keeps playing without a hitch.
RT @mithund: Get $10 from Bing Cashback - http://www.discoverbing.com/cashbac...
Downloading the SQL Server Modeling CTP - Nov 2009 http://www.microsoft.com/downloa...
It's got a long way to go for that. RT @occulto: @robboek And Quadrant will be the death of SQL Server Management Studio :) #sqlmodeling
RT @vstuart: M. SQL, tree view of data, test data, and schema diagram all in one screen in Quadrant. Very nice #sqlmodeling #pdc09
Interesting... RT @occulto: M will be the death of DDL in SQL Server #sqlmodeling #pdc09
RT @vstuart: Doug & Chris have replaced audience questions with random tweets in #sqlmodeling -- Hopefully they will tweet the answers too.
@unclebiguns 1st, to get consistent results with TOP, you need an ORDER BY. 2nd, NOLOCK will return dirty records if they exist.
Other ways to read this feed:Feed readerFacebook