Viewing 15 posts - 40,876 through 40,890 (of 49,571 total)
After yet another case of someone just posting a query and asking why it was slow (If I could tell, I'd have some really, really happy clients), I'm contemplating writing...
February 21, 2009 at 7:39 am
peace2007 (2/21/2009)
I've found out that each query that calls this function is very slow. I'd like to know why this function is so slow.
Execution plan?
Table definitions and index definitions?
February 21, 2009 at 7:30 am
Richard (2/21/2009)
This works fine apart from one database, which fills the log with status 2 files.
Status 2 files? Not sure what you mean. Clarification please?
February 21, 2009 at 7:29 am
susaabraham (2/21/2009)
You have mentioned about adding the type to the hybridDictionary. Can you please help us to do that....do you have any sample with you
No samples, and C# is not...
February 21, 2009 at 4:34 am
Your disk stats are high. Both sec/read and sec/write should be around 10ms. On C, your sec/read reaches 0.5, on D, G and Z the sec/write reaches 0.1. Both of...
February 21, 2009 at 3:11 am
susaabraham (2/21/2009)
February 21, 2009 at 3:03 am
angel0in (2/20/2009)
I am planing to use SQL Server Express on one machine and use it from 5-6 machines on LAN. In that case is also stable according to GilaMonster
That's not...
February 21, 2009 at 3:01 am
y.koteswarrao (2/21/2009)
I have executed the DBCC Checkdb() and found that the database is mared as suspect,How can i reslove this issue?
Depends why it's suspect.
Please post the full output of checkdb...
February 21, 2009 at 2:58 am
Ninja's_RGR'us (2/20/2009)
If you start with a fresh set of backups once the server is back online, can it avoid restoring troubles later on?
I would think so. I'm not sure...
February 21, 2009 at 2:20 am
Lynn Pettis (2/20/2009)
Nope. Check your profile.
:blush: I forgot that was in there.
So much for that...
February 21, 2009 at 2:04 am
Krishna (2/20/2009)
Because in SQL server, the first column is enforced by an index
No, the entire primary key is enforced by an index, not just the first column.
A second index on...
February 21, 2009 at 2:03 am
brekher (2/20/2009)
February 21, 2009 at 2:01 am
Lynn Pettis (2/20/2009)
Let me guess, let's say around early 30's. Say right around the time I graduated high school. Close??
Just about dead on.
Lucky guess?
February 20, 2009 at 3:21 pm
xgcmcbain (2/20/2009)
as for reubilding indexes, sql server does not do this automatically at some point?
No
What are the reasons for having to rebuilding indexes? inserts, deletes?
Inserts mostly, updates a bit, deletes...
February 20, 2009 at 3:20 pm
Bob Hovious (2/20/2009)
Is there an easy way to search for all the threads he has originated?
Yup. Click on his username, select "View all posts by this member"
You sure you want...
February 20, 2009 at 3:18 pm
Viewing 15 posts - 40,876 through 40,890 (of 49,571 total)