Geeks With Blogs

News Google

Nick Harrison Blog<Nick>.Next() SQL Tricks Various sql tips and tricks that I find useful
Why you Should be Using SQL Prompt!
You have probably seen this ad floating around the Internet. Probably see it on this very blog. If you are already familiar with this wonderful tool, the ad makes perfect sense to you. SQL Prompt is to Management Studio as Reshaper is to Visual Studio. Actually, the difference is even stronger. SQL Prompt is like upgrading from Notepad to Visual Studio. I was first drawn to the tool for the “Format SQL” options. Nicely formatted code is easier to understand. Once I got started, I found many other ......

Posted On Friday, February 1, 2013 10:57 AM

It's intellisense for SQL Server
It's intellisense for SQL Server Anyone who has ever worked with me heard me speak, or read any of writings knows that I am a HUGE fan of Reflector. By extension, I am a big fan of Red - Gate I have recently begun exploring some of their other offerings and came across this jewel. SQL Prompt is a plug in for Visual Studio and SQL Server Management Studio. It provides several tools to make dealing with SQL a little easier for your friendly neighborhood developer. When you a query window in a database, ......

Posted On Monday, March 29, 2010 2:38 AM

SQL Tips for Learning a New Database
SQL Tips for Learning a new Database The hardest part of writing SQL statements is in understanding the database that you are working with. The raw mechanics of SQL for the most part are fairly straight forward. Often times really complex SQL statements point to business logic showing up where it doesn’t belong. The hard part about learning a database is the lack of consistency and documentation. Data diagrams are often of little help. Diagrams are good for an overview and to get a list of tables, ......

Posted On Saturday, September 20, 2008 10:11 PM

"Flattening" a "deep" table
Have you ever been struck with a table design that did not work well for what you now needed? Sure, we all have. One common scenario is to have a table where all of the data that you need is in multiple records, but you need it returned in a single record. A common solution is to join the table to itself multiple times. Depending on the size of the table, this might work. Sadly this approach does not scale well. A more scalable solution would be to use grouping logic to get all of the data in a single ......

Posted On Thursday, November 24, 2005 7:09 PM

Copyright © Nick Harrison | Powered by: | Join free