Browse by Tags

• Functions
• Gotcha
• logging
• Productivity
• Shortcut
• sqL Server 2000
• SQL Server 2005
• SQL Server 2008
• Tip

• SQL Server 2008 Management Studio tip: Status Bar Custom Colors

  Joni Moilanen has a very nice tip about how you can use custom colors in the status bar so that you don't truncate that production table yet again :-) Check it out here: http://blog.jemm.net/2008/08/12/sql-server-2008-management-studio-tip-status-bar-custom-colors Read More... Posted Wednesday, August 13, 2008 4:59 PM by Denis Gobo | 0 Comments Filed under: SQL Server 2008, Tips and Tricks

• SQL Tip, Compiling Your SQL Without Running It To See If It Would Run

  Let's say you have a big SQL script with a ton of code and you want to make sure it runs but you don't want to execute it because it updates tables, deletes data etc etc. Take this simple example SELECT GETDATE () GO SELECT 1 / asasasas GO You can probably Read More... Posted Wednesday, August 13, 2008 12:19 PM by Denis Gobo | 3 Comments Filed under: Tips and Tricks

• How to log when a function is called?

  This question came up today and here is one way of doing it. It requires running xp_cmdshell so this is probably not such a good idea. The problem with functions is that you cannot just insert into any table. INSERT, UPDATE, and DELETE statements modifying Read More... Posted Thursday, May 08, 2008 2:25 PM by Denis Gobo | 3 Comments Filed under: Functions, logging, Tips and Tricks

• Do you depend on sp_depends (no pun intended)

  I answered this question on the MSDN forums: How can I search all my sprocs to see if any use a function? Several people suggested using sp_depends. You can't really depend on sp_depends because of deferred name resolution. Take a look at this First create Read More... Posted Tuesday, May 06, 2008 1:50 PM by Denis Gobo | 1 Comments Filed under: Gotcha, Tips and Tricks

• How To Use COALESCE And NULLIF To Prevent Updating Columns When A Parameter IS NULL Or A Default Value

  A variation of this question popped up twice in the SQL programming newsgroup since yesterday, this means it is time for a blogpost. Let's say you have a proc like this CREATE PROC prUpdateTable @Salesman int = - 1 AS .......... If the user calls the Read More... Posted Friday, March 28, 2008 11:43 AM by Denis Gobo | 4 Comments Filed under: Tips and Tricks

• Tip: Find all The Rows Where Any Of The Columns Is Null Or Zero Or Both

  This question is asked every now and then so I decided to do a little blog post. How can you quickly without writing a bunch of OR statements determince if any columns have a NULL value, a value of 0 or if the value is 0 or NULL? To test for NULL is very Read More... Posted Friday, January 25, 2008 4:22 PM by Denis Gobo | 13 Comments Filed under: Tips and Tricks

• Use the *1 trick to do math with two varchars

  Someone had code like this on the tek-tips forum DECLARE @v varchar ( 24 ) SELECT @v = '06029202400250029' SELECT RIGHT( @v , 4 ) - SUBSTRING ( @v , 10 , 4 ) If you run this code, you will get the following message Server: Msg 403, Level 16, State 1, Read More... Posted Wednesday, January 02, 2008 5:21 PM by Denis Gobo | 7 Comments Filed under: Tips and Tricks

• Increase Your Productivity With Query Analyzer/SQL Server Management Studio

  Drag And Drop Column Names In Query Analyzer you can save a lot of time by using this trick instead of typing all the column names of a table Hit F8, this will open Object Browser Navigate to DatabaseName/TableName/Columns Click on the column folder and Read More... Posted Monday, September 24, 2007 12:52 PM by Denis Gobo | 5 Comments Filed under: Productivity, Shortcut, sqL Server 2000, SQL Server 2005, SQL Server 2008, Tip, Tips and Tricks