SQL
Articles on SQL, SQL Server, etc..
How to find out if a record exists in a table efficiently using the IF EXISTS keyword, and 2) How to test and optimize two queries to see which is faster using SQL Server Management Studio. Includes screenshots
The T-SQL aggregate functions (COUNT, SUM, AVG, MIN, and MAX) can all be used with the DISTINCT keyword to calculate them on distinct columns only.
This article describes how to cache your SqlParameters. Using the SqlParameterCache allows you to increase efficiency of calling stored procedures and even on executing regular SQL queries!
How to search if a trigger contains certain text in SQL Server 2005:
SELECT OBJECT_NAME(id)
FROM syscomments
WHERE [text] LIKE '%your_search_here%' AND OBJECTPROPERTY(id, 'IsTrigger') = 1
GROUP BY OBJECT_NAME(id)
When designing a database, and creating the tables and schema, we have to choose carefully what we want our primary key to be. There are many different aspects to this. This article discusses the benefits of using a GUID over an Integer primary key.
7 tips on how to create maintainable database queries. Create a data object, avoid stored procedures, build with stringbuilder, keep it together, code SQL over C#, use a SqlParameter Array, and Trust your judgement!
A power tip on increasing your query execution speed is to prefix your table and stored procedure names with dbo. By prefixing with dbo, Our database makes one less call. Normally, when you do not use the dbo keyword, on a query such as Select * from Users where UserID = @UserID, it will first check the user's schema to see if that table exists for them.