The article is an interesting, alternate look at indexing. Your strategy is about indexing for performance, and I guess I recognise that that need can vary with the same...

I'm not sure if I already said this in the thread, and it's a minor point, but I am not sure that int is the best thing about SQL Server...

Incidentally I recently created a view around OPENQUERY() - data coming from a linked server. Which may have been not the best way to do what I was doing....

Dream Weaver (10/5/2009)

---

How can we create or evolve into an Agile organization (of which IT is a part)? A lot of the Agile signatories are working on this but...

I assumed that was why you didn't jump on the "we got to the Moon no...

bob.willsie (10/1/2009)

---

I'll give you an example. Our company has an "IT Steering committee." It consists of top level executives and the IT department heads.

When a suggestion was recently...

jcrawf02 (10/1/2009)

---

Phil Factor (10/1/2009)

---

If you're building a vehicle for human space flight or a nuclear reactor, the first choice is more likely to yield fewer dead astronauts and giant holes...

Some businesses at least have legal bounds on their information systems, such that software development either in a hurry or by non-specialists can get you into trouble. For instance...

So they know the user name to attack is "sa". Big deal. If God wanted to make your life harder and he gave the first two letters of...

I suppose you could pass the database name as another parameter. I'm not sure what happens with a temporary stored procedure that looks in local-database objects if you try...

So that's what extended attributes are for,...

I need to read this article carefully, but my immediate reaction is that the indexes that aren't used or don't even exist are the ones that should be considered for...

I agree with the comment that before or during your migration is NOT the time to look for stuff that appears to be redundant and deletable, because your migration will...

They will give you a key

To a noisy large room

Full of stuff that you'll see

In a "Dilbert" cartoon.

Several of the interesting articles in SQLServerCentral.com are of the form "Here is the stored procedure / script / business process that I use to..." Some of them are...