More Results
-
SQL Server stored procedures vs. CLR stored procedures: Time to migrate?
Should you use SQL Server stored procedures or CLR stored procedures? Expert Serdar Yegulalp helps you decide which is more appropriate for you. Tip | SearchSQLServer.com
-
xVelocity Columnstore Indexes in SQL Server 2012
With the release of SQL Server 2012, Microsoft introduced a new type of nonclustered index called xVelocity columnstore index in the SQL Server database engine. It is based on VertiPaq in-memory data compression technology. The xVelocity... Tip | SearchSQLServer.com
-
Useful SQL Server 2012 features to become familiar with
SQL Server 2012 has plenty of new features for everyone, from developers to administrators. There are several features for high availability and database administration that will improve DBA operations. We're going to look at four of them:... Tip | SearchSQLServer.com
-
Common Language Runtime (CLR)
The Common Language Runtime (CLR) is programming that manages the execution of programs written in any of several supported languages, allowing them to share common object-oriented class es written in any of the languages. Definition | WhatIs
-
CLR aggregates
The CLR aggregate is another new type of .NET database object that was introduced in SQL Server 2005. Learn more in this chapter excerpt. Tutorial | SearchSQLServer.com
-
CLR architecture
The .NET Framework CLR is very tightly integrated with the SQL Server 2005 database engine. In fact, the SQL Server database engine hosts the CLR. This gives SQL Server 2005 several distinct advantages over the .NET... Tutorial | SearchSQLServer.com
-
CLR triggers
In addition to stored procedures and user-defined functions, the new .NET integration capabilities found in SQL Server 2005 also provide the ability to create CLR triggers. Find out how in this chapter excerpt. Tutorial | SearchSQLServer.com
-
Creating CLR database objects
Get an overview of the process to manually create a CLR database object. Then go further and learn how to use the Visual Studio 2005 Professional, Enterprise, and Team System Editions, which all have tools that help create... Tutorial | SearchSQLServer.com
-
Debugging CLR database objects
One significant feature found in the integration of .NET Framework, Visual Studio 2005, and SQL Server 2005 is the ability to debug the CLR database objects that you create. Find out more in this chapter excerpt. Tutorial | SearchSQLServer.com
-
CLR stored procedures
Stored procedures are one of the most common database objects that you'll want to create using one of the managed .NET languages. One of the best uses for CLR stored procedures is to replace existing extended stored procedures. ... Tutorial | SearchSQLServer.com
Search Again: