Viewing 15 posts - 1 through 15 (of 26 total)
Thanks Lynn and Jared.
What gets me is that the function definitions are virtually the same in 3.0 and the 4.0 system. The nested calls are the same. The number...
June 4, 2012 at 2:01 pm
Does not seem to be. I have included the def in the attachement.
Thanks.
June 4, 2012 at 1:52 pm
Jared,
I typically try to do my homework. There was something about a timezone change with Windows around the year 2008 for Daylight savings time but I doubt that this is...
June 4, 2012 at 1:47 pm
There are many things that should be rewritten as the filteredviews are drastically slower than native table calls. There are support and contractual issues that are outside the realm of...
June 4, 2012 at 1:37 pm
Jared,
Here is the function DDL. I am not allowed to mod that call as that is used in the filteredview itself.
thanks.
June 4, 2012 at 1:20 pm
Sure. As a background, I've actually compared multiple runs on the basic select top 10000 * against the filtered query for the "Contact" entity. I've done this with many variations...
June 4, 2012 at 1:00 pm
Jared,
I can see it on the Quest Spotlight Console for History. That particular SPID is holding-up a bunch of other SPIDs.
Thanks.
June 4, 2012 at 12:35 pm
Thanks for your input guys!
January 6, 2011 at 9:05 am
Sorry about that. I'll make this more concrete. Given a parent table A and a child table B, I can see multiple FKs defined for B referencing A on the...
January 6, 2011 at 8:47 am
Is there a known value to redundant FKs would be the question?
January 6, 2011 at 8:37 am
Sorry about that contradicting post. I was sort of in a migration bind. I installed SQL Server on a new machine and restored a database that was being replicated via...
March 20, 2010 at 4:47 pm
Thanks guys. I'll do a bit more research too.
January 14, 2010 at 6:23 am
Unchecking the checkbox for transactional replication yields:
No active open transactions.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
I think that I'm good now. Thank you all!!!
January 12, 2010 at 11:23 am
Thanks Gail! I appreciate the help. I'll let you know what happens.
January 12, 2010 at 11:18 am
Hi Carolyn,
That's interesting. I'll check it out as well.
Thanks.
January 12, 2010 at 9:38 am
Viewing 15 posts - 1 through 15 (of 26 total)