Are Cursors in SQL Server Evil? Part One: How to Declare Cursors in Transact-SQL

Henry K., from Learning Tree’s class Developing High Performance SQL Server Databases, writes “My sysadmin said that cursors are evil, and I should never use them in my stored procedures. Is this true?” Henry: Cursors are just another tool in the T-SQL toolbox, and like any tool they can be used properly or used poorly. […]
Read More ›

How to Use CROSS APPLY with Derived Tables in Transact SQL Queries

Armelle G, a student in Learning Tree’s SQL Server Transact-SQL Programming course asks “Is CROSS APPLY only used with T-SQL Functions?” Great question Armelle! Many SQL Server folks would answer “yes” but the fact is that CROSS APPLY can also be used with subqueries. CROSS APPLY allows you to create the equivalent of correlated derived tables in […]
Read More ›

Is MONEY Bad? How to Use the MONEY Datatype in SQL Server

Jamal K, from Developing High-Performance SQL Server® Databases inquires… “A colleague at work said the MONEY datatype in SQL Server is bad and shouldn’t be used. Are there good reasons behind this or is it just hearsay?” Excellent question, Jamal. Before dealing with the question itself let’s consider some historical background. There’s nothing that can […]
Read More ›

Announcing New IT Training Courses: Make Better Use of Your Company’s Data

Curious about how you can enhance your AngularJS or SQL server skills? Or do you want to learn how to capitalize on data stored in Hadoop? Develop your IT skills and make more informed business decisions with the addition of our three new IT training courses! Our 3-4 day courses are designed to deliver both […]
Read More ›

Amazon Extends Services for Microsoft Technologies

As someone who works primarily with Microsoft technologies I was delighted to see the Amazon announcement yesterday that they are going to offer two additional options for developers. First, Amazon RDS is now going to include SQL Server in addition to MySQL and Oracle databases. SQL Server is available in a variety of versions on […]
Read More ›

Type to search blog.learningtree.com

Do you mean "" ?

Sorry, no results were found for your query.

Please check your spelling and try your search again.