Viewing 15 posts - 361 through 375 (of 1,790 total)
Grant Fritchey (2/15/2011)
David Benoit (2/15/2011)
Grant Fritchey (2/15/2011)
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 15, 2011 at 7:37 am
Grant Fritchey (2/15/2011)
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 15, 2011 at 7:27 am
I like the Red-Gate tool as well due to the alerts that it provides. I also like, and use, SQL Sentry, which in my opinion has the best disk views...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 15, 2011 at 7:25 am
...and you might try to lobby for some backup compression software in there somewhere as well. That will save a whole lot of disk space with 3 days of database...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 15, 2011 at 7:21 am
If you could provide table definitions and some sample data inserts that would be helpful. I'm sure that we can help with the query if you provide that.
Thanks.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 14, 2011 at 8:54 pm
cjohn5552 (12/30/2010)
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 14, 2011 at 1:46 pm
Have you determined how much of the IO / what percentage of IO is tempdb related? If it is high then it might be a quick fix but it is...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 14, 2011 at 1:43 pm
Please not - BIG disclaimer - FLASHING - I don't believe this is supported. Read and apply at your own risk....
http://nyc-dba.blogspot.com/2008/10/using-local-disks-in-cluster.html
The key pieces of information are in the comments section....
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 14, 2011 at 1:00 pm
There is a registry modification / hack that I found some time ago that gives instructions on how to do this, primarily so that SSD's can be used for tempdb...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 14, 2011 at 12:54 pm
I know that it can be a fix for some situations but I don't believe it is recommended to be applied universally from what I have read up to this...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 14, 2011 at 12:47 pm
alen teplitsky (2/14/2011)
if the OS and SQL is x64 you should enable lock pages in memory
Alen - do you have any MS articles supporting that? Curious as I have not...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 14, 2011 at 12:34 pm
I haven't taken any exams so I can't answer the question that you are asking. However, I would recommend learning the commands that go along with the GUI as I...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 11, 2011 at 3:45 pm
You really should leave a minimum of 2 GB of memory for the OS on any server so, you have most likely depleted the system memory.
I would start lobbying...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 11, 2011 at 3:38 pm
You either have to add them to the existing publication (more complex) or add them to a new publication. If you add them to a new publication you can easily...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 9, 2011 at 4:07 pm
The table you are going to want to hit is on the distribution database, MSdistribution_agents. To see all the publications you can either look in the distribution database or in...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 7, 2011 at 2:46 pm
Viewing 15 posts - 361 through 375 (of 1,790 total)