Viewing 15 posts - 40,051 through 40,065 (of 49,552 total)
ed (4/1/2009)
How can several days data go missing from DatabaseB?? (it subsequently is missing from the publication db also!)
Someone deleted it.
Did the truncate with the Appdomain down cause the data...
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
April 1, 2009 at 4:08 pm
wallynut (4/1/2009)
My Question is:Is it possible to set a table so no logging occurs for that selected table so ?
No.
Logging is never optional. It's essential for...
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
April 1, 2009 at 4:06 pm
TimC (4/1/2009)
GilaMonster (4/1/2009)
TimC (4/1/2009)
What am I missing?A transaction log backup.
Thanks GilaMonster.
Reading previous posts, I had a feeling that you were going to say that. 🙂
😀
Glad you appreciate 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
April 1, 2009 at 4:02 pm
Krishna Potlakayala (4/1/2009)
For a database using the full or bulk-logged recovery model, SQL Server 2005 requires in most cases that you back up the tail of the log before...
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
April 1, 2009 at 3:59 pm
Bruce W Cassidy (4/1/2009)
[font="Verdana"]All I can say is... thank goodness it's only an April Fool's joke! If that's a primer, I'd hate to see the advanced stuff.[/font]
The scary...
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
April 1, 2009 at 3:42 pm
psangeetha (4/1/2009)
I ran select @@version to find the service pack version for 2005 SQL server. I got the result that the SP is Service Pack 2.
I'm guessing that you saw...
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
April 1, 2009 at 3:38 pm
TimC (4/1/2009)
What am I missing?
A transaction log backup.
Do you have scheduled log backups? Could one of them have run between when you took the full backup and when you took...
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
April 1, 2009 at 3:32 pm
retheeshts (4/1/2009)
I am planning to replace some _wa_sys indexes with permenent indexes on the table.
Those aren't indexes
http://sqlinthewild.co.za/index.php/2008/11/04/what-are-statistics-and-why-do-we-need-them/
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
April 1, 2009 at 3:30 pm
Bruce W Cassidy (4/1/2009)
Too many authors in the field of relational theory have neglected the concept of Cardinal Reciprocity. This can cause a number of subtle problems with database design...
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
April 1, 2009 at 3:28 pm
ebenraja (4/1/2009)
Guys,I am not able to find anything abnormal with the SQL erorlogs and the System eventlogs. SQL logs are normal
What you posted there is a startup portion 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
April 1, 2009 at 3:27 pm
Do you know that you have corruption? If so, post details, if not, why are you considering 'allow_data_loss'?
What's the last few entries in the SQL error before the shutdown?
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
April 1, 2009 at 2:00 pm
Please post table definitions and sample data. Read this to see the best way to post this to get quick responses.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
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
April 1, 2009 at 12:12 pm
Why do you need to shrink it? If it's grown that large it means that something within your production workload needs a 16 GB tempDB. If you do somehow force...
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
April 1, 2009 at 12:01 pm
tianyongsun (4/1/2009)
select * from test where username = convert(varchar(256),user_name())
The plan for the first query is a clustered index scan, whereas the plan for...
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
April 1, 2009 at 12:01 pm
manoj kumar (4/1/2009)
I think, i can not change the structure of the extisting table because big application is running on that sturcture.
Change and rename the tables and then stick a...
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
April 1, 2009 at 10:23 am
Viewing 15 posts - 40,051 through 40,065 (of 49,552 total)