Viewing 15 posts - 30,031 through 30,045 (of 49,552 total)
Michael Valentine Jones (10/12/2010)
You go through this whole series of explanations every day with new people, even debunking the inevitable “truncate the log and shrink the database” suggestion.
Yeah, I really...
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
October 12, 2010 at 10:39 am
After a meeting this morning there are several things that I would love to rant about at length. However it might get ugly. Hence I will restrain myself to three...
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
October 12, 2010 at 10:31 am
Run a server-side trace
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
October 12, 2010 at 8:19 am
jamesmario (10/12/2010)
Any backup & restore script for both Full DB backup & Diff backup?
Have you looked in Books Online? (The SQL manual)
Can i restore Diff. db backup on 8pm Full...
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
October 12, 2010 at 8:17 am
Lowell (10/12/2010)
GilaMonster (10/12/2010)
SELECT * FROM master.sys.objects -- 74 rows
IF (1=1)
SELECT @@ROWCOUNT AS RowsAffected -- 0, because the IF did 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
October 12, 2010 at 6:59 am
Lowell (10/12/2010)
every insert/update/select/set/delete statement resets the @@rowcount to the rows affected by the executed statement
It's more general than that. It's just about every statement.
SELECT * FROM master.sys.objects -- 74...
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
October 12, 2010 at 6:28 am
Paul White NZ (10/12/2010)
GilaMonster (10/11/2010)
This site was somewhere between terrifying and hilarious - http://www.allinterview.com/showanswers/65496.html
Terrifying. Maybe I will experience some of the humour later, but for now, I'm just plain...
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
October 12, 2010 at 6:15 am
pietlinden (10/11/2010)
...but never any really good explanation of WHEN or WHY. I would find a little bit on the when and why really helpful...
There's a running joke 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
October 12, 2010 at 12:08 am
CirquedeSQLeil (10/11/2010)
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
October 11, 2010 at 11:58 pm
jamesmario (10/11/2010)
My concern is, how to reply on the diff backup.
Reply?
Has anyone experienced any data loss in this approch?
Diff backups contain all data that changed between the time of 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
October 11, 2010 at 11:51 pm
pietlinden (10/11/2010)
When, if ever, should you truncate the log file?
Generally, never.
If there has been poor (no) management of the log before, or log backups have been failing for days...
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
October 11, 2010 at 11:45 pm
chrisn-585491 (10/11/2010)
Now that I'm engaged, I get treated better. (WTF?!) :angry:
Some 8 years ago I got put high on the company's retrenchment list (they'd hit financial difficulties) because I 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
October 11, 2010 at 4:02 pm
Partitioning a disk into multiple logical drives is pointless for SQL. You may as well leave it as one large drive and put everything on it.
Multiple disks gives you multiple...
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
October 11, 2010 at 3:57 pm
AndrewSQLDBA (10/11/2010)
I want to restore the Full from the primary box to the secondary box once a week
You only need to do this once. Restore with standby if you want...
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
October 11, 2010 at 3:51 pm
Make sure you have a backup first. Just in case.
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
October 11, 2010 at 2:35 pm
Viewing 15 posts - 30,031 through 30,045 (of 49,552 total)