Viewing 15 posts - 41,131 through 41,145 (of 49,571 total)
ashy4blue (2/10/2009)
February 10, 2009 at 11:26 pm
Adonia Delavigne (2/10/2009)
Since then I have been getting error messages when I try to access maintenance plans , agents, alerts and so on.
What errors?
Does have SPs installed make any...
February 10, 2009 at 11:22 pm
viduvs (2/10/2009)
But in case if it is possible to reduce excution time significantly by executing it directly on the server, so we were looking for this solution.
Tricks like that might...
February 10, 2009 at 11:18 pm
guptaajay1985 (2/10/2009)
Why we use NDF file...
Have a read through of Books online, all sections on files or filegroups.
No need to repost after 30 min. This is a forum, not a...
February 10, 2009 at 11:08 pm
Rebuild, yes, reorganise, no.
Even still, autostats should be on for any system unless you know that 1 week old stats will not result in performance degradation due to poor query...
February 10, 2009 at 2:50 pm
If the index's leading column is imageid, then SQL will never pick it by choice, as the leading column of the index is not in the where clause at all....
February 10, 2009 at 2:49 pm
ichbinraj (2/10/2009)
We have recommendations from team- lead to increase the datafiles in db ...he suggested us to maintain ratio 2:1 (datafiles : Processors ).
Tell your team lead that the recommendation...
February 10, 2009 at 2:39 pm
Bruce W Cassidy (2/10/2009)[font="Verdana"]
Fair comment. Shamefaced[/font]
No worries. We've all done the same thing on occasion.
February 10, 2009 at 1:53 pm
Look up ALTER DATABASE in Books Online. The options to add files are well described.
Why a new file? What are you trying to achieve?
February 10, 2009 at 1:50 pm
Bruce W Cassidy (2/10/2009)
[font="Verdana"]Gotcha. I did a little subsidiary reading on Books Online, and you're quite right -- cached query plans don't apply for views.[/font]
May I very politely and...
February 10, 2009 at 1:47 pm
Paresh Prajapati (2/10/2009)
Only I know that from Network people , it is external IP..
Then tell them to do their bloody jobs and find out where the intrusion is coming from....
February 10, 2009 at 1:45 pm
Grant Fritchey (2/10/2009)
Yep, Gail's right on this one too (you can usually just assume that).
:hehe:
February 10, 2009 at 1:42 pm
Bob Hovious (2/10/2009)
"I've just deleted some huge, important tables and I haven't been doing backups. How do I get these tables back?"
If you want to laugh (or...
February 10, 2009 at 1:39 pm
Bruce W Cassidy (2/10/2009)
February 10, 2009 at 1:24 pm
MVIR (2/10/2009)
I can make the changes in code as everybody hassuggested but I need to give out a proper reason for why it has gone bad.
Very hard to say. Data...
February 10, 2009 at 1:10 pm
Viewing 15 posts - 41,131 through 41,145 (of 49,571 total)