Aug
8
awarded  Supporter
Aug
8
accepted Is TEXT to VARCHAR(MAX) an implicit conversion?
Aug
8
revised Is TEXT to VARCHAR(MAX) an implicit conversion?
added 1 character in body
Aug
8
asked Is TEXT to VARCHAR(MAX) an implicit conversion?
Jun
24
accepted Omiting schema names to manage access to SQL Server databases more flexibly
Jun
24
comment Omiting schema names to manage access to SQL Server databases more flexibly
@MaxVernon - I read the post. It does clearly explain how SQL Server works. My opinion is still that hardcoding a schema name into source makes the code less flexible. Without a schema name, the application can run without any changes by the DBA setting the default schema for the execution user. And, it is one less thing where error can be introduced.
Jun
24
comment Omiting schema names to manage access to SQL Server databases more flexibly
@ScottHodgin - Yes, I read that before posting. And I agree, that in a poorly managed environment, multiple schemas can cause problems, But, specifying them puts more limits on how a DBA can manage the database. It removes the option of changing the account default schema and requires the use of views. Are there other mechanisms to manage this?
Jun
24
comment Omiting schema names to manage access to SQL Server databases more flexibly
@JohnEisbrener - I am open to reasons to use schema names. If the DBA can always replace tables with views resolving to other schemas, then why have applications specify dbo.TABLE rather than just TABLE. If the dba creates a view, TABLE would resolve to dbo.TABLE which is a view to mrpv3.TABLE. What is the value of having source code specify dbo.?
Jun
24
asked Omiting schema names to manage access to SQL Server databases more flexibly
Jun
24
awarded  Scholar
Jun
24
accepted ANSI SQL for links
Jun
24
accepted How to address ORA-03113?
2016
Dec
29
awarded  Editor
Sep
30
comment How to address ORA-03113?
The error occurs without any query activity. It does not appear that we have any SERVER=POOLED entries in our tnsnames.ora. Is there a query that would tell if there is an inactivity timeout?
Sep
30
asked How to address ORA-03113?
Sep
30
awarded  Autobiographer
Sep
30
awarded  Student
2014
Sep
23
asked ANSI SQL for links