Viewing 15 posts - 16,516 through 16,530 (of 49,552 total)
Anyone got time to help out here http://www.sqlservercentral.com/Forums/Topic1362892-391-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
September 21, 2012 at 4:51 pm
Leeland (9/21/2012)
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
September 21, 2012 at 3:08 pm
2ndHelping (9/21/2012)
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
September 21, 2012 at 3:05 pm
That's default growth increments, as I said, you probably want larger growth increments.
Growing a file manually - ALTER DATABASE ... ALTER FILE
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
September 21, 2012 at 2:18 pm
Not talking about the backup process itself.
The IO subsystem could incorrectly write the file. It could mangle the file after backing it up, it could corrupt the file during 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
September 21, 2012 at 2:15 pm
I never said the checksum was enough to ensure that it would restore correctly. I said if it restores correctly and the backup and restore were done with checksum, then...
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
September 21, 2012 at 1:27 pm
No, because backing up a corrupt database WITH CHECKSUM will fail (it checks the page checksums as it backs up). Hence, if a backup taken WITH CHECKSUM restores successfully WITH...
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
September 21, 2012 at 1:08 pm
Please post exact error messages. Also check the SQL error log for more errors.
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
September 21, 2012 at 12:57 pm
If the database restores you can be pretty sure that it is exactly as it was at the time of backup. Want to be completely sure, run CheckDB on 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
September 21, 2012 at 12:54 pm
Larger growth increments (fixed MB), grow TempDB manually, ensure there's enough space on the drive, tune the queries to use less TempDB.
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
September 21, 2012 at 12:31 pm
Checking memory's valid, but it would hardly be the first thing I'd 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
September 21, 2012 at 11:08 am
Firstly, don't use Task Manager to check SQL's memory, it can be very wrong.
The max server memory affects the buffer pool size. There's additional memory used outside of the buffer...
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
September 21, 2012 at 11:04 am
stevro (9/21/2012)
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
September 21, 2012 at 10:04 am
Stefan Krzywicki (9/21/2012)
capnhector (9/21/2012)
ok im breaking out my "Realy? WTF" card on the behaviour twards the end of http://www.sqlservercentral.com/Forums/Topic1357081-392-3.aspx. did we really hit Godwin's law?
Wow, I frequently disagree with...
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
September 21, 2012 at 9:51 am
Just asking if you wanted to think about that some more... 😉
Local variables in a procedure do not automatically result in recompiles of that plan. Plans that involve local variables...
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
September 21, 2012 at 9:48 am
Viewing 15 posts - 16,516 through 16,530 (of 49,552 total)