Viewing 15 posts - 4,426 through 4,440 (of 49,552 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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 22, 2015 at 4:39 am
peter 82125 (10/21/2015)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 22, 2015 at 2:38 am
http://sqlinthewild.co.za/index.php/2010/01/12/in-vs-inner-join/
http://sqlinthewild.co.za/index.php/2009/08/17/exists-vs-in/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 21, 2015 at 2:15 pm
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 21, 2015 at 10:39 am
Please note, three year old thread.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 21, 2015 at 10:35 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,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 21, 2015 at 6:55 am
Not quite sure I follow. What should be the output from the sample data listed?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 21, 2015 at 6:49 am
Viewing 15 posts - 4,426 through 4,440 (of 49,552 total)