Viewing 15 posts - 4,426 through 4,440 (of 5,843 total)
Paul White (11/10/2009)
chk2009 (11/10/2009)
Thanks for your reply:-)How can we do that, can you pls explain me in detail, which command to use.
It's all documented in the link I provided before....
November 12, 2009 at 7:49 am
INNOCENT GUMBO
You will notice in my post about multiple clustered indexes, I put an upside-down smiley at the end. I meant my comment/question as tongue-in-cheek. 😛
November 12, 2009 at 7:40 am
John Colby (11/12/2009)
November 12, 2009 at 7:39 am
You made a very important piece of information public there: GL transactions. In my experience with financial data GL rows are almost never updated/deleted. That means record...
November 11, 2009 at 5:17 pm
You really do need to know your data access patterns in order to be able to answer the question you pose. One big question is how many forwarded records...
November 11, 2009 at 3:41 pm
GilaMonster (11/10/2009)
For that particular query, quick guess would be a composite index onDocID, DocDate, docSubject, docNo (in that order)
Bet that isn't the only query to hit the table(s) though. ...
November 11, 2009 at 8:25 am
Business Objects by any chance? I have made a good bit of money from helping others clean up performance messes from that awful system.
1)
AND (((COALESCE(StatCTE.clicks ,0) <= 1000.0))...
November 11, 2009 at 8:21 am
klineandking (11/9/2009)
I would like to know the percentage at which you would have to defragment your indexes?
The percentage at which you have an issue with performance related to index fragmentation??...
November 11, 2009 at 8:07 am
I am often-times disappointed that I cannot have more than one clustered index. Do you think they will ever put this most useful feature in SQL Server Gail?? ...
November 11, 2009 at 8:02 am
Jim, first off, welcome to the wonderful world of SQL Server! Also, what is your primary RDBMS - i.e. from whence do you come to us? 🙂
November 11, 2009 at 8:01 am
Andrew Gothard-467944 (11/11/2009)
Paul White (11/10/2009)
One might even persist the first few characters of the unencrypted value and index that. It all depends...
November 11, 2009 at 7:28 am
GilaMonster (11/10/2009)
TheSQLGuru (11/10/2009)
You can index it, but it's completely useless to do so.
That is incorrect. While you cannot do an index SEEK, a...
November 10, 2009 at 5:25 pm
GilaMonster (11/10/2009)
TheSQLGuru (11/10/2009)
You can index it, but it's completely useless to do so.
That is incorrect. While you cannot do an index SEEK, a...
November 10, 2009 at 5:25 pm
The indexed FKs have nothing to do with performance;
I think that is a bit of a stretch. There is almost always at least some performance benefit (often dramatic), both...
November 10, 2009 at 8:15 am
Yeah - "Enterprise Developer Edition" is poorly worded.
November 10, 2009 at 8:13 am
Viewing 15 posts - 4,426 through 4,440 (of 5,843 total)