Viewing 15 posts - 2,071 through 2,085 (of 8,416 total)
Eric M Russell (3/3/2011)
March 3, 2011 at 10:13 am
mwwheeler (3/3/2011)
March 3, 2011 at 10:10 am
Eric M Russell (3/3/2011)
Depending on the circumstance, a view can replace the functionality of a scalar or table valued function and do so more efficiently.
In 2005 or later, I would...
March 3, 2011 at 7:59 am
mazzz (3/1/2011)
Awesome info, Paul - thanks for that.Time to write an article (or ten), maybe...? 🙂
Cheers. Coincidentally, I just now received the editor's comments on my first article for Simple...
March 1, 2011 at 9:46 am
Ok. First thing is about memory: SQL Server Standard x86 is not limited to 2GB memory (though it is limited by default to 2GB address space aka VAS). ...
March 1, 2011 at 5:12 am
[Jim].[dba].[Murphy] (2/28/2011)
February 28, 2011 at 11:29 pm
mazzz (2/28/2011)
If you can, forget everything you read in this thread about parallelism.
In what sense? Forget it because it most likely won't be related to parallelism, given the info above?...
February 28, 2011 at 10:36 am
OK, that makes sense. The 23,725 attempts and 10 successes on the clustered index on live shows that escalation from row (or page) locks to a table lock is...
February 28, 2011 at 9:36 am
daveriya (2/28/2011)
Can we discuss what are the way,we can check that the consolidated tables were generated correctly?
How much do you need to check?
1. Check a table exists with the...
February 28, 2011 at 9:01 am
Jeff Moden (2/28/2011)
February 28, 2011 at 7:08 am
daveriya (2/27/2011)
One way to show its registered or not...{code removed} group by clause doesn fit anywhere here
Have a look at something like this:
DECLARE @Bank1_201001
TABLE (
...
February 28, 2011 at 7:02 am
Excellent quality answers - thank you! On the XML plan thing, I should have made it clearer that you are looking for WithOrderedPrefetch or WithUnOrderedPrefetch, not With(un)OrderedPrefetch.
So, the other...
February 28, 2011 at 7:01 am
mwwheeler (2/28/2011)
February 28, 2011 at 6:34 am
Jeff Moden (2/28/2011)
Never mind. I see. My code worked but wouldn't suffer many data changes.
Yes, only minor changes to some very nice code. My main worry is...
February 28, 2011 at 5:59 am
wagner crivelini (2/28/2011)
February 28, 2011 at 5:42 am
Viewing 15 posts - 2,071 through 2,085 (of 8,416 total)