Viewing 15 posts - 11,791 through 11,805 (of 39,963 total)
New persopn (10/28/2013)
For one week i have monitored the log in weekends it is occupying 25% space so can anyone please update me on this.
That sentence makes no sense.
If you...
October 31, 2013 at 2:24 pm
I won, even with a few poeple on byes.
This week is predicted to be tight. I feel like Dalton plays better than Newton, but with the matchups, and the collapse...
October 31, 2013 at 2:18 pm
GilaMonster (10/31/2013)
krowley (10/31/2013)
October 31, 2013 at 12:36 pm
If you monitor using perfmon over time, memory is the same as other counters. If you don't know how to create a log file using perfmon, then search on MSDN...
October 31, 2013 at 12:29 pm
There are numerous scripts on this site. Search for copy backup files in the bar above.
October 31, 2013 at 12:29 pm
If you have data that is encrypted at a cell level (symmetric/asymmetric encryption), you can't query to determine the data is encrypted.
October 31, 2013 at 12:25 pm
Thomas Abraham (10/31/2013)
BTW, I was surprised Steve didn't slip in a humorous Halloween question. I look forward to those holiday questions.
If you celebrate such things, Happy Halloween! Hope you get...
October 31, 2013 at 10:19 am
You need to escape things. I suspect this is an interpretation of the two slashes and the "n"
October 30, 2013 at 6:37 pm
If you struggle getting things going, master and the error log paths are in the service applet. Once you get that to start with new paths, you can do the...
October 30, 2013 at 11:39 am
In production, you would load in batches, and run log backups during the load to keep the size manageable.
October 30, 2013 at 11:38 am
In process. I hope to have #1 out in the next month.
October 30, 2013 at 11:33 am
That time to restore is based on getting the file lists from the drives. The time seems to vary, but I'm not sure the number of drives attached is the...
October 30, 2013 at 11:32 am
varchar(max) should allow 2GB of space. Are you sure this is what the field is set to? How are you determining the 11kb will not fit?
This works:
create table mytest...
October 30, 2013 at 11:15 am
As Keith mentioned, it will vary, depending on your system. The truncate should be fairly quick, but the logging of the deallocations might take some time and will increase your...
October 30, 2013 at 11:04 am
Viewing 15 posts - 11,791 through 11,805 (of 39,963 total)