Viewing 15 posts - 4,426 through 4,440 (of 49,571 total)
cyp901 (10/22/2015)
EXISTS is also safer than IN when you're dealing with a nullable column.
That's NOT IN. IN has no behavior differences with NULL, it's negation does.
October 22, 2015 at 11:07 am
Could you get more details on what is actually required?
The only 'listener' I'm familiar with is the Availability Groups listener, which is part of the Availability Groups HA feature, introduced...
October 22, 2015 at 6:22 am
If it's not a major issue, then just leave it as-is. I suspect fixing this will require you to recreate the DB (script, export, recreate new DB), which probably wouldn't...
October 22, 2015 at 4:39 am
peter 82125 (10/21/2015)
October 22, 2015 at 2:38 am
dndaughtery (10/21/2015)
Yeah its between the CTE's and main query. Need that value for some math
Then that's the cause of the error. A CTE is only valid for the (single) query...
October 21, 2015 at 10:39 am
The only person who can say whether it's worth buying Enterprise edition for Availability Groups is you (well, your business), but consider that HA/DR is like security. Defend in depth,...
October 21, 2015 at 8:32 am
Grant Fritchey (10/21/2015)
GilaMonster (10/21/2015)
Grant Fritchey (10/21/2015)
GilaMonster (10/20/2015)
I'll probably do my usual, look at the schedule over breakfast and decide then what I want to see.
There are sessions that we get...
October 21, 2015 at 7:48 am
Please post exact results of:
USE epTracking_dbOld
GO
SELECT i.object_id, i.name, i.index_id, i.type, i.is_unique, i.is_hypothetical, i.is_disabled, i.has_filter FROM sys.indexes AS i
WHERE i.object_id = 53575229 AND i.index_id = 9
SELECT ps.partition_id, ps.object_id, ps.index_id, ps.partition_number, ps.row_count...
October 21, 2015 at 7:46 am
Err, what? There are no personal ID numbers in a checkDB output, just page numbers, allocation units, partition IDs, table IDs.
Please paste the entire thing without any editing.
October 21, 2015 at 7:29 am
Grant Fritchey (10/21/2015)
GilaMonster (10/20/2015)
I'll probably do my usual, look at the schedule over breakfast and decide then what I want to see.
There are sessions that we get to attend? Huh....
October 21, 2015 at 7:18 am
I didn't say you'd run repair. I said I can't see *why* repair allow data loss is recommended. Is that the exact, complete output from CheckDB with no changes, no...
October 21, 2015 at 7:16 am
I can't see why that is a repair_allow_data_loss for a nonclustered index. Is that the complete, unedited output?
Are you sure you ran the DROP from the correct database? It looks,...
October 21, 2015 at 6:55 am
Not quite sure I follow. What should be the output from the sample data listed?
October 21, 2015 at 6:49 am
Viewing 15 posts - 4,426 through 4,440 (of 49,571 total)