weblogs.sqlteam.com
Some Simple SQL Rules to Live By
http://weblogs.sqlteam.com/jeffs/archive/2006/03/14/9289.aspx
Jeff's SQL Server Blog. Random Thoughts and Cartesian Products with Microsoft SQL Server. Posts - 155, comments - 2679, trackbacks - 64. Welcome to my weblog. My name is Jeff Smith, I am software developer in Boston, MA and I was recently named a 2009 SQL Server MVP. Check in frequently for tips, tricks, commentary and ideas on SQL Server and .NET programming. May, 2012 (1). August, 2010 (1). October, 2009 (1). December, 2008 (1). October, 2008 (2). August, 2008 (3). July, 2008 (3). June, 2008 (3). Most ...
sqlpointers.com
SQL Garbage Collector: February 2013
http://www.sqlpointers.com/2013_02_01_archive.html
Collecting SQL pointers . . . Feb 27, 2013. SQL to ECL - Metamorphosis. As the old saying goes, it can be figured out whether you are a data guy or not just by the way you solve the problem:. An imperative programmer goes: for each order in the orders table, find the corresponding order details. . . And the SQL programmer goes: take the orders table and join with the order details on the order ID key. . . Now, ECL is not SQL but has the SQL programming style. Something that produces an output. By signing...
sqlpointers.com
SQL Garbage Collector: April 2010
http://www.sqlpointers.com/2010_04_01_archive.html
Collecting SQL pointers . . . Apr 16, 2010. Custom SQL Stored Procedure Best Practices Analyzer - SQL Cop, Maybe? Recently, I moved to Seattle as a Data Architect for a product our company was developing. I also started taking up most of the DBX roles in that project. Pass time with SQL. Subscribe to: Posts (Atom). View my complete profile. FAQs and not so FAQs. Pass time with SQL. Fun with SQL - Puzzles. 01 - Get Random Records. 02 - Find Maximum Value. 03 - Find Intermediate Value.
sqlpointers.com
SQL Garbage Collector: November 2009
http://www.sqlpointers.com/2009_11_01_archive.html
Collecting SQL pointers . . . Nov 14, 2009. Solving Sudoku using SQL Server 2005 - Step by Step - Part #6. This is the last post in this series. Is the last one that tries to solve the puzzle logically. This one will take the latest unsolved sudoku board that we get after running through the first three algorithms and use brute force to solve the puzzle. I am not going to reinvent the wheel here. Labels: Pass time with SQL. Solving Sudoku using SQL Server 2005 - Step by Step - Part #5. Nov 12, 2009.
sqlpointers.com
SQL Garbage Collector: Custom SQL Stored Procedure Best Practices Analyzer - SQL Cop, Maybe?
http://www.sqlpointers.com/2010/04/custom-sql-stored-procedure-best.html
Collecting SQL pointers . . . Apr 16, 2010. Custom SQL Stored Procedure Best Practices Analyzer - SQL Cop, Maybe? Recently, I moved to Seattle as a Data Architect for a product our company was developing. I also started taking up most of the DBX roles in that project. To start with, I wanted the validation to be done on 4 entities. We will be doing 3 types of validations on the entities:. 1 Verify that entity contains a specific text. 2 Verify that entity doesn't contain a specific text. 4 The administra...
sqlpointers.com
SQL Garbage Collector: Solving Sudoku using SQL Server 2005 - Step by Step - Part #4
http://www.sqlpointers.com/2009/11/solving-sudoku-using-sql-server-2005_14.html
Collecting SQL pointers . . . Nov 14, 2009. Solving Sudoku using SQL Server 2005 - Step by Step - Part #4. In previous post of this series. The next algorithm is the implementation of Solve Method A from sudoku solver. In this algorithm, we check all the cells (having mutiple values) in each row and see if a particular value occurs only once in that row. Then update that as the solution for the cell having that value. We do the similar check for column and the 3X3 block. For the next algorithm. 07 - Sear...
sqlpointers.com
SQL Garbage Collector: March 2010
http://www.sqlpointers.com/2010_03_01_archive.html
Collecting SQL pointers . . . Mar 14, 2010. A Scenario to Ponder #16. During my school days, I used to play this game that I would call as word mutation. The problem statement gives the starting and ending 4-letter words. The game is to find the path from the starting to the ending word by changing one alphabet at a time and ,of course, each of the words in the path should be a valid word. Subscribe to: Posts (Atom). View my complete profile. FAQs and not so FAQs. Pass time with SQL.
sqlpointers.com
SQL Garbage Collector: Solving Sudoku using SQL Server 2005 - Step by Step - Part #5
http://www.sqlpointers.com/2009/11/solving-sudoku-using-sql-server-2005_7764.html
Collecting SQL pointers . . . Nov 14, 2009. Solving Sudoku using SQL Server 2005 - Step by Step - Part #5. That we implemented was able to solve an easy puzzle. Now, lets take a hard one and see if the solution we have built till now in this series. EXEC SolveSudoku '030,001,000, 006,000,050, 500,000,983, 080,006,302, 000,050,000, 903,800,060, 714,000,009, 020,000,800, 000,400,030'. Post-solve sudoku board - before implementing algorithm 3. Post-solve solution board - before implementing algorithm 3.
sqlpointers.com
SQL Garbage Collector: December 2006
http://www.sqlpointers.com/2006_12_01_archive.html
Collecting SQL pointers . . . Dec 4, 2006. Obvious SQL Tip #2. The thought process that goes into set- based programming is slightly different from writing procedural code. Say, I have 2 tables -one holding order header information and the other holding the details of the products ordered. I want to get the items ordered for all the orders:. The procedural way of looking at it is for each order in the orders table get the order details from the [order details] table. Labels: FAQs and not so FAQs.