Viewing 15 posts - 16 through 30 (of 5,842 total)
I have run 500+ MILLION row (uncompressed) table queries on my LAPTOP, taking < 10 seconds each time.
My experience says that indexing is not even close to...
February 13, 2018 at 2:05 pm
February 13, 2018 at 1:59 pm
Did you try the query with OPTION (RECOMPILE) at the end of it?
February 12, 2018 at 10:52 pm
February 10, 2018 at 6:41 am
1) I have had clients REMOVE replication (both forms) because of it, well, being problematic (or worse). Bi-directional data modification/synchronization is just about the hardest nut to crack in all...
February 8, 2018 at 10:46 am
February 8, 2018 at 9:26 am
February 8, 2018 at 9:22 am
Thanks for the thoughts.
The Koenigseggs are FAR more than pure art. There is some SPECTACTULAR engineering function behind their form!! 🙂
February 7, 2018 at 8:21 pm
Dynamic SQL is how I would go (guarding against SQL Injection, obviously). That will allow you to remove the ORs completely because you will KNOW what was passed in because...
February 7, 2018 at 10:28 am
February 7, 2018 at 10:24 am
February 7, 2018 at 5:56 am
February 7, 2018 at 4:36 am
February 6, 2018 at 3:56 pm
Ahh, an extra de-reference. Works for me.
I never expect compression to be available though because the vast majority of SQL Server instances are not Enterprise Edition (or 2016SP1+,...
February 6, 2018 at 3:55 pm
February 6, 2018 at 1:15 pm
Viewing 15 posts - 16 through 30 (of 5,842 total)