Showing posts with label trick. Show all posts
Showing posts with label trick. 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...
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 ...
Monday, May 14, 2007

Make Your Case Sensitive Searches 1000 Times Faster

›
I had an case sensitive update query that ran in about 9 minutes. Since it was a case sensitive query it did an index scan not an index seek...
4 comments:
Monday, May 07, 2007

Three Ways To Return All Rows That Contain Uppercase Characters Only

›
How do you select all the rows that contain uppercase characters only? There sre three ways to do this 1 Compare with BINARY_CHECKSUM 2 Use ...
2 comments:
Wednesday, March 14, 2007

How To Get The Database Name For The Current User Process

›
This question pops up frequent enough so here are 4 ways to return the database name for the current user process First up is the fastest me...
1 comment:
Monday, March 05, 2007

ASP.NET Library Site Launched

›
A friend of mine has started the ASP.NET Library site. The idea of this site is to provide ASP.NET articles, code and tips for professional...
Friday, February 09, 2007

Use A Combination OF NULLIF and COALESCE TO Display A Custom Value

›
Let's you inherit a table with a column that can contain blanks, empty strings or NULL values. I am saying inherit because surely you wo...
Monday, January 29, 2007

How To Restart A Remote Computer

›
Sometimes you have to login to your work PC from home over the VPN and after a while for some reason or another you want to restart your PC....
4 comments:
Monday, December 12, 2005

Fun With SQL Server Update Triggers

›
Below is some code that will show how to test for updated field values in an update trigger. As you can see the IF UPDATE (field) is true ev...