Jeff Moden (11/17/2015)

What is the table used for? For example, is it an...

Yeah, it is just sad that we define a clustered index, therefore ordered, with two variables that are of the same data type withing the scope of the query, and...

Thanks

I know that I can use parameter sniffing in here, but the overall problem if that for sure we have hundreds, if not thousands of queries that are doing stuff...

Thanks

I will do something similar, add a new file group and move those tables over there

as an update the sort in tempdb didn't work...

The latency between the primary and secondary replica (synchronous) is only 5ms

I am at a loss here, not sure what else should...

Well, I am just saying the behavior I do see in there

It is not production yet, but that will be next week and I do need a proper maintenance plan...

This is not in production yet so I was testing the maintenance jobs, the replicas are getting the logs properly and on regular use the backup strategy is able to...

thanks to all, there was also something wrong in the configuration of the listener, that is why I was seeing a "weird" behavior

Thanks, I was able to solve the non-issue, the...

as to add some more info, at AD the cluster and all its nodes are not at the default OU...

as to add some more info, at AD the cluster and all its nodes are not at the default OU...

Well, after playing with it for a while I used the "Shrink database" option and that was able to release all the space, not pretty but it was able to...

Alvin Ramard (6/9/2015)

ricardo_chicas (6/9/2015)

I have a 50gb database, with 3 files at the primary filegroup, each one of those has around 16gb

I truncated 2 tables releasing 33gb, so the...