Viewing 15 posts - 37,051 through 37,065 (of 49,552 total)
This isn't T-SQL. Looks like C# to me, and there's nothing database related in there. You may get better and faster replies posting this pn a C# forum, maybe one...
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 14, 2009 at 5:54 am
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...
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 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...
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 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.
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 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 ...
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 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...
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 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...
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 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?
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 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...
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 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...
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 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
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 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
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 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...
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 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)...
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 14, 2009 at 1:32 am
Jan Van der Eecken (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 14, 2009 at 1:27 am
Viewing 15 posts - 37,051 through 37,065 (of 49,552 total)