Viewing 15 posts - 766 through 780 (of 1,319 total)
Perhaps you don't have the help compiler installed (not sure why you wouldn't)? Check out:
http://www.ec-software.com/downloads_mscomp.html
-- You can't be late until you show up.
March 2, 2009 at 12:42 pm
Roy Ernest (2/27/2009)
Today is the first day that I noticed that there are two GSquared's.... 🙂GSquared original and a G raised to 2. Both answered on the same thread....:hehe:
There is...
-- You can't be late until you show up.
February 27, 2009 at 2:21 pm
Did you determine why the log got so big? 25Xdata is not normal. I'm guessing you have the database in full recovery but never backup the transaction log???
-- You can't be late until you show up.
February 27, 2009 at 10:54 am
Stamey (2/26/2009)
The updates are the worst offenders and make the log the largest because the log has the before and after in it.Chris
And that's because it's really a delete and...
-- You can't be late until you show up.
February 26, 2009 at 12:59 pm
Vidya (2/26/2009)
Also, when I have...
-- You can't be late until you show up.
February 26, 2009 at 8:41 am
I wouldn't sweat the small stuff. You should be honored so many people with your name are in your field as well. You could always come up with a more...
-- You can't be late until you show up.
February 26, 2009 at 8:29 am
Vidya (2/26/2009)
Is there a way to restore only the data and not the structure of the database (table structure, stored procedures, etc)?
My situation is that we are moving the...
-- You can't be late until you show up.
February 26, 2009 at 7:52 am
How often are you backing up? I have maintenance plans that delete files older than 2 weeks and have never seen it fail to do it. How big are your...
-- You can't be late until you show up.
February 26, 2009 at 7:36 am
I agree. You've got two resource-intensive jobs running and competing for CPU. They'll finish eventually but obviously the process will run longer. How are you removing unused space from the...
-- You can't be late until you show up.
February 26, 2009 at 7:32 am
If the below command doesn't return the backup info, including compatability level (SQL version), it may very well be corrupt. If so, I know of no way to get it...
-- You can't be late until you show up.
February 26, 2009 at 7:05 am
Atul DBA (2/26/2009)
This may be correct and may not be.
Absolutely. Truncating a table of 3.3 million rows at my job added about 200MB to the log but by using...
-- You can't be late until you show up.
February 26, 2009 at 7:02 am
aks_pra (2/26/2009)
Hi ,I am Having Sql Server SP4 pak.
I wanted to Attached database without LDF file.
B’coz my LDF size is greater than the MDF
Thanks and Regards,
Pravin
If your database is...
-- You can't be late until you show up.
February 26, 2009 at 6:42 am
GSquared (2/25/2009)
-- You can't be late until you show up.
February 25, 2009 at 3:13 pm
Jeff Moden (2/23/2009)
Books Online (comes free with SQL Server)
Well put. I'll be plagiarizing that in the future. 😀
-- You can't be late until you show up.
February 24, 2009 at 12:45 pm
Viewing 15 posts - 766 through 780 (of 1,319 total)