Viewing 15 posts - 15,631 through 15,645 (of 22,211 total)
The Dixie Flatline (3/25/2010)
ARID = Alternate Reality ID.I believe it's parameter 117, but I'd have to confirm that with Gail.
And that's a GUID right?
March 25, 2010 at 11:52 am
You can't modify it while it's Read Only. You'll have to turn it off & turn it back on.
March 25, 2010 at 11:37 am
ss-457805 (3/25/2010)
Grant, You are a genius. The query has come down to 6 secs with your recommendations.Thank you.
I'm certainly not a genius. That was just some of the easy stuff...
March 25, 2010 at 11:20 am
I'm sorry, I'm not there and I don't know your structure. When you said this earlier:
But dalily we need all the columns data.
I thought that meant that you needed to...
March 25, 2010 at 8:29 am
Then possibly adding it might be in order. You've pretty much said that the access is by date. If you're principal access is by date, but you split it by...
March 25, 2010 at 7:53 am
I guess it's a silly question, but why would you want to open 100 procedures all at the same time? You can't possibly look at or manipulate them all at...
March 25, 2010 at 7:14 am
I doubt it has anything to do with statistics. You're either hitting an error that is causing the rollback, the transaction is rolling back because the connection was dropped, or...
March 25, 2010 at 7:09 am
Looking at it, you're getting almost nothing but clustered index scans. That means it's reading every single row on the table. Things in the queries that are causing this include:
CellGroupName...
March 25, 2010 at 7:06 am
ekknaveen (3/24/2010)
I need the help to solve the below mentioned questiones.
1. <>. > =. LIKE what is the order as per performance
2. select * from tab1 where lower(name)='name' is fast...
March 25, 2010 at 6:52 am
It sounds like a classic design error on normalization. Yes, given the opportunity, I'd suggest redesigning the structure and migrating the data. It won't be that hard and you should...
March 25, 2010 at 6:46 am
The uniquifier (or uniqueifier) is a 4byte integer value. So from that you can estimate the cost to the size of the index. So that not only increases the size...
March 25, 2010 at 6:34 am
virgilrucsandescu (3/24/2010)
And the last chapter (the checklist) should be on the desk...
March 25, 2010 at 6:05 am
I agree with Gus and I'll add that I still learn more when I answer a question wrong and it gets fixed by one of the SQL-Monsters that run around...
March 24, 2010 at 12:35 pm
Steve Jones - Editor (3/24/2010)
...many of the more vocal people on the East Coast...
Now who the heck are you talking about?
March 24, 2010 at 10:29 am
If you're seeking to break it up in that way, then instead of ID & foreign key, maybe breaking it up by date makes more sense.
March 24, 2010 at 6:20 am
Viewing 15 posts - 15,631 through 15,645 (of 22,211 total)