Showing posts with label Tips and Tricks. Show all posts
Showing posts with label Tips and Tricks. Show all posts
Thursday, July 13, 2017

SSMS: When did the query finish, when did the query start?

›
This is a quick post but it might be an item you can add to your Today I Learned list  :-) Let's say you get to a SSMS query window ...
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...