I am checking for win integrated login as follows: IF connection_property('AuthType') = 'Integrated' .... but that always returns 'Standard'. When I set the login mode as follows... SET OPTION PUBLIC.login_mode = 'Standard,Integrated'; it a...

Does anyone know about a function, procedure or other working SQL code snippet which would return the amount of free disk space available on the current drive? (I do not care about the DB or Log sizes, I need to know how much space is left of the hos...

I am trying to optimize performance and while I cannot adjust some expensive queries at this time I can fine-tune the SQLA16 Server configuration (64-bit). I have a lot of RAM available and it could help to cache some of the larger views & tables. I ...

I am using PD 16.6.0.0.(4971). When I create a function with parameters and set default values for these "IN" parameters, for some reason the function is generated without those defaults. Also, I’ve noticed that the PDM I imported from an earlier ...