Viewing 15 posts - 41,191 through 41,205 (of 49,571 total)
Back the log up more often. Maybe hourly. The more often you back it up, the less likely it is to grow large.
You can shrink it, but unless you change...
February 7, 2009 at 2:12 am
peace2007 (2/7/2009)
However, it doesn't let me change the properties, is there any other way to do that?
Alter database. Check BoL, it has an example on moving tempdb on the alter...
February 7, 2009 at 2:10 am
Separate filegroups, or all in primary?
If you have lots of filegroups will small tables, I'd probably try merging them and dropping the empty filegroups, on dev (of course) and testing...
February 7, 2009 at 2:03 am
Paresh Prajapati (2/5/2009)
I asked network peoples but the don't know how this is access by from this IP..
Ask them to find out. Network security is their business and an unknown...
February 6, 2009 at 1:46 pm
On databases created in 2005, or ones from earlier versions where the data purity check has run once successfully, that option is default and all checkDB executions (excluding ones where...
February 6, 2009 at 1:38 pm
Which edition of SQL 2008 do have? There's no basic edition. There's express (free), web, workgroup, standard, enterprise and developer.
February 6, 2009 at 1:20 pm
Have a look through these:
http://msdn.microsoft.com/en-us/subscriptions/subscriptionschart.aspx - Different MSDN subscriptions
http://technet.microsoft.com/en-us/subscriptions/bb892756.aspx - Different Technet subscriptions
http://msdn.microsoft.com/en-us/subscriptions/dd362338.aspx - Comparison between technet and MSDN
February 6, 2009 at 7:59 am
Grant Fritchey (2/6/2009)
As an aside, too many indexes will slow down inserts, but the right indexes, especially the right clustered index, will speed up insertions.
Indeed, and by too many...
February 6, 2009 at 7:38 am
Continued here - http://www.sqlservercentral.com/Forums/Topic651434-5-1.aspx
No more replies to this thread please.
February 6, 2009 at 1:09 am
Krishna (2/6/2009)
and finally Tail Backup with STOPAT (Recovery)
You only need STOPAT if there are some commands in the log that you don't want to restore (for eg a user dropping...
February 6, 2009 at 12:10 am
Depends how the DB crashed.
If the log is still accessible and SQL's still running, then you back up the tail of the log (no truncate, no recovery options), and restore...
February 6, 2009 at 12:01 am
Those are typically monitored through Performance Monitor (The windows tool), not through SQL.
February 5, 2009 at 11:59 pm
krypto69 (2/5/2009)
I looked into using plan guides.
Don't. Plan guides are a last resort fix for a query that's always generating a bad plan and that cannot be changed. They're...
February 5, 2009 at 11:55 pm
You can't. If you did not start an explicit transaction, then the changes were committed as soon as the statement completed and no rollback is possible
February 5, 2009 at 11:49 pm
shivani.suri2 (2/5/2009)
Need a suggestion...
As has been mentioned several times, use the status column. That is populated even for traces running through profiler. The status will tell you if the trace...
February 5, 2009 at 11:43 pm
Viewing 15 posts - 41,191 through 41,205 (of 49,571 total)