Viewing 15 posts - 36,121 through 36,135 (of 49,562 total)
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...
October 27, 2009 at 5:45 am
sahoong (10/27/2009)
RESTORE DATABASE CELCAT_LIVE_0910
FROM DISK =...
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,...
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.
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,...
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,...
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...
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...
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...
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....
October 26, 2009 at 3:44 pm
lharmes (10/26/2009)
October 26, 2009 at 2:53 pm
Go into cluster admin and shut the SQL instance down. Make sure it doesn't try to restart.
Open a command prompt. Navigate to the directory where the SQL executable is and...
October 26, 2009 at 2:29 pm
jbuttery (10/26/2009)
Perhaps you could cover statistics one day and how they relate to indexes.
Next week Thursday, 4pm Seattle time.
http://summit2009.sqlpass.org/Agenda/SpotlightSessions/Liesdamnedliesandstatistics.aspx
October 26, 2009 at 2:19 pm
SQL Noob (10/26/2009)
October 26, 2009 at 2:13 pm
allen davidson (10/26/2009)
CREATE NONCLUSTERED INDEX [IX_EmailAddress] ON [dbo].[tblCustomers]
(
[emailaddress] ASC,
...
October 26, 2009 at 2:09 pm
Viewing 15 posts - 36,121 through 36,135 (of 49,562 total)