There's such a thing as oversimplifying if you're going to do something...

david.milburn (12/1/2010)

---

I'm setting up a new SQL Server 2008 database. I've got one huge table (around 100 million records) and other tables that I'll link to this huge table.

Questions:

1) Can...

Definately new column then...

If I take the suggestion of adding another...

Hey, if anyone's got a disconnected sandbox they can test someone's code in, this person could use some help:

http://www.sqlservercentral.com/Forums/Topic1028937-149-1.aspx?Update=1

I don't have access to anything I can reinstall at whim and...

artan_p (12/1/2010)

---

I have attached the db file and I reconfigure the application to connect to new server, It says login OK but it does not fill with DATA the Report.

...

Did...

James, has opening a dialog ever helped me... in a word: No.

It will, of course, depend highly on your management, but the higher up management you go the more likely...

rockingleo (12/1/2010)

---

1) since first snapshot will push around 1 TB of data. Is it fine to use snapshop process for initialization . I hope their will not be any timeouts...

Couple of 'Is it plugged in' questions here.

1) Client is onsite, not at a different location, correct? (Wrong server, or bad params for data)

2) You both look at the...

Be careful with the above code, you want to make sure you using spacing well, and you'll want to invert the subset choices.

For example:

DECLARE @CustomerName VARCHAR(100)

SET @CustomerName = 'Bob Jocos...

Hey Alen, I know it's just an doublecheck, but the histogram above shows me something different then I...

Stefan Krzywicki (12/1/2010)

---

Yes, I know, that's what I'm saying. I was trying to restate the NOT LIKE '%[^0--9]%' in english descriptions that would clarify for me exactly what it is...

We'd need to see the code for the trigger and the stored proc to help you with this.

FYI, works better like this:

Hierarchy - Fixed depth

Global (75)

US (85)

Industry (82)

Sub-industry (null)

...

You mention Activity isn't static, that's going to cause some headaches. Am I correct in assuming LEAVE is always static, but the rest of activity is things like "Modified...

jcrawf02 (11/29/2010)

---

Craig Farrell (11/29/2010)

---

Side note, I live in a desert, in a place called 'Valley of the Sun'.

Global warming my arse. I think I just frosted my toes off...