Viewing 15 posts - 1,276 through 1,290 (of 49,571 total)
ThomasRushton - Wednesday, June 14, 2017 4:23 AMHang on. You've got your test environment on the same hardware as your production environment?
I...
June 14, 2017 at 4:24 am
You don't need a group by on that query, as it has no aggregation.
Group By in SQL is used to do aggregations (sum, avg, count, min, max, etc) per...
June 13, 2017 at 10:49 pm
Short of DBCC Page, no.
Why are you interested?
June 13, 2017 at 3:12 pm
No, it's a hash index. The indexes you have for in-memory tables are either hash indexes or range.
Specifying HASH or NONCLUSTERED HASH gets you a hash index, specifying...
June 13, 2017 at 9:08 am
June 13, 2017 at 6:41 am
June 13, 2017 at 4:02 am
There wouldn't be, they do exactly the same thing.
Double-check what databases the checks were run on.
June 12, 2017 at 1:36 am
No, the stats are going to be up to date because you just created the index.
June 11, 2017 at 5:09 am
June 11, 2017 at 5:07 am
June 11, 2017 at 5:04 am
Reduce the fill factor slightly. Test and repeat until acceptable.
June 11, 2017 at 5:03 am
June 10, 2017 at 11:15 am
Viewing 15 posts - 1,276 through 1,290 (of 49,571 total)