Viewing 15 posts - 1,111 through 1,125 (of 3,060 total)
Oliiii (4/18/2011)
You'll need an index on it since none of your current index fits (the second is filtered).
Agreed. Please check execution plan, most likely you will see a full...
_____________________________________
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.April 18, 2011 at 4:15 pm
aGuareschi (4/18/2011)
select * from vipt_tab_003where pt03_annomese = 201001
and pt03_r_abi = 'XXXXX'
and pt03_num_eff = '569845456165748'
What's the cardinality of this query? how many rows is it supposed to return?
_____________________________________
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.April 18, 2011 at 8:01 am
satish.saidapur (4/16/2011)
Some one asked me Sql Database Artistructure, could you please help me for how to explain & what are the things i explain?
Is it "artistructure" or perhaps "architecture"?
Assuming the...
_____________________________________
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.April 16, 2011 at 12:47 pm
round() and cast() are different functions - check BOL.
_____________________________________
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.April 14, 2011 at 5:27 am
quillis131 (4/6/2011)
Table1 (column ADDEDDATE) is in the form10/1/2005 12:00:00 AM
8/18/2007 12:00:00 AM
What's the datatype of ADDED_DATE column? is it a DATE or a VARCHAR2 column?
If ADDED_DATE is 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.April 10, 2011 at 1:49 pm
Carol Adams (4/5/2011)
The transaction log is growing out of control because of this...
_____________________________________
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.April 5, 2011 at 11:02 am
Filter out unwanted days of the week on WHERE clause.
Use GROUP BY to group by Class, Day-of-the-week.
_____________________________________
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.April 3, 2011 at 3:58 pm
Mazenx (3/19/2011)
_____________________________________
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.March 20, 2011 at 8:44 am
$QLdb@ (3/18/2011)
what should be my steps to make it in normalized form
database consist of 244 tables and 1...
_____________________________________
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.March 20, 2011 at 8:41 am
nagireddy0024 (3/19/2011)
plz any one rply correct answer.
Okay, here I go: "correct answer" 🙂
_____________________________________
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.March 20, 2011 at 8:32 am
DZN (3/14/2011)
so how to implement ? What's the solution ?
Make master your current database.
_____________________________________
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.March 14, 2011 at 2:20 pm
mymail.default (3/14/2011)
I did, and that's why I put the statistics for IO from the exec plans.
Same execution plan against same tables in same database can't show such a different I/O...
_____________________________________
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.March 14, 2011 at 12:46 pm
mymail.default (3/14/2011)
The interesting thing is:...
_____________________________________
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.March 14, 2011 at 11:59 am
DZN (3/14/2011)
I'm trying to read a folder located on another server.
1. I have created a credential (Identity is <domainname>\<username>
2. I have created a proxy (Operating System cmdExec) associated with the...
_____________________________________
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.March 14, 2011 at 9:51 am
THE-FHA (3/14/2011)
_____________________________________
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.March 14, 2011 at 8:31 am
Viewing 15 posts - 1,111 through 1,125 (of 3,060 total)