January 3, 2008 at 1:02 pm
..
Thanks,
Chinna
Its the Journey which gives you Happiness not the Destination-- Dan Millman
January 3, 2008 at 1:10 pm
Could you be a bit more specific please?
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
January 3, 2008 at 1:14 pm
i have been asked in an interview ...like is there any tool by which u could know where exactly the problem instead of running trace n jus looking over execution plan ..he asked whether is there any othe tool which makes u know that here is the problem in the sp....
Thanks,
Chinna
Its the Journey which gives you Happiness not the Destination-- Dan Millman
January 3, 2008 at 1:39 pm
Not that I've ever heard of. That's why skilled DBAs/sql developers are still needed.
What kind of problems? Logic? Exceptions? Performance? Invalid data?
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
January 3, 2008 at 1:53 pm
in case of coding of the stored proc....
Thanks,
Chinna
Its the Journey which gives you Happiness not the Destination-- Dan Millman
January 3, 2008 at 8:35 pm
The question is not well defined.
If there is a syntax error, we can run check syntax.
If there is a logical error, we can run stored procedure debugger.
If there is a performance issue, we can run the profiler or other tool.
If, ...
January 3, 2008 at 11:02 pm
If there's a syntax roblem, the parser will pick it up. Other than that, you have to debug the code. Just like for C#, VB, Java and all the other programming languages.
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 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply