Viewing 15 posts - 1 through 15 (of 27 total)
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...
January 23, 2014 at 3:15 pm
July 15, 2013 at 4:47 pm
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...
July 2, 2013 at 3:50 pm
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...
January 24, 2013 at 7:35 pm
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...
January 23, 2013 at 4:20 pm
Bob Cullen-434885 (1/23/2013)
January 23, 2013 at 2:41 pm
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...
November 18, 2012 at 5:01 pm
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...
November 15, 2012 at 9:42 pm
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...
November 15, 2012 at 9:25 pm
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...
June 27, 2012 at 4:11 pm
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...
May 23, 2012 at 4:28 pm
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....
March 19, 2012 at 8:05 pm
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...
March 19, 2012 at 6:10 pm
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...
December 19, 2011 at 3:25 pm
...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....
October 26, 2011 at 10:45 pm