Viewing 15 posts - 41,071 through 41,085 (of 49,552 total)
Magy (2/12/2009)
Is there a way to undo this restore?
Not unless you took a more recent backup.
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
February 13, 2009 at 2:21 am
Doc (2/13/2009)
Question is funny and odd, but that doesn't mean he shouldn't ask one or be crucified for that.
Agreed. I just wish he'd think and read up before asking stuff...
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
February 13, 2009 at 2:10 am
Query sys.traces to see if the trace still exists (it should). Use sp_trace_setstatus to restart it
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
February 13, 2009 at 2:00 am
Eeep..
http://www.sqlservercentral.com/Forums/FindPost655667.aspx
I want to do a PhD in the area of database optimisers. Can anyone suggest a good topic?
Gees, it took me months of reading to decide on an appropriate topic...
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
February 12, 2009 at 8:33 am
karthikeyan (2/12/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
February 12, 2009 at 8:27 am
Lynn Pettis (2/11/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
February 12, 2009 at 8:24 am
Drop all the statistics referenced in the error messages. SQL will recreate them if it needs.
Maybe run a checkcatalog on the sql 2000 database?
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
February 12, 2009 at 8:22 am
Dell
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
February 12, 2009 at 8:15 am
That works.
The gos aren't needed, they aren't a problem. Their batch-terminator statements, so each of those will be sent to SQL separately.
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
February 11, 2009 at 10:44 pm
Lynn Pettis (2/11/2009)
Any hints on He who will remain unnamed? Is it someone I've "spent time" trying to help in the recent past?
I can think of a couple that...
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
February 11, 2009 at 10:41 pm
By filtering on object id not null, you are limiting the results to stored procedure plans. I guess you have none of those.
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
February 11, 2009 at 10:39 pm
Mahesh Bote (2/11/2009)
[font="Verdana"]When Inner query is joined with Outer query, it is called co-related query. and the relation is called as query co-relation[/font]
Only when the inner query contains a reference...
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
February 11, 2009 at 10:37 pm
Did you run checkdb again after running the checkusage? It's normal for checkusage not to give errors. It fixes problems.
Those won't generate errors on SQL 2000. CheckDB on SQL 2000...
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
February 11, 2009 at 10:18 pm
FelixG (2/11/2009)
I do know it's mandatory to split out filegroups to optimize the overall performance.
It's not mandatory. It's only needed when the drive that the data file is on...
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
February 11, 2009 at 2:42 pm
Change the inner join to LEFT Outer and change the count as follows
CASE WHEN b.BlogId IS NULL THEN 0 ELSE COUNT(*) END AS CountComments
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
February 11, 2009 at 2:12 pm
Viewing 15 posts - 41,071 through 41,085 (of 49,552 total)