Viewing 15 posts - 33,646 through 33,660 (of 49,552 total)
Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 7, 2010 at 7:07 am
Restore master from a backup. Error 823 is an IO error so there's damage to the database file somewhere. Probably from that array problem.
Once you have SQL running, please run...
March 7, 2010 at 3:55 am
There were no schemas in SQL 2000. One of the things that SQL 2005 did was separate out users and schemas.
In SQL 2000, if you say
SELECT * FROM SomeUser.sometable
you're asking...
March 7, 2010 at 3:53 am
RBarryYoung (3/6/2010)
_1. They were not...
March 7, 2010 at 3:43 am
ashish.kuriyal (3/7/2010)
like all said and further to add....in case you want query to use same time then run DBCC FreeProcCache and execute your query again.
Not on a production server.
If...
March 7, 2010 at 3:41 am
clive-421796 (3/6/2010)
Would like to hear from the likes of Jeff Moden, Lynn Pettis, etc. if they have a solution for this.
http://sqlblog.com/blogs/jonathan_kehayias/archive/2009/01/19/how-to-ask-a-forums-question.aspx
I quote from Jonathan's post:
While answering posts on the MSDN...
March 6, 2010 at 2:56 pm
RBarryYoung (3/6/2010)
Joins are not "better" than sub-queries. They are not even "in general" better than subqueries. They are "in general" about the same thing, but it always depends.
This...
March 6, 2010 at 11:58 am
Sorry, don't understand what you're asking there. Clarify please.
March 6, 2010 at 6:17 am
VALEK (3/5/2010)
I don't think speaking about the areas the exam covers and pointing people to the right place to emphasize their knowledge is violation.
Repeating or paraphrasing what's on the...
March 6, 2010 at 1:23 am
arun.sas (3/5/2010)
It’s better to use the Joins instead of the sub queries/Exists.
Sure about that?
http://sqlinthewild.co.za/index.php/2010/01/12/in-vs-inner-join/
March 6, 2010 at 1:22 am
CirquedeSQLeil (3/5/2010)
Maybe they know them, but don't know that they know them.
No. Don't know them and don't care. The "I just want to do my job, I don't need to...
March 5, 2010 at 1:54 pm
Jack Corbett (3/5/2010)
March 5, 2010 at 1:50 pm
That's one of the problems with brain dumps (other than that they are cheating), because they're actual questions taken from the exams, the people who post them up don't actually...
March 5, 2010 at 1:49 pm
gmamata7 (3/5/2010)
Is this applicable to Avg. Disk sec/Read & Avg. Disk sec/Write counters too. i.e near impossible to interpret correct values from SAN?
If it was, do you think I would...
March 5, 2010 at 1:46 pm
Viewing 15 posts - 33,646 through 33,660 (of 49,552 total)