Viewing 15 posts - 14,866 through 14,880 (of 49,552 total)
Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
January 10, 2013 at 9:54 am
opc.three (1/10/2013)
. Online index rebuilds do not block anything regardless of the isolation level.
Kinda...
Online index rebuilds are mostly online. They take a short-lived IX lock at the beginning (which blocks...
January 10, 2013 at 7:55 am
heino.zunzer (1/10/2013)
Just wondering if a solution with replication is the right approach here.
Doesn't sound like it. I'd be considering service broker here.
Replication replicates everything, inserts, updates and deletes.
January 10, 2013 at 7:52 am
A replication publication has to be initialised. Your choices are init from snapshot or init from backup, but there's no option of 'do not initialise'
If you're just replicating one...
January 10, 2013 at 5:58 am
Where are these test questions from?
January 10, 2013 at 5:52 am
The log file is automatically reused. There are no settings or options you need to change to make this the case. If you're in full recovery model, a log backup...
January 10, 2013 at 3:46 am
Jason-299789 (1/10/2013)
January 10, 2013 at 3:44 am
Please note: 2 year old thread.
January 10, 2013 at 12:03 am
ScottPletcher (1/9/2013)
If SQL needs only key column(s), why does it read all the leaf pages of the table as well?? That's an incredible waste of I/O.
The only place...
January 9, 2013 at 11:10 pm
opc.three (1/9/2013)
GilaMonster (1/9/2013)
opc.three (1/9/2013)
The nice thing is that no queries need to change, not even the ones with the NOLOCK hint applied, and you'll automatically get transactionally consistent reads.
Queries...
January 9, 2013 at 2:00 pm
opc.three (1/9/2013)
The nice thing is that no queries need to change, not even the ones with the NOLOCK hint applied, and you'll automatically get transactionally consistent reads.
Queries with nolock...
January 9, 2013 at 1:46 pm
Robert Davis (1/9/2013)
GilaMonster (1/9/2013)
robert.nesta123 (1/9/2013)
Changing NON CL PK to Clustered can have a negative impact?Oh yes, especially if the PK column is not a good one for a clustered index.
Additionally,...
January 9, 2013 at 1:31 pm
robert.nesta123 (1/9/2013)
Changing NON CL PK to Clustered can have a negative impact?
Oh yes, especially if the PK column is not a good one for a clustered index.
If so what is...
January 9, 2013 at 1:20 pm
robert.nesta123 (1/9/2013)
PK is written into all NON Clustered index.
No it's not. The clustered index key is what is in all nonclustered indexes, not the primary key.
So changing from NON...
January 9, 2013 at 12:50 pm
Changing a nonclustered index to a clustered index involved rebuilding the entire table and every single nonclustered index on that table (the data pages have to move, the nonclustered indexes...
January 9, 2013 at 12:04 pm
Viewing 15 posts - 14,866 through 14,880 (of 49,552 total)