How recompilation does significantly affect on the execution time of SQL query and plummet or degrade the performance?   Read more...

I have a stored procedure I push down to all of my servers that does a custom backup job and I want to make sure all servers have the same stored procedure. Is there some way to check without going to each server and reviewing the stored procedure? Check out this to find out.  Read more...

SQL Server is used to support many applications and one such feature of most applications is the storage of passwords. Sometimes there is a need to reset a password using a temporary password or generate a random password for a new user. In this tip I cover a simple stored procedure to generate random passwords that can be incorporated into your applications.   Read more...

Nothing new for many developers, but I still like the way you can maintain the stack throughout the call chain.   Read more...

The functionality of additional columns / rows in a cross table ("matrix") in Reporting Services is limited to totals / subtotals. By using a stored function a solution is described.  Read more...

An interesting use of T-SQL to run a stored procedure as part of a SELECT statement to get a result set to be used and combined with other tables. From Eli Leiba, learn how you can build a stored procedure into your queries.  Read more...

In this article Brian Davey present a solution for changing the text in multiple stored procedures using T-SQL.  Read more...

Dynamic Management Views and Functions aren't always easy to understand. However, they are the easiest way of finding out which of your stored procedures are using up the most resources. Greg takes the time to explain how and why these DMVs and DMFs get their information. Suddenly, it all gets clearer.  Read more...

How to test and tune a stored procedure?  Read more...

Longtime DBA David Poole brings us an interesting situation in involving setting up a user to allow Excel to query data from SQL Server.  Read more...

Automates the creation of INSERT, UPDATE & DELETE stored procedure of a table  Read more...

How to sign stored procedures with certificates, this is useful if the procedures use dynamic SQL.  Read more...

Pass variables values from Stored Procedures to Trigger  Read more...

Use dynamic PivotTables to identify unused Stored Procedures in a SQL Server 2005/2008 database  Read more...

In this article I will show you how to implement a stack.  In programming, stacks are a great way to...  Read more...

By utilizing service broker, xp_cmdshell and dtexec.exe SSIS packages can be run with a stored procedure.  Read more...

Some useful undocumented extended and stored procedures in SQL Server 2005  Read more...

An interesting use of T-SQL to run a stored procedure as part of a SELECT statement to get a result set to be used and combined with other tables. From Eli Leiba, learn how you can build a stored procedure into your queries.  Read more...

Everybody knows how to call stored procedures from a .NET application. Right? But then, how often do you see stored procedures used to their full advantage in database applications? William Brewer goes through some of the basics, but uses PowerShell as the example .NET application, and avoids all mention of Northwind or AdventureWorks!  Read more...

Tips on parsing and sculpting XML from within a SQL 2005 stored procedure  Read more...