Timothy Ford (3/13/2008)

---

Cluster failover can occur within seconds and is automatic whereas mirroring/log shipping is not as simple to fail over to. Client connectivity is impacted since you can...

Careful when downloading from Codeplex. There's something confusing there: you click on the link to go get the 2005 version (from MS' site)...and it takes you to the 2008...

And yet another...

I suspect you haven't tested this with concurrent users/sessions... The "first" session will do great - and the other sessions will fall apart because the "first" view is there. ...

Why the function? If that ETL ID is indexed - then:

...WHERE ID<'X'....

Should give you what you want, but would probably leverage an index (assuming it's selective enough or it's...

Jeff Moden (3/13/2008)

---

They have the advantage of a "continuing scope" when compared to multiple EXEC's. You can do a lot of things to a temp table in a single...

What I was trying to convey was - SSRS doesn't know and doesn't "care" what version of Excel you (as the reporting client) has. Since it's running in IE,...

I'm thinking you'd get MUCH better answers on how to do something in DB2 on a DB2 forum. I know I only have the foggiest of what Db2 code...

Since tempdb is used for temporary objects - that means at some point since you restarted the server - you had one or more objects active that made the tempDB...

There's something strange there. The one with the sub-query is being picked up by the optimizer as the lower cost. That stinks something strange.

Are the statistics anywhere near...

I vaguely remember one of the flame wars on Nulls going to some ludicrous amount of posts. Not sure this is the record - but it might be the...

QA is not one of the applications it's talking about. Query analyzer is already built, etc...Even if you preloaded the script needed to activate the app role, your users...

- The controls have a property called DataKeyNames. It need to be set to the name of the column which is the primary key in the table you're updating.

...

Jeff Moden (3/10/2008)

---

Giving away a fine "secret" here, but no one's ever heard of temporary stored procedures? Build it using dynamic SQL... execute it... it's all in the same...

You should double-check the nullability of the parameters used in the ASP:SQLDataSource object. The default behavior is to abort the action if any of them are null (meaning -...