Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Performance Tuning a Database
Tuning the database depends on many factors and can differ based on the database engine being used however one important point remains the same, the design, if a database is badly designed then you may as well forget about optimisation and tuning. Check out WWW.SQL-Server-Performance.com Matt- mbryant
- Post #2
- Forum: -General database discussion
-
Stored procedure
To do this you will need to build the SQL statement into a variable then execute that variable for it to work declare @SQLStatement varchar(1000) set @SQLStatement = " SELECT TOP "+@NumberRecs+" contributor,hits FROM #UserList WHERE contributor != 5 Order by hits DESC"...- mbryant
- Post #3
- Forum: Microsoft SQL Server: Programming
