First, you really need to think about breaking this down and hiring someone with experience. I understand the boss might not want to do that, but perhaps you can collect...

You'll have to test things. There isn't a way to be sure what's best, but here are a few suggestions. Note that the "view" isn't run, but incorporated into the...

Do...

I'd argue that SQL needs a replacement, or that RDBMSes are fundamentally flawed. They have fueled and supported a tremendous data explosion and amazing amount of business.

That being said, they...

It's been fun, watching the wins over the weekend. Would be better if we could harass each other in the hallways, but it's still fun.

Suppose you had created a column with the name "desc" as in

Create Table Customer

( CustomerID int

, CustomerName varchar(100)

, Desc varchar(max)

)

If you wanted to select the data

SELECT

CustomerID

, CustomerName

,...

Well, Johan is leading the way. Not quite running away but with 3 teams and 9 points, he is in good shape. The standings

Johan, 9 pts, 3 teams

Bradley, 8 pts,...

Is this with shrinkdatabase or shrinkfile?

Following

phelmer (3/18/2011)

---

HIPAA and, to a much lesser extent, PCI are what we have to comply with. The approach we took was to actually turn it into a competitive advantage of...

Does this help?

http://www.rafael-salas.com/2010/01/ssis-loop-through-multiple-database.html

You'll have to show some code and execution plans here, but in general, you want to create indexes on the fields that are being joined and potentially the aggregates.

However the...

It shouldn't affect anything. This is a meta data change that takes a shared lock on the database, but it should not affect any transactions

Red Gate's SQL Compare will not do this. It looks at the tables, but I'll ask and see if there's an option, or file a bug.

Disclosure: I work for Red...

I'm knocking off, but here are the first two days results as of now (5pm MST)

Johan: 4, 1 team gone, 3 left to play today

Allen: 3, 3 teams gone, 2,...