Jeff Moden (6/3/2010)

---

Steve Jones - Editor (6/1/2010)

---

There are quite a few people here with Oracle skills, including Jeff. I'm not sure Jeff wants to help with Oracle, but worth a...

Saw this, interesting. Outsourcers hurt by recession, might not come back as strong.

http://itmanagement.earthweb.com/features/article.php/3885751/IT-Outsourcing-Trends-Slow-Growth-Cloud-Computing.htm

I have done separation like this, vertical partitioning for some data. I don't see an issue with it, and like Jeffrey, I wouldn't add an identity to this. I'd just...

This says it's possible: http://msdn.microsoft.com/en-US/library/ms143393%28v=SQL.90%29.aspx

I believe you run setup and pick upgrade and select your instance. Note that not all features in Dev edition are in Standard. You might have...

I agree, if you want to defend your decisions, you need reasons. I'll say I've defended a practice multiple times to new people, and eventually started telling people that "we...

It's always a balance, right? Sometimes the old ways work well and changing for the sake of change isn't worth it. Sometimes you need to move on.

It's a question of...

The open space might not work for you, but it's worked well for me at times. It's not completely unproductive. Joel thinks so, and they built their space differently: http://www.joelonsoftware.com/articles/BionicOffice.html

However...

I'm with the Ninja, why not just batch delete. If you ran this every night, you could end up deleting 1000 a night instead of trying to do 30,000 once...

A firewall is a wall with holes in it. The holes are there deliberately, left to open certain things up to pass through. For example, the firewall I have for...

Sample

CREATE TABLE MyNewTable

( id INT

, mychar CHAR(1))

GO

INSERT MyNewTable SELECT 1, 'A'

go

CREATE TABLE MyOldTable

( id INT

, mychar CHAR(1))

GO

INSERT MyOldTable SELECT 1, 'A'

INSERT MyOldTable SELECT 2, 'B'

INSERT MyOldTable SELECT 3, 'C'

INSERT MyOldTable...

I heard today that by Q4 of 2010 we can expect SP4 for SQL Server 2005, so there is work being done.

Extended Support requires a contract with MS and costs...

Poster: I downloaded a script and it doesn't work. I made a change and have this error "Must declare variable @SomeRandomVar"

Me: It's a syntax error. You must have typo'd a...

Those are still syntax errors. They say that the variable hasn't been declared. Somewhere either the declaration is wrong or the use of the variable has the name typed incorrectly.

Those are syntax errors. You have mistyped something.

Hmm, this thread like cat litter....maybe I can get an analogy there.

Actually this thread provides me with alternating periods of confusion, information, and entertainment.