Viewing 15 posts - 10,096 through 10,110 (of 49,571 total)
Well, as I said you have to take log backups, it's not optional (unless you want to run out of disk space). Since you have to take log backups when...
February 6, 2014 at 5:07 am
Max server memory limits the buffer pool. SQL can use a small amount of memory in addition to that. If it's using too much, reduce max server memory
February 6, 2014 at 5:05 am
For a database to be mirrored, it must be in full recovery model. If you don't take log backups of a database in full recovery, your log will grow until...
February 6, 2014 at 4:24 am
SQLSteve (2/6/2014)
I never knew about formatteddatestring
That's just a column alias. You could alias the column 'Whatchamacallit' if you like, won't make any difference.
February 6, 2014 at 3:15 am
Once you've done a conversion it's a varchar, not a date. Cast (or assign) back to a date datatype and formatting is stripped away. Formatting a date is only relevant...
February 6, 2014 at 3:08 am
Dird (2/6/2014)
February 6, 2014 at 3:02 am
By default there are 6 files. You won't be able to delete the active log and to be honest you shouldn't be messing directly with files that SQL works with.
Why...
February 6, 2014 at 12:23 am
Don't use Task Manager to check SQL's memory, it lies. The labels on the values are also not as clear as they could be.
If SQL is still using too much...
February 5, 2014 at 2:22 pm
Evil Kraig F (2/5/2014)
....
DTA is a best effort guess from an app to try to help...
February 5, 2014 at 11:48 am
Evil Kraig F (2/5/2014)
February 5, 2014 at 11:14 am
Evil Kraig F (2/5/2014)
I was inaccurate about the intern level though, at least for the administration test. My bad, thanks for clarifying that for me/us.
That quote was actually from...
February 5, 2014 at 10:22 am
sanku.raghuram (2/5/2014)
Sorry for mis confusion and comming to Shawpoint-- you mean replication and transaction logshipping will work together.In that which order we go fist ,,
Yes they do and either order....
February 5, 2014 at 10:21 am
MinhTuCSharper (2/5/2014)
February 5, 2014 at 10:20 am
Maybe a server-side trace to identify what's happening.
February 5, 2014 at 3:22 am
Viewing 15 posts - 10,096 through 10,110 (of 49,571 total)