Viewing 15 posts - 37,096 through 37,110 (of 49,552 total)
http://www.google.com/search?SQL+partitioning+recommendations
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 13, 2009 at 1:48 am
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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?
😀
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 12, 2009 at 10:05 am
http://msdn.microsoft.com/en-us/library/ms186865.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 12, 2009 at 9:39 am
http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 12, 2009 at 9:36 am
Steve Hoyer (8/12/2009)
Imagine that.
Got any idea who the last person to rebuild indexes before the growth was?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 12, 2009 at 9:35 am
Viewing 15 posts - 37,096 through 37,110 (of 49,552 total)