Viewing 15 posts - 38,611 through 38,625 (of 49,571 total)
There's no ORDER BY on that query so you can make absolutely no assumptions about the order the data will be returned in. If you want a specific order, add...
June 8, 2009 at 10:44 am
What you can do is use profiler (or a server-side trace) to see what the IOs are like for frequently run queries. High IOs may indicate inefficient queries or a...
June 8, 2009 at 10:39 am
Lynn Pettis (6/8/2009)
June 8, 2009 at 10:38 am
Sorry, os shouldn't have been there. sys.dm_tran_locks. Run it in the DB in question, not in master.
June 8, 2009 at 10:34 am
Florian Reischl (6/8/2009)
GilaMonster (6/8/2009)
Hey Barry. How about some basic Computer Science theory to start the day?Deja Vu (on a German forum...?!?)
At least he went and found the wiki article himself....
June 8, 2009 at 10:29 am
Is that iSCSI drive network attached storage?
June 8, 2009 at 10:27 am
karthikeyan (6/8/2009)
Yes Gail...I have studied...But i don't remember the functionality...I have reviewed the above mentioed URL, Since there are lot of formula's are there,it is confusing...
Ok, explain what you do...
June 8, 2009 at 10:25 am
Tom Brown (6/8/2009)
June 8, 2009 at 10:17 am
Lynn Pettis (6/8/2009)
GilaMonster (6/8/2009)
Hey Barry. How about some basic Computer Science theory to start the day?Oh, great, our "PhD Candidate". Could have warned us on that one, Gail.
And spoil...
June 8, 2009 at 10:14 am
GURSETHI (6/8/2009)
Hi,We can also query a DMV which will tell how much %age a specific query has done.
SELECT SESSION_ID, percent_complete, estimated_completion_time FROM SYS.DM_EXEC_REUQESTS
From Books Online:
percent_complete
Percent of work completed for...
June 8, 2009 at 10:10 am
Hey Barry. How about some basic Computer Science theory to start the day?
June 8, 2009 at 6:00 am
General rule-of-thumb. It will take longer to roll a process back than it did to do the work to that point. So if you roll back a process that has...
June 8, 2009 at 5:57 am
karthikeyan (6/8/2009)
1) O(n) means ?2) O(n^2) means ?
3) O(n log n) means ?
Surely you covered the Big O notation for algorithmic (time) complexity at university? It's a fundamental of Comp...
June 8, 2009 at 5:53 am
You'll either have to fix the dependencies or move the DB files to a drive that's already a dependency.
June 8, 2009 at 5:48 am
Viewing 15 posts - 38,611 through 38,625 (of 49,571 total)