Viewing 15 posts - 12,646 through 12,660 (of 49,556 total)
You can't append a trace to an existing file. Change the script so that it always creates a different file. Having the datetime in the file name is usually the...
June 20, 2013 at 3:48 am
aaron.reese (6/20/2013)
Thanks for the explanation guys, I learned something today.Actually 2 things. 1) scope and 2) yet another reason not to use subqueries
Correlated subqueries can be incredibly powerful, they're...
June 20, 2013 at 3:47 am
You don't need an off-schedule backup. Use your latest normal, scheduled backup and all log backups since that full backup.
June 20, 2013 at 3:04 am
Ok, so the 1st user is the one who has the most rows with their name in the ReviewedBy, the 2nd user is the one with the second most rows...
June 20, 2013 at 3:03 am
Position as determined by the data in what column?
If a user is number 15, what column determines that? What column value determines if a user is before that or after...
June 20, 2013 at 2:45 am
Position as per what column? What column in the table records that order?
June 20, 2013 at 2:15 am
Repair is usually the last option for when there's no good backup.
June 20, 2013 at 1:56 am
Please don't cross post. It just wastes people's time and fragments replies.
No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1465465-392-1.aspx
June 20, 2013 at 1:01 am
balasaukri (6/19/2013)
I tried the techniques those are mentioned in the link already but nothing released the memory.
Again, why are you trying to release memory? SQL needs that memory to...
June 20, 2013 at 12:57 am
vxhughes (6/19/2013)
June 19, 2013 at 4:10 pm
HildaJ (6/19/2013)
but we still see high memory utilization on both sql server and os memory.
Again, that is normal, expected behaviour.
June 19, 2013 at 3:55 pm
No way to answer that. Depends on too many factors including but not limited to row count and indexes.
Question doesn't even make sense, IN and AND are not in...
June 19, 2013 at 3:54 pm
Viewing 15 posts - 12,646 through 12,660 (of 49,556 total)