Viewing 15 posts - 40,066 through 40,080 (of 49,571 total)
David Rueter (4/1/2009)
CREATE PROCEDURE spTest
AS
BEGIN
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
--We expect isolation level to be READ COMMITTED
...do something...
April 2, 2009 at 2:19 am
It sounds like you have intermittent IO errors. Are you seeing any errors in the SQL error log or the windows error log?
SAN or direct attached storage? Raid level?
If I...
April 2, 2009 at 2:17 am
suhasini.m (3/27/2009)
2. What does Scan Count exactly mean. And howz it related to IO.?
The scan count is actually not that useful. It should indicate how many times an object is...
April 2, 2009 at 2:05 am
ebenraja (4/1/2009)
Let me know the ways to find if the tables are corrupted as if i run the check command the server restarts.
What is the exact command that you are...
April 1, 2009 at 4:50 pm
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...
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...
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.
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...
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...
April 1, 2009 at 3:42 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...
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/
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...
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...
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?
April 1, 2009 at 2:00 pm
Viewing 15 posts - 40,066 through 40,080 (of 49,571 total)