Here is a list of common wait types and techniques that every DBA (or wannabe DBA) should know. While there are many more wait types than listed here, understanding these will give you a leg up when ...

Since SQL Server 7, stored procedures and user-defined functions (UDFs) aren't precompiled or stored in an intermediate parsed-tree format prior to use, as in earlier versions.

You can use VB.NET or C# to write procedural code and create user-defined types and aggregates in SQL Server.

You can use VB.NET or C# to write procedural code and create user-defined types and aggregates in SQL Server.

You can use VB.NET or C# to write procedural code and create user-defined types and aggregates in SQL Server.

You can use VB.NET or C# to write procedural code and create user-defined types and aggregates in SQL Server.