Yes. Me too. The only variables you can pass into an execute string are @@objectname and @@schemaname.

Seems a strange thing to be missing also.

Ah ok I see, so when necessary the "previous" and "next" index page pointers are updated.. the physical page isn't moved... a new row is inserted on correct physical data...

I'm pleased to find it stated repeatedly here that the index design should always be specific to the situation, and tested for correctness.

I always object to the commonly held...

I find that there's rarely (very rarely) a need for business users to write their own queries. Most adhoc data functions can be solved through OLAP tools. If there's a...

Hi,

I have this problem also. All the jobs execute successfully, but the restore job checks each transaction log and skips all of them. I can manually load the first...

I'm not sure what you've done.. but I've found I don't need to install Reporting Services to run the Upgrade Advisor, and it seems to work just fine against remote...

Oh Microsoft are so infuriating sometimes.

Why do you have to run this with /q?

Why can't they let you know where the install log files are saved?

Why can't...

Yes, Web applications that I see these days all seem to use a single generic login which is stored, hopefully encrypted, into web.config.

Shouldn't the SQL 2005 implementation of application...

We've looked at this type of problem before also.

The problem with using a snapshot against the mirror is... when do you update it? Secondly, to refresh the snapshot you...

I'm a Production DBA and I like to describe the essential tasks in the role thus;

1. Facilitate business continuity (this includes maintenance, capacity planning, failover etc..

2. Manage data...

What makes you think this is a memory issue?

CPU utilisation is generally the result of operations - calculations, aggregates, set ordering ... I'd recommend just running SQL Profiler and...

Just wondering - has anyone actually used the high-safety mode on a production database? Under what server architecture and is there a serious or noticeable performance difference? .. any stats...

In my experience the fallibility of tape storage systems has more to do with poor manufacturing quality (and it gets worse by the year). The number of times we've been...