Good question, thanks. It is good to be reminded of the default length issues.

Cheers

Thank you Gail :).

Cheers

Istvan

Hi,

The snapshot isolation sounds very cool. I have never actually seen it in action in live systems. I think it must put an incredible pressure on tempdb as all the...

Hi,

Yes you are on the right track, another way to put it is:

([Gender]=="M"?"Male" : ([Gender]=="Male"?"Male" : ([Gender]=="Boy"?"Male" : ([Gender]=="B"?"Male" : "Female"))))

However this is a bit messy and not completely secure....

Hi,

You could use the Derived Column transformation in Data Flow to achieve this.

Regards

Istvan

Hi, yes selective queries will certainly suffer as the data grows in an unindexed table. So if you have no indexes yet, you should definitely consider creating some.

For more detailed...

Hi,

I have had same problem as you a couple of moths ago. As i wasn't really content with intellisense anyway, i looked for an alternative and i found SQL Complete[/url]...

I agree with both comments of Jeff, i just picked first sys table that came to my mind, sys.all_columns seems a much better joice.

I agree also that using a Tally...

Here is an other suggestion:

DECLARE @incr_step float = 0.68

SELECT nbr, nbr*@incr_step from

(

select TOP 100 row_number() OVER(ORDER BY (SELECT 1)) as nbr

from sys.columns a cross JOIN sys.columns b) as q

add appropriate...

This should work too.

SELECT mil.date_firm_commitment

, mil.fk_fha_number

FROM mf_insured_loan mil

WHERE NOT EXISTS (

SELECT *

FROM F47FirmCommitment FC

WHERE FC.FHACaseNumber = mil.fk_fha_number

)

Good question!

The following discussion is making it even better. We should be careful when using exact numeric data types both from the point of view of storing and calculations.

Thanks

Great question! I had the wrong answer, but learned something today 🙂

Cheers

sknox (4/26/2011)

---

Very good question.

I think the reason this works is that the NULL in the CREATE TABLE is an attribute of the column (since NULL is actually just a...

I answered "None of the above". After getting the explanation I still claim I answered right. The question was "... how many rows are gauranteed ...", so answer "Any of...

The link in the explanation (http://msdn.microsoft.com/en-us/library/ff647793.aspx) says:

"This content is outdated and is no longer being maintained. It is provided as a courtesy for individuals who are still using these technologies."

Boy...