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...
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...
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 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.
