Viewing 15 posts - 2,386 through 2,400 (of 3,060 total)
RBarryYoung (8/24/2009)
molson (8/24/2009)
I think Barry lays out most of what you need:structure and discipline
Structure: Develop a clear,concise, well planned naming convention for your sprocs
Discipline: Stick to it
Heh, agreed Molson....
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.August 25, 2009 at 9:12 am
:w00t: ... attaching resource database?
BOL or Google mssqlsystemresource.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.August 25, 2009 at 8:49 am
is TLOG growing? look for a long standing transaction.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.August 25, 2009 at 7:16 am
mroja_2005 (8/24/2009)
EXEC [ServerName\SQL_01].ADVENTUREWORKS.DBO.TEST_SP
Msg 7411, Level 16, State 1, Line 1
Server 'ServerName\SQL_01' is not...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.August 25, 2009 at 6:21 am
On the other hand, you can narrow the field of suspects by checking which user accounts have such privileges on the affected database.
By the way, if application is using a...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.August 24, 2009 at 7:47 pm
Assuming you have already back up the transaction log file to turn as many active virtual log files inactive - statement is correct.
Just out of curiosity, what's the backup/recovery model...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.August 24, 2009 at 7:20 pm
Ask your contact to compile and run procedure sp_help_revlogin
Details here... http://support.microsoft.com/kb/918992
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.August 24, 2009 at 3:39 pm
Since there is no NUMERIC data type in Oracle - closest one would be NUMBER I think driver was attempting some kind of data conversion from default datatype and failed.
Probably...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.August 24, 2009 at 9:34 am
I think that in the described scenario storedprocs are just the fever... the illness might be...
MaverickMan (8/21/2009)
... get complicated when everyone starts creating innumerable branches.
I would stay with storedprocs...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.August 23, 2009 at 6:04 pm
SK (8/23/2009)
Hopefully it can be built into a newer version, because I would love to use it.
That's a good idea, I would write a nice letter to Attunity - I...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.August 23, 2009 at 5:56 pm
useracc2096 (8/20/2009)
me also use it and its really good enough.......
:w00t: is this plain spam?
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.August 23, 2009 at 5:49 pm
Bruce W Cassidy (8/13/2009)
Oracle uses shared code for the daemons (or Services in Windows parlance), so the overhead for the shared code isn't as big.
Sorry, on this one you are...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.August 14, 2009 at 4:48 pm
Bruce W Cassidy (8/13/2009)
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.August 13, 2009 at 5:02 pm
Do you have a clustered index on offending table?... rebuild it, that forces recreation of PFS page then ghost flag will get set right.
If you do not have a clustered...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.August 13, 2009 at 4:52 pm
The more distributed the I/O, the better - you already know that 😉
In regards to which option is the better that's something only you can tell... check I/O for specific...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.August 13, 2009 at 4:40 pm
Viewing 15 posts - 2,386 through 2,400 (of 3,060 total)