Viewing 15 posts - 37,111 through 37,125 (of 49,566 total)
Jeff Moden (8/12/2009)
I meant to ask, Gail... which trace flag do you speak of?
Now you made me have to go and look it up.....
Traceflag 1118
It changes the behaviour of SQL...
August 13, 2009 at 1:48 am
Jeff Moden (8/12/2009)
I have discovered the second lowest form of life on the planet Earth. Check out the following URL... does the article look familiar to anyone?http://balavardhanreddy.over-blog.com/article-29918397-6.html
La page demandée...
August 13, 2009 at 1:40 am
You're gonna have to ask Sharepoint people that. I have no idea what sharepoint does when it backs up.
August 13, 2009 at 1:37 am
Please post new questions in a new therad. This has absolutely nothing to do with large databases
luckysql.kinda (8/13/2009)
August 13, 2009 at 1:37 am
mish (8/12/2009)
So does MS SQL have a TOP command then similar to the LIMIT in mySQL?
No.
There are two options. You can either use two TOP statements, one in a...
August 12, 2009 at 1:37 pm
Lynn Pettis (8/12/2009)
Laugh I did at the image of Qui-gon and Yoda, both with light-sabres ready, asking Is this homework?
😀
August 12, 2009 at 10:32 am
This is starting to look like homework. Is it?
If it is homework, I gave you the general form of a query that will solve question 3. If you have trouble,...
August 12, 2009 at 10:14 am
hi_abhay78 (8/12/2009)
The earlier reply was correct but unfortunately , Developers need to have sysdba role .
On dev, maybe, though I'd prefer at most db_owner on the DBs that they're working...
August 12, 2009 at 10:05 am
August 12, 2009 at 9:53 am
Steve Hoyer (8/12/2009)
This is not the moron you're looking for.
I was not implying it was you. Sorry if you got that impression.
August 12, 2009 at 9:51 am
Databases can never be downgraded in version. A database created or attached to a SQL 2008 instance cannot be restored or attached to a SQL 2005 instance. The compat mode...
August 12, 2009 at 9:48 am
Do you have AWE enabled? /3gb set?
That max is too high. You're telling SQL it can use all the memory on the server and leave absolutely nothing for the OS....
August 12, 2009 at 9:39 am
Steve Hoyer (8/12/2009)
Imagine that.
Got any idea who the last person to rebuild indexes before the growth was?
August 12, 2009 at 9:35 am
TOP 5000000? That's an aweful lot of rows to be 'limiting' a result set to. What's the purpose of that TOP clause?
August 12, 2009 at 9:33 am
Viewing 15 posts - 37,111 through 37,125 (of 49,566 total)