Viewing 15 posts - 22,261 through 22,275 (of 39,824 total)
That's a good point, Ian, but that depends on how the values are pulled out. The application might constrain the domain of items that are used.
If there need to be...
September 21, 2009 at 8:59 am
It will release memory to the OS if there is pressure, albeit slowly.
If you want SQL to use less, set a max limit that's lower. Otherwise, ignore it. SQL is...
September 21, 2009 at 8:53 am
One thing I'd be concerned about is an app pointed at the wrong server. Are the db names the same as production?
I''m sure your trace will show something.
September 21, 2009 at 8:01 am
The thing I think is that does "locked" matter if it's a product or customer?
In my example, I'd still have the status table. I typically have had ID, name, and...
September 21, 2009 at 7:58 am
It's got to be network or I/O limiting your ability to catch up. You mentioned a backup, is this part of nightly maintenance? Any chance that indexing was going on?...
September 21, 2009 at 7:54 am
I'd use SteveB's suggestion. Add a T-SQL task, calculate a date, branch based on the result.
September 21, 2009 at 7:52 am
Maintenance cleanup task for the files
History Cleanup for the log files (text)
Add it to your maintenance plan and point it to the folder.
September 21, 2009 at 7:51 am
The diff changes the LSN, so I'd expect this to work. The Diff would pick up all changes done in simple mode and then you could resume log backups.
I think...
September 21, 2009 at 7:44 am
It's not just a question of ego, it's more a question of matching things up properly. I've seen many people say they need access to get their job done. Developers...
September 21, 2009 at 7:42 am
You can change it back to something else. "Sam" is likely taken, but you could pick something else.
We announced it here: http://www.sqlservercentral.com/articles/SQLServerCentral/68122/
September 21, 2009 at 7:39 am
Brad,
Let us know how it is, or write a review and send it in.
September 21, 2009 at 7:37 am
Thanks for the update. My other suggestion for checking (for others reading this) is to look for triggers. Sometimes they prevent something from committing.
September 21, 2009 at 7:34 am
Has to be activity. Maintenance plans? Checked the default trace?
September 21, 2009 at 7:33 am
A trace would be the best way to do this. C2 can add lots of overhead, but you'd have to determine if that is the scope of data you needed....
September 21, 2009 at 7:32 am
My argument would be "no", since on x32, it's required to get more than 4GB addressed.
September 21, 2009 at 7:31 am
Viewing 15 posts - 22,261 through 22,275 (of 39,824 total)