Viewing 15 posts - 7,471 through 7,485 (of 59,072 total)
Afaik and imo there are no pros only cons. There is no such thing as a "gap" in a primary key because 'unit consistency' is not a...
March 24, 2020 at 4:53 pm
Understood but, unless specifically stated (and I found this out the hard way a long time ago), the QOTD questions are based on the current version of SQL and do...
March 24, 2020 at 4:42 pm
Doesn't this work only provided that the delimiter is a period?
Yes.
March 24, 2020 at 4:09 pm
Just to be sure, I appreciate anyone willing to step up and write articles to share their knowledge with other people especially when they come up with such a different...
March 23, 2020 at 11:05 pm
Grant - just reading your wordpress blog - it strikes me that I'm missing some skills in monitoring SSRS and SSIS using XE... might be a nice...
March 23, 2020 at 10:37 pm
The President just reported success with the malaria drugs and sited a specific episode where a guy was dying from Covid-19 and had been both written off and had said...
March 23, 2020 at 10:33 pm
Mmmmm... maybe. I've frequently seen where striped backups and restores actually take longer, just like parallelism can sometimes have adverse effects.
March 23, 2020 at 4:58 pm
If you're going to make dynamic SQL for the WHERE clause, there's a right way to do it and using EXEC() is NOT the right way. Please see the following...
March 23, 2020 at 3:53 pm
Afaik and imo there are no pros only cons. There is no such thing as a "gap" in a primary key because 'unit consistency' is not a necessary attribute. ...
March 23, 2020 at 3:43 pm
Grant - just reading your wordpress blog - it strikes me that I'm missing some skills in monitoring SSRS and SSIS using XE... might be a nice topic
we all...
March 23, 2020 at 3:33 pm
LOL, I'm fairly clean when I cook, washing pots and dishes while I can. I like to have things relatively clean and neat when I'm done.
Now my FIL, I'm...
March 23, 2020 at 3:28 pm
There's really no difference for me. It's all kind of like the cartoon at the following link except I have a white beard. 😀
March 23, 2020 at 3:10 pm
Shifting gears a bit, today's editorial on Routine has a broken discussion link. The editorial is all about the changes people are having to make because of recent world events. ...
March 23, 2020 at 2:29 pm
Since the code came out all on one line, please consider resubmitted where the code looks more normal. 😉
March 23, 2020 at 2:16 pm
It's a little spooky that about half the people that have answered so far have gotten this one wrong. Not because it's partitioning but because people won't take the time...
March 23, 2020 at 2:12 pm
Viewing 15 posts - 7,471 through 7,485 (of 59,072 total)