Showing posts with label tip. Show all posts
Showing posts with label tip. Show all posts
Wednesday, August 13, 2008

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...
Wednesday, July 02, 2008

Awesome Collection Of ASP.NET Hacks, Tips and Tricks

›
We added a bunch of ASP.NET Hacks, Tips and Tricks we have the following categories 1 Applications 2 Caching 3 Controls 4 Database 5 Dates 6...
Thursday, June 26, 2008

Working On SQL Admin Hacks, Tips and Tricks

›
I haven't posted for a while because I have been working on SQL Admin Hacks, Tips and Tricks lately. it is still a work in progress but...
Thursday, May 08, 2008

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 ...
Tuesday, May 06, 2008

Do you depend on sp_depends (no pun intended)

›
HTML Source EditorWord wrap I answered this question on the MSDN forums: How can I search all my sprocs to see if any use a function? Severa...
Friday, March 28, 2008

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'...
Friday, January 25, 2008

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 statement...
Wednesday, January 02, 2008

Use the *1 trick to do math with two varchars, this prevents the Invalid operator for data type. Operator equals subtract,type equals varchar message

›
Someone had code like this on the tek-tips forum DECLARE @v varchar (24) SELECT @v = '06029202400250029' SELECT RIGHT (@v,4) - SU...
Tuesday, November 27, 2007

Integer Math In SQL Server

›
What do you think the following query will return in SQL Server? SELECT 3 / 2 If you said 1.5 then you are wrong! The correct answer is 1, ...
Tuesday, November 06, 2007

Return Null If A Value Is A Certain Value

›
You need to return NULL only if the value of your data is a certain value. How do you do this? There are three different ways. NULLIF DECLAR...
Friday, October 19, 2007

Sort Values Ascending But NULLS Last

›
This is a frequent request in newsgroups and fora. People want to sort the column in ascending order but don't want the NULLS at the beg...
Monday, September 10, 2007

SQL Gotcha: Do you know what data type is used when running ad-hoc queries?

›
This is for SQL Server 2000 only, SQL Server 2005 is a lot smarter which is another reason to upgrade. When running the following query you ...
Tuesday, July 31, 2007

Cannot resolve collation conflict for equal to operation.

›
You set up your linked server, you write a query which joins two tables, you execute the query and the error message is this Cannot resolve ...
Wednesday, June 06, 2007

How To Protect Yourself From Fat-Finger Sally, Crazy Bosses and Other SQL Villains

›
You all have been through this at least once in your life. In your shop there is this one person who likes to use Enterprise Manager as thei...
Wednesday, May 30, 2007

Speed Up Performance And Slash Your Table Size By 90% By Using Bitwise Logic

›
You have all seen websites where you can pick a bunch of categories by selection a bunch of check boxes. usually what you do is store those ...
1 comment: