Viewing 15 posts - 39,151 through 39,165 (of 49,552 total)
Any idea why allow_updates is getting set to 1? If something's messing badly with the system tables it could be the cause of the suspect status.
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
May 12, 2009 at 7:30 am
Please spoon-feed me...
http://www.sqlservercentral.com/Forums/Topic714789-357-1.aspx
Anyone want to take time to write a step-by-step process for restoring a database from full backups and log backups?
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
May 12, 2009 at 7:29 am
mrlucmorin (5/12/2009)
I guess that internally, the server "knows" which rows of TableA are included in the JOIN, though what I'd like to know is how it knows 🙂
It will start,...
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
May 12, 2009 at 7:27 am
venu_ksheerasagaram (5/12/2009)
Let me know how to Restore a DB using Log transaction files?
I just did.
Give me a Practical situation and step by step procedure?
Look in Books Online under RESTORE 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
May 12, 2009 at 7:25 am
Regarding future editions, there will be a SQL 2008 R2 released sometime in 2010, first CTP later this year. It's not a complete new version, more a set of add-ons...
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
May 12, 2009 at 7:17 am
jcrawf02 (5/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
May 12, 2009 at 7:03 am
Can you check the previous error log. Looks like the DB was suspect before the restart, need to see if there's anything there that hints as to why it 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
May 12, 2009 at 6:54 am
venu_ksheerasagaram (5/12/2009)
1)What is the use of Log shipping transaction ?
Log shipping creates a warm secondary server so that if anything happens to the primary server, apps can use 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
May 12, 2009 at 6:54 am
Samuel Vella (5/12/2009)
As far as I know, this isn't ANSI standard SQL
You are correct, it's not.
There was nothing wrong with his syntax. That first FROM is optional. These are equivalent...
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
May 12, 2009 at 6:51 am
Grant Fritchey (5/12/2009)
Paul White (5/12/2009)
Vinoo (5/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
May 12, 2009 at 6:45 am
Go to 2008. At this point there's no sense to upgrade to 2005. The prices of the two are the same.
If you were on 2005 I would suggest not...
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
May 12, 2009 at 6:45 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic714850-150-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
May 12, 2009 at 6:38 am
All the rows in TableA that satisfy the join condition (ie have matching rows in TableB) will be deleted.
Basically, iy you replace DELETE FROM TableA with SELECT TableA.*, you'll see...
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
May 12, 2009 at 6:34 am
When you say 'failing', what do you mean? Is it not returning any rows? Is it giving a syntax error, and if so, what error?
What's the code supposed to do?
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
May 12, 2009 at 6:32 am
manolomalaga (5/12/2009)
Or make a job like this:
That's a very bad piece of advice (for anyone interested, the OP in the referenced thread wanted to delete the LDF daily)
Proper maintenance of...
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
May 12, 2009 at 6:26 am
Viewing 15 posts - 39,151 through 39,165 (of 49,552 total)