Viewing 15 posts - 1 through 15 (of 20 total)
I should have mentioned in my initial post that I was speaking of a Primary Key *Clustered* constraint. This creates a corresponding index.
March 6, 2013 at 6:37 am
Thanks for your observations.
March 5, 2013 at 3:16 pm
I am a little puzzled. You remarked that procedure_stats was a subset.
I presumed the reason there were 840,000 query_stats and only 500 proc_stats was because of a one-to-many between...
January 10, 2013 at 1:42 pm
Thanks. That makes sense now. I appreciate your replies.
October 18, 2012 at 7:08 am
Since I am only accessing the system catalog and a DMV, I would expect that performance should be consistent and fast. I find that it is not. It may just...
October 17, 2012 at 7:20 am
Thank you for your replies. Most of the transactions are somewhat small, so large contiguous reads should not be an issue in terms of data organization or statistics.
Still, I...
October 16, 2012 at 1:14 pm
That is the right question. I want to set up a generic user and put them into the single group for testing, where there would be no conflicts and I...
December 7, 2011 at 9:01 am
The user is using a windows-based login, theoretically through the authority of the Windows Group, which was granted ALTER SERVER STATE.
One possibility is that the credentials in AD have conflicts....
December 7, 2011 at 8:46 am
Better late than never! subscriber_id can be joined to master.dbo.sysservers. NOTE: Not master.sys.servers. It has something to do with different ways servers can be related, replication, linked, etc. Anyway, I...
November 22, 2011 at 8:40 am
I thought this was it:
OPENROWSET
( { 'provider_name' , { 'datasource' ; 'user_id' ; 'password'
| 'provider_string' }
, { ...
November 18, 2011 at 4:04 pm
Hi, Nick.
Did you ever find another option to the openrowset? I have run into the same issue.
Thanks,
Steve
November 16, 2011 at 3:56 pm
You could use bcp and specify the first and last row (capital F and L parameters).
There is another function somewhere [could not find it immediately], I think using prepare...
November 16, 2011 at 10:03 am
My personal preference is to use the statement:
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
at the beginning of predominantly read-only stored procs. That way, you don't need the dumb query...
November 16, 2011 at 9:56 am
I did as you suggested, Lowell, and the freeproccache ran fine. Unfortunately, there was an Db sendmail further on that failed. I would have thought that both these commands would...
November 16, 2011 at 8:37 am
I would try a different provider. I try to use the Native Client, figuring it should be the most up to date.
November 9, 2011 at 4:47 pm
Viewing 15 posts - 1 through 15 (of 20 total)