Viewing 15 posts - 38,866 through 38,880 (of 49,571 total)
Pradyothana Shastry (5/28/2009)
Use msdbgo
select * from sysdtspackages
Why do you keep on repeating what other people post?
May 28, 2009 at 8:14 am
Roy Ernest (5/28/2009)
BTW, the echo guy is strange. He has been doing this quite often. Or give an answer without reading the question. :hehe:
Or posting bad advice (truncate tran log,...
May 28, 2009 at 7:56 am
Depends on the number of queries that ran during that 15 min period. That no of reads could be excessive or they could be very low.
The total reads doesn't...
May 28, 2009 at 7:50 am
bhuvnesh.dogra (5/28/2009)
can somebody tell me any short method ?
You've got the two ways to move tables. There isn't a short cut.
For tables without a cluster you could always...
May 28, 2009 at 7:18 am
Yes, nonclustered indexes slow down data operations because those changes (whether it's insert, update or delete) has to be done to the table and all the NC indexes.
Test it...
May 28, 2009 at 7:14 am
The garbage collector runs every time a checkpoint runs, however in full, the old doc can't be removed until a log backup has run (not a full DB backup)
See -...
May 28, 2009 at 7:13 am
Odd. Those normally aren't caused by IO problems but usually by people directly editing the system tables on SQL 2000. Disk issues usually cause more damage than a single missing...
May 28, 2009 at 3:41 am
GilaMonster (5/23/2009)
If a database is detached while in the recovering or standby state, it cannot be reattached (baring some odd hacks that may or may not work)
Pradyothana Shastry (5/27/2009)
May 27, 2009 at 3:42 pm
Is there an echo in here ...echo in here... ...echo in here... ?
http://www.sqlservercentral.com/Forums/FindPost724259.aspx
http://www.sqlservercentral.com/Forums/FindPost723631.aspx
May 27, 2009 at 3:38 pm
And, seeing as it is a performance problem, execution plan (saved as a .sqlplan file, zipped and attached) and index definitions (if there are any indexes)
May 27, 2009 at 1:49 pm
Roy Ernest (5/27/2009)
May 27, 2009 at 1:43 pm
Please read through this - Managing Transaction Logs[/url]
If you have any questions afterwards, do ask.
May 27, 2009 at 1:32 pm
Ok, from that I'm going to guess that the starting size for tempDB is the default. 2MB. Not good when it's getting large.
Use the Alter Database command, or viw the...
May 27, 2009 at 1:29 pm
You're still second, and top looks like someone going through and answering multiple QotD
May 27, 2009 at 10:23 am
Lynn Pettis (5/27/2009)
Florian Reischl (5/27/2009)
@Lynn:Congratulation for 7k points! 🙂
Thanks! 😉
Yeah, congrats. Noticed that you were top of the 'most frequent posters' list yesterday.
May 27, 2009 at 10:13 am
Viewing 15 posts - 38,866 through 38,880 (of 49,571 total)