Viewing 15 posts - 17,686 through 17,700 (of 22,202 total)
Sounds pretty normal. As companies grow, a certain amount of tiers develop, at least for reporting purposes. I can talk to the CIO any time I want (I don't want...
April 16, 2009 at 7:43 am
Maybe it's a delay? Steve would know. I'm sure he'll be by in a minute or three.
April 16, 2009 at 7:41 am
Because every time you post to the forums you also get a point... there's another one.
April 16, 2009 at 7:28 am
It really depends on the system. We have a few tables on a couple of databases where, due to some issues, we're running update stats a couple of times a...
April 16, 2009 at 6:00 am
I'm not aware of that one. Most of the showplan events are under the Performance section. Make sure you have "Show all Events" selected.
April 16, 2009 at 5:50 am
The way to do something like that would be with at least two tables. The first table would hold the information about the person. The second table would hold relationships...
April 16, 2009 at 5:38 am
I've seen a few posts like this where the odd query or three gets messed up by the upgrade, but I've never seen any large number of procedures get messed...
April 15, 2009 at 5:15 pm
Bruce W Cassidy (4/15/2009)
I'm reading an article (it's work related, okay?) and I run across this paragraph:
"The first and most obvious reason is that the DW appliance...
April 15, 2009 at 4:55 pm
GilaMonster (4/15/2009)
Bruce W Cassidy (4/15/2009)
[font="Verdana"]I didn't want to confuse issues by asking "aren't there some ANSI standards around character sets and collations?"[/font]
One question that pops to mind. Did ANSI create...
April 15, 2009 at 4:53 pm
If I'm reading the data correctly, the estimated rows on the 2000 query is 13 right through, but the estimated values in 2005 are all over the place, from 1...
April 15, 2009 at 9:44 am
I am confused as to why the performance is so different between the two, but the fact that performance is sub-optimal is because of the functions on the columns in...
April 15, 2009 at 8:05 am
You can use SET SHOWPLAN_ALL or SHOWPLAN_TEXT.
ALL provides more information but it's more difficult to read. Let's go with ALL despite the difficult, but you can post both.
April 15, 2009 at 8:03 am
Two things.
First, and most important, the costs displayed in execution plans are estimates. They are not accurate measures of anything. While you may or may not see a cost go...
April 15, 2009 at 7:30 am
Can you post the actual execution plan instead of the estimated one? I'd really like to see, as much as possible, what's happening.
This is a weird one. Also, can you...
April 15, 2009 at 7:06 am
GilaMonster (4/15/2009)
You left out one of the I's on ASCII.
Story of my life.
April 15, 2009 at 6:55 am
Viewing 15 posts - 17,686 through 17,700 (of 22,202 total)