|
This is the talk given by Pat Wright about TemDB performance. We discussed some of the common issues of Tempdb and what you can do to improve the performance of tempdb. We will also talked about disk performance...
Date Added: 08-10-2010
|
File Size: 3.7MB
Downloads: 26
Comments: 0
|
|
The TRY...CATCH statement in Transact-SQL allows you to detect and handle error conditions gracefully within your database applications. This statement is the cornerstone of SQL Server error handling and...
Date Added: 07-18-2010
|
File Size: 129.5kB
Downloads: 29
Comments: 0
|
|
Date Added: 05-11-2010
|
File Size: 2.4kB
Downloads: 61
Comments: 0
|
|
These are the slides for the Presentation. I will also post the TSQL.
Date Added: 05-11-2010
|
File Size: 387.4kB
Downloads: 49
Comments: 0
|
|
The presentation focused on CRL (Common Languag Runtime) . This is a technology for hosting Microsoft .NET engine within SQL Server. Included in the zip file are the examples that were presented at the...
Date Added: 04-16-2010
|
File Size: 824.8kB
Downloads: 50
Comments: 0
|
|
This presentation was given by Pat Wright at the February 2010 SQL Server User Group.
Date Added: 02-08-2010
|
File Size: 1.2MB
Downloads: 99
Comments: 0
|
|
Because sometimes we do not have the luxury of SSIS and we have to work with what we have. The presentation show how the principles that govern the ETL process can work with the tools that you are given...
Date Added: 01-11-2010
|
File Size: 191kB
Downloads: 120
Comments: 0
|
|
Presentation by Peter Myer's of SolidQ Analysis Service’s OLAP component allows organizations to implement a Unified Dimensional Model (UDM) that is designed for rapid ad hoc information retrieval...
Date Added: 09-15-2009
|
File Size: 1.1MB
Downloads: 214
Comments: 0
|
|
Date Added: 08-10-2009
|
File Size: 966.2kB
Downloads: 200
Comments: 0
|
|
Presented by Scott Heffron Common table expressions (CTEs), a powerful and slick new feature in SQL Server 2005, make your SQL more readable and easier to maintain. They are similar to aliases (as in SELECT...
Date Added: 05-11-2009
|
File Size: 0 B
Downloads: 329
Comments: 0
|