Hi this is the SP **************************************************** CREATE PROCEDURE [dbo].aa_sp_IQPA_Read @Zcode char(5), @EDate...
I have a view joining several tables e.g. CREATE VIEW dbo.VView as Select a, b,c, d FROMTable1 pp JOIN table2 p ON pp.a = p.a AND pp.b= p.b JOIN...
Satya, I have to give you a huge "thank you" it's a great site you told me about. so THANKS!!!!
Thanks Satya! for your information.
Hi, I am researching on the possibility of creating and using a configuration file to be used to set up global variables setting up environmental...
Hi, I am working on performance issues of an bussiness application on the DB performance issues. Some of the pages gets about 30seconds to be...
Hi, When I went through a SP I found this part; ================================================================================ IF NOT EXISTS...
Thanks Dinakar
Hi , Can anyone tell methe use of N in this following querry?? SELECT * FROM dbo.sysindexes WHERE id = OBJECT_ID(N'[dbo].[App]') AND name =...
Hi, It is my understanding that SQL server does automatic query oprimizing periodially by analysing the usage of indexes. my questing is if i have...
Hi, Thanks all for your responses. It helpeda lot.
Hi, Thanks a lot Dilli for your reply. The SP looks something like this. ================================================= BEGIN SET NOCOUNT ON SET...
Hi all, I know how to get the Query execution plan in graphical form in the SQL server. But it's really useless as I do not know how to interpret it...
Hi, I have a question on giving noloc hint in select statements. I am to enhance the performance of some SPs. I notice that all the SPs start with...
Separate names with a comma.
