Viewing 15 posts - 6,151 through 6,165 (of 39,754 total)
Good developers make mistakes on simple things. This is one of those areas that we should have a system handle itself because the permutations of regional differences is crazy.
October 25, 2017 at 1:32 pm
Execution plans the same? Row counts in dbs that same? I'd make sure this is the case first.
October 25, 2017 at 12:46 pm
I assume you mean that creating the logins with a new password isn't OK?
First, that's horrible security. If you can't change a password, you are asking to be...
October 25, 2017 at 12:45 pm
I believe UCP is being abandoned as essentially no one used it. I think you will need SSMS 16.x or earlier, which should still be on your machine. Might keep...
October 25, 2017 at 12:19 pm
We are looking at updating the PoSh Stairway for this reason. PoSh has changed a lot. Likely we'll go with WS2008+ and W8+ as the PoSh installation.
October 25, 2017 at 12:17 pm
October 25, 2017 at 12:14 pm
Your requirements are very ambiguous.
"a value from a column for a date and another value from another column for another date"
This is vague and a reason why...
October 25, 2017 at 12:12 pm
October 25, 2017 at 11:10 am
October 24, 2017 at 4:54 pm
Apparently I can't count.
It's certainly the year of 1 step forward, 1 back for me. I guess I'll finish around 7-6
October 24, 2017 at 10:27 am
I wonder if this will grow. Like most of you, I think this is limited to a few narrow niche areas, but I also could see this as more than...
October 24, 2017 at 8:08 am
Also, thanks for the update. Hope it keeps working for you.
October 24, 2017 at 7:59 am
That's interesting. I guess if you're a user in the db context and set single user with rollback, the other users are disconnected and then you have the only connection....
October 24, 2017 at 7:59 am
FORMAT() is slower than CAST/CONVERT, but has some advantages in handling different regions and more flexibility. I like it, but I'd use it judiciously.
October 24, 2017 at 7:49 am
Viewing 15 posts - 6,151 through 6,165 (of 39,754 total)