Viewing 15 posts - 2,041 through 2,055 (of 3,008 total)
Shrink DB File by Increment to Target Free Space
February 2, 2009 at 11:23 pm
Jeff Moden (1/30/2009)
February 2, 2009 at 4:14 pm
500 GB really isn’t that large a DB. I manage several that are much larger on SQL 2000, and SQL 2008 has many features to make large databases easier...
January 31, 2009 at 3:49 pm
Jeff Moden (1/30/2009)
January 30, 2009 at 7:42 pm
Bruce W Cassidy (1/29/2009)
[font="Verdana"]I've just written my very first query containing two full outer joins. Is that bad?[/font]
Is that a serious question, or were you trying to provide an...
January 29, 2009 at 6:09 pm
I don't think you have all the data in the table that you need.
You can't just use the start time of the next task to determine the end time; some...
January 29, 2009 at 5:55 pm
There are many ways to do this, but an easy way is to create and populate a date table. You can use the function on the link below to...
January 29, 2009 at 5:50 pm
Don't worry about the public role. As long as you don't grant any object access to the public role and don't add it to any of the fixed database...
January 29, 2009 at 5:41 pm
Everything you have described is exactly the way SQL Server Security is designed, and is the same in SQL 7, 2000 , 2005, and 2008, regardless of the SP.
If you...
January 28, 2009 at 9:39 pm
Bob Hovious (1/28/2009)
What are the odds of this thread evolving into SkyNet? I have children and I am worried about their future.
Should Michael Earl be worried that a...
January 28, 2009 at 4:40 pm
Jeffrey Williams (1/28/2009)
Select 27262976 / 1024 / 1024;Why do you think the system is not using 26GB of memory?
That is the Target memory. The Total Server Memory is the...
January 28, 2009 at 4:37 pm
I think you might want to look into "Scalable shared databases", an obscure feature in SQL Server 2005/2008
You might start with looking at this link:
http://support.microsoft.com/kb/910378
It's looks a bit hard to...
January 28, 2009 at 4:33 pm
Steve Jones - Editor (1/28/2009)
I leave for lunch, 98 pages of answerscome back, 102.
Wow.
This thread provides a place hang out, gripe, and pad our post counts while we wait for...
January 28, 2009 at 3:55 pm
A likely reason is that SQL Server hasn't needed more memory than the 3 GB is is currently using. It will not allocate memory until it has a need...
January 28, 2009 at 3:37 pm
Greg Charles (1/28/2009)
Alvin Ramard (1/28/2009)
I feel like unsubscribing from that item but I'm scared to miss out on a few laugh.
What's funny about this thread is if the OP and...
January 28, 2009 at 3:25 pm
Viewing 15 posts - 2,041 through 2,055 (of 3,008 total)