<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2008
»
SQL Server Newbies
»
New DBA job, done some digging on Database...
15 posts, Page 2 of 2
««
1
2
New DBA job, done some digging on Database and have some concerns!
Rate Topic
Display Mode
Topic Options
Author
Message
bugg
bugg
Posted Tuesday, November 20, 2012 11:45 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Thursday, May 23, 2013 8:43 AM
Points: 123,
Visits: 402
Awesome responses guys thank you so much, this site rocks :)
I've been flat out doing queries and other schema changes and haven't had a chance to run dbcc checkdb yet
Will try later in week for sure and keep you posted.
Many thanks
B
Post #1387086
stephen.sarre
stephen.sarre
Posted Wednesday, November 21, 2012 3:50 AM
SSC Rookie
Group: General Forum Members
Last Login: Friday, April 26, 2013 7:39 AM
Points: 46,
Visits: 137
Hi
Before any fixes that you think are "essential", make sure your manager agrees the priorities, in particular new work vs schema fixes, backups, reindexing or DBCCs etc
Only do essential fixes initially - if the system has been working for a few years then it can probably work for a few more weeks (even without PKs)!
If you make changes, and something breaks, then some users might think you don't know what you are doing. You also might get blamed for (schema) problems that come to light subsequently.
Before you get into making schema and other changes (but I see that you have already started), make sure you have a way of tracking the changes, eg use some sort of schema source control system.
Hope that helps
Steve
Post #1387333
Jeff Moden
Jeff Moden
Posted Wednesday, November 21, 2012 7:07 AM
SSC-Dedicated
Group: General Forum Members
Last Login: Yesterday @ 7:36 PM
Points: 32,931,
Visits: 26,820
stephen.sarre (11/21/2012)
Hi
Before any fixes that you think are "essential", make sure your manager agrees the priorities, in particular new work vs schema fixes, backups, reindexing or DBCCs etc
Only do essential fixes initially - if the system has been working for a few years then it can probably work for a few more weeks (even without PKs)!
If you make changes, and something breaks, then some users might think you don't know what you are doing. You also might get blamed for (schema) problems that come to light subsequently.
Before you get into making schema and other changes (but I see that you have already started), make sure you have a way of tracking the changes, eg use some sort of schema source control system.
Hope that helps
Steve
I strongly agree with what Steve wrote above. If you operate alone and without a net, you will die when you fall because you will fall even if you're a great DBA that never makes mistrakes.
--Jeff Moden
"
RBAR
is pronounced "ree-bar" and is a "Modenism" for "
R
ow-
B
y-
A
gonizing-
R
ow".
First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #1387414
seatedElephant
seatedElephant
Posted Thursday, November 22, 2012 7:19 AM
Valued Member
Group: General Forum Members
Last Login: 2 days ago @ 8:13 AM
Points: 56,
Visits: 178
Hi Bugg,
Lot's of great advice from the peeps that know on here. I'd just reinforce the importance of getting a disaster recovery plan in place and making sure all databases and log files are being backed up successfully and in the manner/mode you require for the organizations needs. It's a definite skin saver
Good luck,
Dave.
Post #1387886
Stuart Davies
Stuart Davies
Posted Friday, November 23, 2012 4:16 AM
SSCrazy
Group: General Forum Members
Last Login: 2 days ago @ 1:41 AM
Points: 2,477,
Visits: 2,140
And if anyone questions why you are being pedantic about backups / corrupt databases etc - get them to read
this
- you might want to have a look as well.
This story changed the view of a couple of people I work with.
-------------------------------
Posting Data Etiquette - Jeff Moden
Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
Post #1388112
« Prev Topic
|
Next Topic »
15 posts, Page 2 of 2
««
1
2
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
