Viewing 15 posts - 751 through 765 (of 1,988 total)
Just rebuild all the indexes in the database. If you don't care about down time you can just do a ALTER INDEX ALL on every table in the DB.
April 4, 2018 at 11:26 am
Really whichever one works and whichever one makes more sense for the specific problem you're trying to solve and the tools that are available. In some cases loading all the...
April 4, 2018 at 8:26 am
April 4, 2018 at 8:17 am
Why? Sometimes we either want to authenticate without being tied to our AD login, for example this is particularly useful when trying to test out permissions. In some cases we...
March 30, 2018 at 8:22 am
March 29, 2018 at 12:39 pm
If you know ID is a sequential int that should be pretty straight forward.
SELECT MAX(ID), EMAIL, MAX(LAST_UPDATED_DT) FROM wherever GROUP BY EMAIL
March 29, 2018 at 10:10 am
March 28, 2018 at 3:23 pm
That seems like extreme over regulation, why shouldn't the answer to that request have to be anything more than "The same information you gave us" That might not apply to...
March 28, 2018 at 9:18 am
How big are the databases?
March 27, 2018 at 9:59 am
Just because there's an identity column in the database doesn't mean they have to use it in their data model. If they want to use an external system to keep...
March 27, 2018 at 8:37 am
I found even better solution...?
TRY_CONVERT returns 0 from some of the decimals with comma...
March 27, 2018 at 8:07 am
Have you tried it on any distros other than redhat? Or is that all that's supported?
March 26, 2018 at 12:09 pm
Viewing 15 posts - 751 through 765 (of 1,988 total)