Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options questions only user 1342

Best practices are generally and informally recognized as the methods and processes that have been shown over time to be superior to those achieved by other means.

7
votes
3answers
Our IT shop is first starting to build a group of DBA's. All of us (myself included) have come over from the application development/architecture world, so the DBA world is still fairly new to us. Al …
asked Mar 2 '12 by Chris Aldrich
6
votes
2answers
I believe I understand the reasons behind fenced and unfenced stored procedures. Fenced run "outside" of the database (in our case DB2) so as to prevent possible corruption of the database engine sho …
asked May 23 '12 by Chris Aldrich
4
votes
2answers
This question originates more from an "enterprise architecture" point of view. (Reason being, our company is just starting to get into data management, and actually having DBA's -- I know, horrific th …
asked Mar 29 '11 by Chris Aldrich
0
votes
1answer
I have a question that has been bugging me, but I just don't know how to validate it. We run DB2 LUW on AIX in our shop. Our AIX is currently at 7.1. Our DB2 is at 9.7 FP 4 for most installations and …
asked Nov 6 '14 by Chris Aldrich
1
vote
2answers
Our environment is currently DB2 9.7 Fix Pack 4 on AIX. I am in the processing of designing and coding some SQL PL stored procedures responsible for archiving data into an archive schema and then pur …
asked Jul 30 '14 by Chris Aldrich
0
votes
1answer
Based on a previous question I have asked, I am attempting to work on a solution as recommended by mustaccio's answer, whereby I have another ID to create my DDL objects. I have been trying to follow …
asked Sep 17 '13 by Chris Aldrich
4
votes
1answer
We are just starting to get into business intelligence at our company. We have some architects who are designing our data warehouse and also our data marts. They are using star schema for both designs …
asked Jun 27 '12 by Chris Aldrich
2
votes
1answer
Ok, I originally started a question a ways back called "What are the best practices for ETL of data from one OLTP system to another?". And as you can probably tell from most of my questions so far, th …
asked May 9 '11 by Chris Aldrich
2
votes
1answer
First off, I want to post that I am a developer and not a DBA, so I am trying to approach this from the standpoint of what is the best thing to do, rather than just assuming I can do everything effici …
asked Apr 6 '11 by Chris Aldrich
15
votes
3answers
We happen to be using SQL Server 2012 Standard Edition. I also happen to use Ola Hallengren's scripts to provide an easy, more flexible framework for doing backups and maintenance. This question isn' …
asked Feb 5 '16 by Chris Aldrich
0
votes
1answer
This question has started because of us taking copies of production backups and restoring them into lower environments (with scrambled data of course) for developers to practice and/or debug against. …
asked Jul 25 '13 by Chris Aldrich
1
vote
1answer
We are in the process of tuning a massive application our company has just written. Part of that tuning includes tuning the databases. We run DB2 LUW on AIX. Specifically we are at 9.7 Fix Pack 4 (alt …
asked Jul 9 '13 by Chris Aldrich
1
vote
1answer
We work with DB2 LUW (specifically we are currently on 9.7 FP4) running on AIX. Per best practices from IBM, they recommend that when you build a table, you place the data, the indexes, and LOBs/LONG …
asked Jul 13 '12 by Chris Aldrich