1. No, there are not restrictions to the number of statements for an IF block. Provided you use BEGIN and END if more than one statement is used.

2. I don't...

Jeff Moden (1/3/2008)

---

Not really a travesty, Molly... it just that some...

Just getting settled in now. I'll be better suited to give an answer/opinion in a week or so. 😀

Jeff Moden (12/31/2007)

---

Why on Earth would you want to generate a Billion sequential numbers? That will take 8 gigabytes of space all by itself... it is not practical to...

Great article Buck, and it couldn't be more timely for me. I just ended a SQL Development position and am going to start my first "DBA" position next week. You...

Well if you restrict your updates by state and have the state column indexed, i believe the updates will take just as long as if you had them in separate...

Yes, and place an index on the State column. There's jus no logical reason that i can think of to seperate the data when it's all related. I can see...

No problem Jeff! I'm really starting to se the true value of the Tally table BTW.. 😀

Hey, you never answered my PM.

Thanks, After 5 years of heavy development and studying and a tad of admin I'm off to my first DBA position. It's still going to be heavy development, but more...

Jeff, thank you, that's perfect! that makes this day that much better, cause now I can go home. 😀

That only get s part of it....

Matt Miller (12/21/2007)

---

Not quite sure I understood. You have an activity called billable time, and then you have 2 columns called billable/non-billable?

What happens if the Billable time has something in...

I thought Mr. Moden...

Yes, you can revert back at any time. Whether your data's integrity has been violated is still another question.

I could have sworn that there is/was an upgrade compatibility wizard, but...

Sure,

DECLARE @String NVARCHAR(4000)

SET @String = 'SQLSERVERCENTRAL'

SELECT

item, COUNT(*)

FROM

(SELECT

-- this will get the specific...