July 22, 2010 at 10:21 pm
please provide design and structure of the table.
Malleswarareddy
I.T.Analyst
MCITP(70-451)
July 22, 2010 at 10:58 pm
Another homework question and you are too lazy to read Books On Line .... or even use Google .... or?
July 23, 2010 at 4:48 am
Take a look at a function called sp_help. I think that might move you in the direction you wish to go.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 23, 2010 at 7:35 am
malleswarareddy_m (7/22/2010)
please provide design and structure of the table.
Do you want any fries with that order? 😀
What do you have so far?
_____________________________________
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 23, 2010 at 7:57 am
malleswarareddy_m (7/22/2010)
please provide design and structure of the table.
What table?
May I suggest you hit google and search for a good primer on Normalisation?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply