I used to love reading BOFH back when I did tech support for a major telephone company that currently employs Luke Wilson.

I think the PFY would have added that security...

NULL means the absense of a value....

NULL means NULL.

NULL does not equal NULL which is very different statement from means.

Lynn Pettis (1/20/2010)

---

To all those who are expecting PRECISELY CORRECT ANSWERS, how about putting yourself out there and submit some questions. The answers may not have been precise, but...

hydbadrose (1/18/2010)

---

Do we need to restart the Sql Server /Agent, when you change the Max memory , Min memory , Min Memory per query , Set the fill factor to...

TheSQLGuru (1/18/2010)

---

I fall squarely in the use the right tool for the job camp. And if I decide that a GOTO is the right tool for the job, that...

There is a performance gain by using the NOT EXISTS.

With NOT EXISTS, SQL Server will stop looking for any record matches after it finds the first one.

By using a count(*),...

There are tons of user groups and other learning events for other technology or programming languages, but not for SQL.

It seems that there are only two, PASS and SQL Connect.

I...

I'm at a bit of a loss...

I have years of VB experience and now I code all day long in SQL Stored Procedures. I have never found a reason...

bwillsie-842793 (1/14/2010)

---

Too bad they don't build some business logic and rules into their "Is your computer plugged in" checklists.

Weight the responses properly against the rules and they should come up...

mtassin (1/14/2010)

---

Seeing as this is in the SQL 2k5 forum.

Personally if you have the time, I'd look at converting the GOTO's to TRY/CATCH blocks.

Just so much simpler to be able...

I hope I haven't come across as a fruitcake here. I don't think the laptop is a bad product. It's had minor issues, but they haven't been that big a...

That'a a very good idea! (This is one of those, why didn't I think of that moments!)

The last function I wrote this week, I needed the last location in a...

Better yet, try playing around with something like this:

if 'asdf ssdfasf' like '% %' select 'hi!'

So much for all my beautiful tabs to make it more readable!

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

CREATE FUNCTION [dbo].[udf_contains_spaces] (@String VARCHAR (500))

RETURNS CHAR (1) AS

BEGIN

DECLARE @LenAS INT

DECLARE @ExitAS CHAR (1)

DECLARE @FoundAS CHAR (1)

DECLARE @LocAS INT

SET @Len= LEN(@String)

SET...