Viewing 15 posts - 36,106 through 36,120 (of 49,552 total)
Bob Hovious 24601 (10/27/2009)
Grant, I'm a poor substitute for Jeff, but I'd be happy to have a drink with you next week. I'll even buy the first round.
I...
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 27, 2009 at 7:29 am
Jeff Moden (10/26/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
October 27, 2009 at 7:23 am
It's very hard to max out all of the CPUs on modern multi-proc machines. Very few workloads are limited by CPU bottlenecks. Far more common are memory/disk. It's very likely...
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 27, 2009 at 7:23 am
Tara-1044200 (10/27/2009)
I assume when this is executed it has to delete the existign backup and do fresh copy of backup but it i think it is not deleting the existing...
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 27, 2009 at 7:18 am
Post code?
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 27, 2009 at 5:48 am
http://sqlinthewild.co.za/index.php/2009/06/09/deleting-the-transaction-log/
Casually mentioned here as the cause for RECOVERY_PENDING state
What you have to do if you get your DB into that state, and the consequences
As for documentation, I doubt there's 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
October 27, 2009 at 5:45 am
sahoong (10/27/2009)
RESTORE DATABASE CELCAT_LIVE_0910
FROM DISK =...
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 27, 2009 at 5:33 am
Brandie Tarvin (10/27/2009)
The transaction log file is "optional" in the sense that you can attach a DB without it and SQL Server will create a new one.
Usually. Not always.
However,...
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 27, 2009 at 5:29 am
How are you viewing the log? If you're using the gui window, make sure that the latest log file is selected.
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 27, 2009 at 3:22 am
allen davidson (10/27/2009)
Thanks Gail, I'll redo the index (didn't realise the order was important).
Think of a telephone book. Essentially an index of people with surname as the leading column, initial,...
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 27, 2009 at 3:22 am
Yes, though secondary data files are usually given the .ndf extension. Look up ALTER DATABASE in Books online for the syntax for adding a data file. To move specific tables,...
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 27, 2009 at 3:16 am
mahesh.vsp (10/27/2009)
While shrinking the Transaction log file, we are using the below command
What will happen internally when i use this command?
BACKUP LOG <dbname> WITH TRUNCATE_ONLY
Where does the backup getting...
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 27, 2009 at 1:49 am
mahesh.vsp (10/27/2009)
Question is, do we need to attach the .ldf along with .mdf file?
Yes, absolutely. The transaction log is not an optional file
Is there any use of that, or else...
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 27, 2009 at 1:43 am
Lynn Pettis (10/26/2009)
Don't you just love people that only read half the error message?
Yup, but not as much as those who don't read any of the error message. (No examples...
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 26, 2009 at 3:45 pm
Sanjiv-193662 (10/26/2009)
After 2hrs and 45 minutes I cancelled the above query. Now it is trying to cancel the query for more than 45 minutes.
SQL has to roll the changes back....
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 26, 2009 at 3:44 pm
Viewing 15 posts - 36,106 through 36,120 (of 49,552 total)