| 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 | |
