Viewing 15 posts - 2,191 through 2,205 (of 3,060 total)
Check if you have an unique index on empid column...
if yes then build your PK on it.
if no then check for and fix empid duplicates then build your PK on...
_____________________________________
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.February 16, 2010 at 5:26 am
What's your background?
Do you have any foundation in relational theory? No? ==> check C. J. Date
If you have a rdbms background check BOL, it installs alongside SQL Server.
_____________________________________
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.February 16, 2010 at 5:06 am
Nice Marmot (2/8/2010)
Oracle RAC (Real Application Clusters) corresponds to SQL Server Clustering
This is incorrect. As far as I know there is nothing in the SQL Server side providing Oracle RAC...
_____________________________________
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.February 10, 2010 at 12:16 pm
Not sure why you don't want to use Access as front-end when you keep saying you like it 🙂
If you are concerned about security you can always handle security...
_____________________________________
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.February 10, 2010 at 12:08 pm
sgambale (1/25/2010)
Has anyone implemented his script or something similar in a production SQL Server?
Yes. Logon trigger is the way to go.
_____________________________________
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.February 1, 2010 at 3:03 pm
Either your resume poorly reflects your working experience or your working experience is closer to a Sysadmin than a DBA. Based on the resume I would say you might...
_____________________________________
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.January 31, 2010 at 8:42 am
wow wow WOW! :w00t: No need to declare Jihad on me... we both read from the same book! remember? :laugh:
hey ... you missed an opportunity to...
_____________________________________
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.January 22, 2010 at 8:04 pm
gary-951320 (1/22/2010)
By catalogue do you mean working with the rdbms metadata or do you mean simply adding another table to the database
The idea is to build your own "catalog", in...
_____________________________________
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.January 22, 2010 at 7:50 pm
David Portas (1/22/2010)...you can always create a truly normalized design without them.
Yes! I'm agreement... but the truth is you can do with or without them :Whistling:
I know there 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.January 22, 2010 at 3:48 pm
Peter Priebusch (1/22/2010)
Wow, perfect.Many thanks.
"I love it when a plan comes togheter" 😎
_____________________________________
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.January 22, 2010 at 7:13 am
Roy Ernest (1/22/2010)
Great catch...
Glad to help 🙂
_____________________________________
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.January 22, 2010 at 7:03 am
Roy Ernest (1/22/2010)
delete from table1where email not in (Select email from table2)
This will delete all records that does not have any corresponding email address in the second table.
:w00t: nahhhh! it's...
_____________________________________
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.January 22, 2010 at 6:49 am
Check this pseudo-code...
delete table1
where table1.email in (select email from table2 where table2.email = table1.email)
go
_____________________________________
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.January 22, 2010 at 6:45 am
mhilligas (1/22/2010)
What do you think?
I think you may be developing a resistance to read documentation 😀
Check if MSDTC is running on your SQL Server host; also check if your...
_____________________________________
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.January 22, 2010 at 6:39 am
again? how many times are you planning to post the same question in different sections?
You have to use BEGIN DISTRIBUTED TRANSACTION - check BOL for details.
_____________________________________
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.January 22, 2010 at 6:30 am
Viewing 15 posts - 2,191 through 2,205 (of 3,060 total)