Viewing 15 posts - 41,626 through 41,640 (of 49,552 total)
Paresh Prajapati (1/17/2009)
That'y i said to take transaction log backup of current DB again and then apply it after that..
Except that, as Paul said, if the log's corrupt when you...
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
January 18, 2009 at 2:00 am
MichaelJasson (1/17/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
January 18, 2009 at 1:58 am
krypto69 (1/17/2009)
What am I missing?
An attached execution plan, along with the table definition, the index definitions and, if possible, an estimate of the number of rows in the table, 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
January 17, 2009 at 2:45 pm
Jeff Moden (1/17/2009)
Heh... I can just see the flame comments now.
😀
I'm writing an article on corruption at the moment and one of the things I've had to put...
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
January 17, 2009 at 2:23 pm
bhushanvinay (1/17/2009)
Look at issuing a nolock on the tables when do create the stored proc's this should help in getting the locks down.
Providing you don't mind the chance of incorrect...
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
January 17, 2009 at 2:12 pm
Jeff Moden (1/17/2009)
how can you possibly think he's wrong?
Well, it's not that he's wrong. That's a perfectly correct answer, just to a different question. It's the same 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
January 17, 2009 at 2:09 pm
Please post SQL 2000-related questions in the SQL 2000 forums. If you post in the 2005 forums, you're very likely to get 2005-specific solutions. All this does is waste everyone's...
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
January 17, 2009 at 2:06 pm
Just databases that are currently attached to the instance. If it was very recent, check out the default trace. It should have info on dropped databases. You'll find the .trc...
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
January 17, 2009 at 1:57 pm
MichaelJasson (1/17/2009)
I wanted to understand where this backup is taken. I couldn't find the backup of the transaction log.
It's not. That's the whole point. TRUNCATE ONLY means don't write out...
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
January 17, 2009 at 1:53 pm
Jeff Moden (1/17/2009)
the thing is that Ranking can take care of that one because you're grouping by day.
No, I'm not. A group is any number of events that are...
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
January 17, 2009 at 1:51 pm
bravadortb (1/17/2009)
I'm wondering if there is a correct order in which the columns should appear in the WHERE clause?
Not at all. The order that you specify has nothing...
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
January 17, 2009 at 1:07 pm
INCLUDE columns?
Only the columns in the where need to be in the index key The rest can be include cloumns, and there's no limit to either size of number...
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
January 17, 2009 at 12:46 pm
Actually, SQL knows they're numeric. The error comes from trying to concatenate a numeric value into a string. It's trying to convert 'delivered' into numeric, which isn't going to...
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
January 17, 2009 at 10:41 am
Please post the table and index definitions and the execution plan (saved as a .sqlplan file, zipped and attached to your post)
I could guess without that info but it would...
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
January 17, 2009 at 10:05 am
Ninja's_RGR'us (1/17/2009)
Since when reading the full question a requirement of posting an answer?😀
Good point. :hehe:
Grant Fritchey (1/17/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
January 17, 2009 at 8:36 am
Viewing 15 posts - 41,626 through 41,640 (of 49,552 total)