Viewing 15 posts - 271 through 285 (of 3,060 total)
dj1202 (6/15/2012)
DateID (date)
Quarter
Year
Month
Week
Day
InvoiceNumber
There are duplicate dates in the DateID column, but I would like to assign 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.June 15, 2012 at 2:15 pm
chenthor (6/13/2012)
_____________________________________
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.June 14, 2012 at 5:09 am
Anything but four-part naming query would do it. Four-part naming queries have the tendency of moving the whole target tables over the link then apply filtering on the local host...
_____________________________________
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.June 13, 2012 at 4:15 pm
opc.three (5/19/2012)
_____________________________________
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.May 19, 2012 at 3:29 pm
sandeep4testing (5/19/2012)
any one call help me with fallowing queryHow to find the name of the employee who manages more employees?
Do you realize nobody can write your (home work) query...
_____________________________________
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.May 19, 2012 at 6:57 am
Manny Cruz (5/18/2012)
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.May 18, 2012 at 3:58 pm
You have a good point Howard which means Jeff also has it.
In a real world situation, facing that scenario we could always go back to the function based index Jeff...
_____________________________________
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.May 16, 2012 at 10:45 am
Jeff Moden (5/14/2012)
PaulB-TheOneAndOnly (5/14/2012)
Jeff Moden (5/10/2012)
PaulB-TheOneAndOnly (5/10/2012)
Jeff Moden (5/9/2012)
PaulB-TheOneAndOnly (5/9/2012)
If MSTR_END on WHERE clause is causing the issue replace the condition with:where TO_CHAR(MSTR_END,"DD-MON-YYYY") = ''01-JAN-1700''
IIRC, that'll make for a non-SARGable...
_____________________________________
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.May 16, 2012 at 8:48 am
Jeff Moden (5/10/2012)
PaulB-TheOneAndOnly (5/10/2012)
Jeff Moden (5/9/2012)
PaulB-TheOneAndOnly (5/9/2012)
If MSTR_END on WHERE clause is causing the issue replace the condition with:where TO_CHAR(MSTR_END,"DD-MON-YYYY") = ''01-JAN-1700''
IIRC, that'll make for a non-SARGable search predicate just...
_____________________________________
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.May 14, 2012 at 8:10 am
Denise McMillan (5/9/2012)
_____________________________________
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.May 10, 2012 at 2:37 pm
Denise McMillan (5/10/2012)
I still don't understand why the query works, but not as a view.Any thoughts?
My guess is that the view is forcing a data type conversion that...
_____________________________________
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.May 10, 2012 at 2:35 pm
Jeff Moden (5/9/2012)
PaulB-TheOneAndOnly (5/9/2012)
If MSTR_END on WHERE clause is causing the issue replace the condition with:where TO_CHAR(MSTR_END,"DD-MON-YYYY") = ''01-JAN-1700''
IIRC, that'll make for a non-SARGable search predicate just like in T-SQL....
_____________________________________
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.May 10, 2012 at 2:33 pm
Denise McMillan (5/9/2012)
_____________________________________
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.May 9, 2012 at 2:32 pm
SQL_ME_RICH (5/4/2012)
The other consideration was their desire for speed over the accuracy of the data. Yes - you read that correctly. :crazy:
:w00t: Yes, absolutely crazy. Nothing should...
_____________________________________
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.May 6, 2012 at 7:56 am
Sapen (5/6/2012)
There are 10 of these errors:
The client was unable to reuse a session with SPID, which had been reset for...
_____________________________________
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.May 6, 2012 at 6:42 am
Viewing 15 posts - 271 through 285 (of 3,060 total)