Jeff Moden (4/18/2010)

---

I'm asking because I'd really like to quit.

And, you're correct. I quit twice for a year each and once for 3 months and not sure why...

[font="Courier New"]SELECT COFFEE FROM PROGRAMER.CUP[/font]

Msg 7342, Level 16, State1, Line 1

An unexpected NULL value was returned...

Programmer cannot continue.

It's dangerous to hit reply the first day back before getting enough coffee.

BOL...

Very interesting.

Declaring the decimal variables as DECIMAL(35,20) gives the correct result.

But declaring the decimal variables as DECIMAL(35,19) gives the rounded result.

It looks like BOL is wrong in Precision, Scale,...

Note: I am an old curmudgeon who speaks bluntly. Nothing that follows is a personal attack. I just see this as a teachable moment.

So:

Let me get this straight:

You stumbled over...

Disk usage

SQL Server is heavily disk bound, so solving disk bottlenecks can make a big difference. If you found memory shortages in the previous section, fix those first, because a...

I agree there is more to discuss. As BOL says:

Current identity value is set to the new_reseed_value. If no rows have been inserted to the table since it was created,...

With a little more research you would have found sys.sql_modules which has the advantage of the definition field being nvarchar(max) so sprocs > 8k do not need to be reassembled.

As...

It depends on who is asking what question. For example: a wrongfully terminated employee (Bob) is reinstated and his personnel record is supposed to be "cleared". If someone runs a...

If you are loading millions of rows you should use clustered indexes ONLY if the source data can be loaded in that order. Loading data into a table with a...

I agree with LutzM but lets try breaking this down a little:

Since many may not understand "non-SARGable" lets just put it this way:

If you put a column in a function...

To a certain extent any new feature, because we don't trust Microsoft to not pull the rug out from under us.

You mentioned "DTS lead to SSIS"

More like Microsoft threw DTS...

Caution:

Any null values returned by subquery or expression that are compared to test_expression using IN or NOT IN return UNKNOWN. Using null values in together with IN or NOT...

It shows how America-centric SQL programmers are.

1d4 means One Pound, Four Pence in England.

I stand corrected. I had tried a variety of numeric types, but not money.

I had not realized how forgiving...

Ummm... I think you missed where we discussed two commas in a row with no numbers

select isnumeric(',,')

-----------

1

(1 row(s)...