Well ..... since companies are currently experiencing the impact of the financial blunders all over the world....

They are prepared to take the risk !

The gamble is to see if...

euhm...

I would miss a declare statement !

Declare @BuildID integer

SELECT @BuildID = select top 1 BuildID

FROM Builds_LIVE

WHERE BranchID = @BranchID

AND ProductID = @ProductID

--if found

IF @@ROWCOUNT > 0

...

What I like most is that at SSC it is all being presented "feet on the ground" and open minded.

It did start its life from within the target public, attracted...

Coyote Blue (11/27/2008)

I have seen many people; with lots of letters after thier names, including VP and/or DIR, that do not understand the difference between a physically separate drive and...

btw:

Did anyone ever test the "ok i will determine the max value myself and add 1" .... and conclude sqlserver actually performs a FULL TABLE SCAN to resolve it.

afaik DB2...

FYI :

http://www.simple-talk.com/community/blogs/tony_davis/archive/2008/11/25/70602.aspx

http://www.simple-talk.com/sql/t-sql-programming/unique-experiences!/

Coyote Blue (11/26/2008)

My 2cents: Make sure it is actually a physically separate drive, and not just a drive partition on the same physical drive. My experience has been that you...

This may clarify a bit regarding surrogate keys:

http://www.intelligententerprise.com/channels/business_intelligence/showArticle.jhtml?articleID=201806814

I guess we all need to do what I did today .... have a day off :w00t:

I followed a "refresh" day of CPR for human victims this time.

It cleared the...

You can change min and max whilst your instance is online.

You'll see its actual impact after issuing a system checkpoint.

but if you're going to use maint plans, apply at least CU2 (current = CU10 and sp3 is in public beta)

For the moment we apply CU10 for new installations. (didn't...

- try to keep a primary key column meaningless, you'll not have to modify (datatype/length) it during the lifetime of the database. (var)Char always tend to get meaningfull after a...

well .... Kalen has great info on it ...

http://sqlblog.com/blogs/kalen_delaney/archive/2008/11/24/change-a-column-in-an-index-from-a-key-column-to-an-included-column.aspx

another reason to avoid functions as much as possible.

In many cases they can be replaced by another form of joins and that explicitely point to one of the biggest dangers...

Rubbish in .... rubbish out :unsure:

As in many cases, providing exactly what you need may get your problem(s) solved much...