Hi Hugo

The only reason I can think of is that your "model" database has the "guest" user enabled with read permissions so your login is getting access to the new...

vick.ram79 (7/15/2013)

---

Use local variables to hold the values of the passed parameters. And then use the local variables instead of the passed parameters. This has ALWAYS worked for us in...

Sorry but I don't like it. Designed for mobile devices, not a desktop PC which is what I suspect most people use to access this site. Too narrow and I...

Hi Dineshbabu

It's not really possible to list all function or commands that can perform different actions depending on the circumstances. As Tom very rightly states in his post, many commands...

Hi Hugo

Yes, I see what you mean. I guess it doesn't seem inconsistent to me as I fully understand the different actions and so I was puzzled as to what...

Bob Cullen-434885 (1/23/2013)

---

OK. I got it wrong because I tried to apply what I thought was sensible logic to the choice of the second value. Can anyone explain why SQL...

Hi Brad,

I'm in Brisbane. Still scratching my head on this, coffee doesn't seem to have helped. I think various things are red herrings though.

As you have pointed out...

Wow, you're up early. At least it's 14:30 in the afternoon in Oz. May well not be the issue but good to eliminate it. Just removing the nolocks should prove...

Hi Brad

Something to check. I notice all your joins use 'nolock'. There is a bug in SP2 which causes high cpu usage on queries that use nolock against a table...

To be honest I thought the question was quite clear. It asked what index SQLSERVER created to support the foreign key. It did not ask what other constraints, which may...

roger.plowman (5/23/2012)

After all, in the example today the database allowed a *partial* transaction to commit (by default!). That violates the definition of a transaction--and thus is a bug, not a...

No problem Drew. Personally I would leave your current indexes in place, but add additional ones with the different column order and see if they improve performance for specific queries....

Hi Drew

You are correct, the histograms will be the same for each index as only the first column of the index is used. However remember that statistics also work out...

Hi

I'm slightly puzzled by the issues you may be having with replication. I've used it for years with both Sybase and SQL Server and it's very robust and generally quite...

...also, I didn't make the more obvious point. If the tables being replicated to server C are the same tables as to server B, you don't need a new publication....