Sol 3

Browse by Tags

• ASPInsider
• Code
• Hyper Threading
• LINQ
• Oracle
• XML

• SQL Not In Revisited

  I always seem to struggle with a NOT IN clause when there are more than one column to compare.  This, of course, comes up when I am trying to get records from one set that are NOT IN another set and the comparison has to be done across multiple columns.  Read More... Posted Wednesday, August 27, 2008 11:52 AM by Keith Barrows | 1 Comments

• SQL XML - TreeView

  I sometimes forget how to do an XML output formed in a tree when dealing with a single table parent/child relationship.  There is a great explanation on SQL Server Central on *how* to do this .  I am mainly capturing the link and the SQL I just Read More... Posted Monday, August 25, 2008 4:52 PM by Keith Barrows | 1 Comments Filed under: SQL, XML

• SELECT TOP [x] Records

  When you use one database platform long enough you start to think everything you do is ANSI SQL-92 compliant. Until you switch database platforms that is! Then you find the simple things no longer work. Take for example the TOP clause used so often in Read More... Posted Tuesday, April 10, 2007 9:16 AM by Keith Barrows | 0 Comments

• Hyper Threading, Sprocs and long query waits...

  I've not been burned (yet) but this tidbit needs some exposure. Michael K Campbell writes about his latest experiences with being burned by hyper threading on SQL 2000 . Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | live Read More... Posted Tuesday, February 13, 2007 1:03 PM by Keith Barrows | 0 Comments Filed under: SQL, Hyper Threading, ASPInsider

• SSIS references

  I've been searching around for info on SSIS and it is scarce! I've emailed quite a few people I know are in the SQL realms and so far this is the best I've gotten. I wanted to make sure I noted it down before I lost it. I've taken the liberty of paring Read More... Posted Wednesday, November 08, 2006 9:43 AM by Keith Barrows | 0 Comments

• SQL Server and Trees (or hierarchical data)

  I've been handling hierarchical data in SQL for many, many, many years now. About 6 years ago I came across some articles by a guy named Joe Celko . By numbering a left and right side to each node in a tree he describes a way to deal with hierachical Read More... Posted Wednesday, August 16, 2006 11:43 AM by Keith Barrows | 0 Comments Filed under: SQL

• LINQ

  If you've ever wanted to have more control than what the Filter object will give you, wanted more options for data containers and more flexibility for handling data the LINQ is for you. From the MSDN site for LINQ : The LINQ Project is a codename for Read More... Posted Tuesday, June 06, 2006 9:02 AM by Keith Barrows | 0 Comments

• Latest Red-Gate releases

  Red-Gate sent me this message a couple of days ago. It's a great package and I would highly suggest it to anyone doing more than 1 hour a week work on SQL Server! I wanted to let you know that we have just released version 5 of the SQL Bundle. This is Read More... Posted Saturday, April 08, 2006 12:21 AM by Keith Barrows | 0 Comments Filed under: SQL

• SQL Dependency Tracker Beta

  I got this in my email this morning. Simple Talk is the newsletter Red-Gate puts out. I am VERY interested in the SQL Dependency tool for the work I do on client sites. Since I usually come in somewhere mid-stream on many projects I have no up front knowledge Read More... Posted Wednesday, March 29, 2006 5:23 PM by Keith Barrows | 0 Comments

• SQL Express Database Instance Names

  I want to thank Scott for a great explanation on the naming of SQL Express Database Instances. This one has been bugging me and now that he clearly explains it , what a cinch! Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | Read More... Posted Tuesday, March 28, 2006 6:51 PM by Keith Barrows | 0 Comments Filed under: SQL

• SQL Server 2005: CLR Integration

  Are you kidding me? Spatial relationships as an example? I've been looking for ways to handle spatial data in SQL for several years. Read more here ... Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | live it! Read More... Posted Wednesday, March 15, 2006 9:34 PM by Keith Barrows | 0 Comments

• Microsoft releases preview of SP1 for SQL Server 2005

  Wow. MS is releasing its first CTP for SQL Server, ever. Find more info at the ComputerWorld site. When it is released it should be on the SQL site at Microsoft. Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | live it! Read More... Posted Wednesday, March 15, 2006 8:22 PM by Keith Barrows | 0 Comments Filed under: SQL

• Red-Gate - New Beta publically available

  I just got this letter in from Red-Gate today. I'll snip out the boring parts and let you at the juicy bits: I'm pleased to announce the first public beta of SQL Bundle 5. This includes new versions of SQL Compare and SQL Data Compare, featuring rewritten Read More... Posted Saturday, March 04, 2006 9:55 AM by Keith Barrows | 0 Comments

• Table Sizes

  Mike Campbell has a great little script for getting table sizes. At some point, soon, I'll be posting up all the tips-n-tricks I've used over the last 12 years of SQL Server use. You would be suprised how many are still valid! :) Share this post: email Read More... Posted Friday, February 24, 2006 6:27 PM by Keith Barrows | 0 Comments Filed under: SQL