Viewing 15 posts - 1,321 through 1,335 (of 2,008 total)
They may not remember and that is why it should be declared as NOT NULL.
November 24, 2011 at 6:00 am
Few thoughts:
•These are Audit Columns. Business & Business Logic should worry less on them. If you don’t want them to appear in data model (Logical) just hide them.
•The second approach...
November 24, 2011 at 12:10 am
PaulB-TheOneAndOnly (11/23/2011)
Dev (11/23/2011)
Export utility
STATISTICS
Default: ESTIMATE
Specifies the type of database optimizer statistics to generate when the exported data is imported. Options are ESTIMATE, COMPUTE,...
November 23, 2011 at 11:32 pm
Note: Not relevant to SQL Server.
Export utility
STATISTICS
Default: ESTIMATE
Specifies the type of database optimizer statistics to generate when the exported data is imported. Options are ESTIMATE, COMPUTE, and NONE. See the...
November 23, 2011 at 10:24 am
FYI... I started my DB career with Oracle, currently working on SQL Server. I always try to match up the concepts in two DBs & it creates lot-of-confusion.
I found...
November 23, 2011 at 9:33 am
GilaMonster (11/23/2011)
Dev (11/23/2011)
This cat is not lazy (curious though) but has limited tools in hand.
You don't have a single SQL instance anywhere at hand and you don't have...
November 23, 2011 at 9:04 am
For starters why in the world would a RDBMS development team exclude on purpose performance statistics during backup? Just to add overhead during backup then add overhead during restore/recovery...
November 23, 2011 at 8:59 am
Gianluca Sartori (11/23/2011)
Dev (11/23/2011)
Roy Ernest (11/23/2011)
As far as I know when a Back up is done, it preserves the Stats as well.
Can you please lead me to...
November 23, 2011 at 8:01 am
Gianluca Sartori (11/23/2011)
Roy Ernest (11/23/2011)
As far as I know when a Back up is done, it preserves the Stats as well.
I would be very surprised of the contrary.
@dev:...
November 23, 2011 at 7:59 am
Roy Ernest (11/23/2011)
As far as I know when a Back up is done, it preserves the Stats as well.
Can you please lead me to some evidence? (Curiosity kills the...
November 23, 2011 at 7:51 am
No need to create duplicate threads.
http://www.sqlservercentral.com/Forums/Topic1211025-1550-1.aspx
November 23, 2011 at 7:47 am
Mojo Jojo
p.s. somebody please tell me when it will be over 😉 what are the rules?
November 23, 2011 at 7:38 am
I am trying hard to find one article which says "SQL Server backup preserves stats as well". There is no switch in backup command for stats (if I would like...
November 23, 2011 at 7:36 am
PaulB-TheOneAndOnly (11/23/2011)
Dev (11/23/2011)
What you can do using the proper DBMS_ Oracle package is to take a Performance Statistics "backup" and "restore" it as it pleases you but this...
November 23, 2011 at 7:29 am
What you can do using the proper DBMS_ Oracle package is to take a Performance Statistics "backup" and "restore" it as it pleases you but this is NOT a database...
November 23, 2011 at 7:12 am
Viewing 15 posts - 1,321 through 1,335 (of 2,008 total)