I have a view joining several tables
CREATE VIEW dbo.VView
Select a, b,c, d
JOIN table2 p ON pp.a = p.a AND pp.b= p.b
I am researching on the possibility of creating and using a configuration file to be used to set up global variables setting up environmental...
I am working on performance issues of an bussiness application on the DB performance issues. Some of the pages gets about 30seconds to be...
When I went through a SP I found this part;
IF NOT EXISTS...
Can anyone tell methe use of N in this following querry??
SELECT * FROM dbo.sysindexes WHERE id = OBJECT_ID(N'[dbo].[App]') AND name =...
It is my understanding that SQL server does automatic query oprimizing periodially by analysing the usage of indexes.
my questing is if i have...
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...
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.