Viewing 15 posts - 631 through 645 (of 1,539 total)
Saurabh Aggarwal (7/25/2009)
Sorry to say pradeep but you didn't understand my question, I am talking about a running query in production
Unless you run the query you cannot find the...
July 25, 2009 at 9:15 pm
...and delete the files that no longer exist
This is bit unclear to me. How will you delete files which do not exist?
I am wondering if SQL Server is...
July 25, 2009 at 9:08 pm
From your management studio, click on Query->Include actual Execution Plan.
Then run your query.
There will be a seperate tab besides results table which will say Execution Plan.
It tells you abt what...
July 25, 2009 at 7:56 pm
Log shippping tables store general configuration of your log shipping, errors and history of backup and restores. so i dont think it should bother you (except configuration part if its...
July 25, 2009 at 11:36 am
klnsuddu (7/25/2009)
Now, How can I know all the drives are healthy?
Check out with your SAN team for monitoring the health of the disks. ALso, is your k drive part of...
July 25, 2009 at 11:33 am
What is the frequency of the index rebuild operation? Generally speaking, if the fragmentaion is >30%, you should go for rebuild or else reorganization would suffice. You should do the...
July 25, 2009 at 11:30 am
I think default trace doesn't track DML operations... 😉
July 25, 2009 at 11:20 am
In my previous organization, i'd written a sms gateway in vb 6.0 that was using a third party tool (air2web) to send SMS. The gateway had schedulers running which brought...
July 25, 2009 at 11:14 am
Krasavita (7/24/2009)
Some how our data periodically gets deleted in the tables. We don't know why?How can I find out, what procedure does it?Thank you
Trace is the answer. However it's not...
July 24, 2009 at 11:17 pm
Execution plan of a query tells you whether it's doing a index scan or index seek.
July 24, 2009 at 11:14 pm
rew (7/24/2009)
Please help me understand. Thanks...
July 24, 2009 at 11:09 am
your requirement is not clear. Can you specify more on what u want to do?
July 24, 2009 at 8:54 am
I also understand if the primary goes down and you can't get the tail of the log,
That depends. If your mdf is crashed and u're able to connect somehow...
July 24, 2009 at 8:37 am
Saurabh Aggarwal (7/24/2009)
please help with material to sort such type of performance issues....Will Appreciate the help.
The best place to start for analysing and resolving performance issues are these two articles...
July 24, 2009 at 8:27 am
Patricia Johnson (7/24/2009)
July 24, 2009 at 8:23 am
Viewing 15 posts - 631 through 645 (of 1,539 total)