Viewing 15 posts - 38,626 through 38,640 (of 49,571 total)
Krishna Potlakayala (6/8/2009)
Yes, the server is recovering the database. Was there any sudden shut down of the SQL Server? Just wait till it comes back online again.
That's true of...
June 8, 2009 at 5:45 am
In SQL Server triggers fire once per statement. There is no row trigger in SQL Server. The trigger fires once and all the affected rows are present in the inserted...
June 8, 2009 at 5:44 am
Recovery pending means that for some reason SQL cannot run restart recovery on the database. Usually this is because the log is missing or corrupt.
"G:\Data\MSSQL\Database.mdf".
"G:\Data\MSSQL\Data\Database_log.ldf"
Do these files exist? Is the...
June 8, 2009 at 5:43 am
When the log file is grown, the VLFs in the old portion are left as they are and new ones created for the new section. If you want to 'reset'...
June 8, 2009 at 3:14 am
b.ozga (6/8/2009)
Do you know a way to attach\create database on a disk which is not SQL Server dependency but it is in a cluster group? Any help appreciated.
Can't be done....
June 8, 2009 at 3:03 am
You'll have to restore the backup. There's no tool I know of that reads inside a SQL backup.
June 8, 2009 at 3:01 am
vivek (6/1/2009)
then did we saw any difference? Can you share it with us?
** I capture the execution plan...
June 8, 2009 at 2:59 am
They are. I'm just wondering if there's something missing around the provisioning tool with SP3. It's not something I've ever tested, so can't be sure either way.
Install SP2, make sure...
June 8, 2009 at 2:50 am
It is not.
Shrinking causes massive fragmentation and will just result in the data file growing again next time data gets added. When that happens, the entire system will slow down...
June 7, 2009 at 4:16 pm
Try installing SP2 before SP3. The prov tool launches automatically at the end of SP2
June 7, 2009 at 4:04 pm
RBarryYoung (6/7/2009)
June 7, 2009 at 2:59 pm
On Vista the administrator user no longer has automatic rights to SQL. The provisioning tool should have come up at the end of the service pack installation to allow you...
June 7, 2009 at 1:05 pm
Is this an agreement party? 😉
One other book I'd recommend, more for development than admin. T-SQL Fundamentals by Itzik Ben-Gan. It's written for SQL 2008, not 2005, but they are...
June 7, 2009 at 5:22 am
Paul White (6/7/2009)
I mentioned it because I based my first post on the content of pages 199-200.
Yeah, I noticed the similarity between your post and the book when I checked...
June 7, 2009 at 5:17 am
Paul White (6/7/2009)
Inside Microsoft Sql Server 2005: Query Tuning and Optimization - K Delaney et al.ISBN-13: 978-0-7356-2196-1
ISBN-10: 0-7356-2196-9
(I just happened to have a copy to hand ;-))
Nope. Algebriser doesn't even...
June 7, 2009 at 4:49 am
Viewing 15 posts - 38,626 through 38,640 (of 49,571 total)