Viewing 15 posts - 37,066 through 37,080 (of 49,566 total)
I'm not sure what could cause this, I have passed this on to an expert on corruption, don't know when I'll get a reply.
Can you try and run the...
August 14, 2009 at 5:54 am
It's not a code problem, it's database corruption. Since it's in TempDB, you should be able to fix it by restarting the SQL service. That will cause TempDB to be...
August 14, 2009 at 5:39 am
It's not about a 'standard'. It's just that it's awfully hard to talk meaningfully about the reasons for a query's performance without having the exec plans available.
August 14, 2009 at 5:37 am
ta.bu.shi.da.yu (8/14/2009)
But I think that calling it a left outer join is a bit of a misnomer. Could be a right outer join to, right?
If it was specified as ...
August 14, 2009 at 4:14 am
ta.bu.shi.da.yu (8/14/2009)
Why would you ever want to do a left outer self join?
CREATE TABLE #SomeTable (Col1 int)
Insert into #SomeTable Values (1)
Insert into #SomeTable Values (2)
Insert into #SomeTable Values (3)
Insert...
August 14, 2009 at 3:57 am
cs (8/14/2009)
If someone could explain how cross apply works, I'd be a very happy man 🙂
I'll give it a try.
CREATE TABLE #SomeTable (Col1 int)
Insert into #SomeTable Values (1)
Insert into #SomeTable...
August 14, 2009 at 3:48 am
Shouldn't be a hard number. Can you post the execution plans of the fast and slow queries please?
August 14, 2009 at 2:37 am
If you have absolutely no backup of the database at all, you don't get the data back. That's one of the things that backups are for.
You could try a log...
August 14, 2009 at 1:56 am
Do you have backups? If so, restore them.
If not, take a look at this blog post for a method of hacking the DB back into the server and the repairs...
August 14, 2009 at 1:48 am
Ratheesh.K.Nair (8/14/2009)
Can anyone please tell me what are ghost records and thier impact?How can we handle the same?
http://www.google.com/search?q=SQL+Server+%22ghost+records%22
August 14, 2009 at 1:44 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Question asked and answered here: http://www.sqlservercentral.com/Forums/Topic770068-145-1.aspx
August 14, 2009 at 1:36 am
Why do you want to shrink? Databases tend to grow as more data gets put in them. It's in their nature.
Shrinking causes massive fragmentation and will just result in the...
August 14, 2009 at 1:34 am
It's convoluted.
Expand out object explorer, database - tables - statistics. Right click on the stats and select properties. Check the box that says update stats. Click ok.
Much faster (I think)...
August 14, 2009 at 1:32 am
Jan Van der Eecken (8/13/2009)
August 14, 2009 at 1:27 am
jacroberts (8/13/2009)
GilaMonster (8/13/2009)
August 13, 2009 at 12:22 pm
Viewing 15 posts - 37,066 through 37,080 (of 49,566 total)