Viewing 15 posts - 12,256 through 12,270 (of 49,558 total)
Chris-475469 (7/23/2013)
July 24, 2013 at 2:06 am
Checkpoint writes all modified pages to disk.
July 23, 2013 at 4:28 pm
curious_sqldba (7/23/2013)
i) if a table has no clustered index and has non-clustered indices, do i need to compress the table first and then the nc indices?
Depends. Do you want the...
July 23, 2013 at 12:50 pm
Please note: 3 year old thread. New questions in a new thread please.
July 23, 2013 at 8:19 am
Can you also add the following to the procedure and to the ad-hoc SQL and post the output
SELECT SESSIONPROPERTY(ANSI_NULLS), SESSIONPROPERTY(ANSI_PADDING)
July 23, 2013 at 6:48 am
Rob-350472 (7/23/2013)
July 23, 2013 at 6:36 am
Perhaps unrelated (or perhaps not), but those nolocks are going to cause you problems at some point.
See - http://blogs.msdn.com/b/davidlean/archive/2009/04/06/sql-server-nolock-hint-other-poor-ideas.aspx
July 23, 2013 at 6:19 am
Koen Verbeeck (7/23/2013)
So you're saying that if a restore a filegroup (primary and maybe others), all the other filegroups are taken offline?
They can't be online, because they're not there. The...
July 23, 2013 at 5:38 am
Koen Verbeeck (7/23/2013)
July 23, 2013 at 5:16 am
If they're producing different results, then there must be a difference somewhere in code or connection settings. There's no hidden 'return different results' properties of a procedure, there's no hidden...
July 23, 2013 at 4:59 am
Can you post the two pieces of code?
July 23, 2013 at 4:50 am
A backup does a huge amount of IO. If your system is not bottlenecked on IO, if the additional load the backup puts in place doesn't impact queries trying to...
July 23, 2013 at 3:51 am
Viewing 15 posts - 12,256 through 12,270 (of 49,558 total)