Viewing 15 posts - 1 through 15 (of 3,060 total)
Ville-Pekka Vahteala (1/16/2014)
We are having performance problems on our server. We have found out that execution plans (attached) are very different when query is executed from SSMS and Oracle.
Does anyone...
_____________________________________
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 20, 2014 at 12:15 pm
silentbeautybalaji (10/7/2013)
can anyone help me for which columns primary columns is need.
My guess is that data modeling for this project is half cooked - at best.
Do you have an E/R...
_____________________________________
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.October 7, 2013 at 2:51 pm
Resender (9/25/2013)OK I can connect/tnsping to the database but not via tnsnames only directly
Many possible reasons for it...
1) Syntax errors on tnsnames file
2) Wrong parameters on tnsnames file
3) Multiple tnsnames...
_____________________________________
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.September 25, 2013 at 12:14 pm
Alvin Ramard (8/8/2013)
If you took 30 minutes to leatn about SQL Server you would know how to answer this yourself.
Don't worry, he knows nothing about Oracle either - thinks "data...
_____________________________________
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 8, 2013 at 3:41 pm
rayan98 (8/6/2013)
SQL Server Microsoft SQL Server 2005 - 9.00.5324.00 (X64)...
_____________________________________
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 6, 2013 at 1:57 pm
mandar.dasgupta (8/3/2013)
I have worked a little more and i showed it to our Accounts Head and he was reasonbly satisfied with it. However i ran into a little bit...
_____________________________________
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 5, 2013 at 6:02 am
sharonsql2013 (8/2/2013)
Any clue how that will work in crystal?
Not the slightest clue. Any Crystal Reports forums around?
_____________________________________
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 2, 2013 at 2:42 pm
peacesells (8/2/2013)
DatetimeValue2=?
I need to find out DatetimeValue2 from a source table in remote server using these values and pull data between DateTimevalue1 and DatetimeValue2.
Dateime2 will be...
_____________________________________
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 2, 2013 at 2:40 pm
sharonsql2013 (8/2/2013)
I am creating a join with some tables and I have been asked table A to be starting point...
_____________________________________
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 2, 2013 at 2:34 pm
Shaun2012 (8/2/2013)
I need to move oracle 10g and 11g data into sql 2008 using SSIS 208 and we have BIDS 2008 R2. Anyone have any suggestions how to do it.
Actually,...
_____________________________________
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 2, 2013 at 12:32 pm
Duplicate post... http://www.sqlservercentral.com/Forums/Post.aspx?SessionID=0uno1255iba2s42bjtdqatry
_____________________________________
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 2, 2013 at 9:35 am
Saravanan PM (8/2/2013)
We are getting Timeout problem while exporting Dynamic SSRS report (which is having 51columns and 11000 rows ) into excel through .net web application. We are running into...
_____________________________________
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 2, 2013 at 9:34 am
Saravanan PM (8/2/2013)
We are getting timeout error while exporting Dynamic reports (SSRS2008) into excel with 11000 rows and 51 columns.please help
Check this please... http://geekswithblogs.net/ssrs/archive/2009/10/30/steps-to-resolve-ssrs-timeout-issues.aspx
_____________________________________
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 2, 2013 at 9:33 am
cgreathouse (8/2/2013)
_____________________________________
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 2, 2013 at 9:30 am
SSNinja (7/31/2013)
_____________________________________
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.July 31, 2013 at 2:19 pm
Viewing 15 posts - 1 through 15 (of 3,060 total)