Search SSWUG.ORG:

Latest Video Programs

SSWUGtv: What do you lose out on if you don\'t negotiate your salary offer? Laura Rose has the answers.

SSWUGtv: What do you lose out on if you don\'t negotiate your salary offer? Laura Rose has the answers.

SSWUGtv: Today, Steve discusses Cross Versioned Systems.   SSWUGtv: Here are some good tips on how to protect your systems from internal issues.   SSWUGtv: Laura explains how to network after moving to a new city  
 

From the Editor's Desk...

User Defined Table Type  -  Are you taking advantage of the SQL Server User Defined Table Type? Come check it out along with some temp table techniques.

Sequences  -  I was very excited when SQL Server added Sequences to the available tools. They can really simplify many different kinds of operations. Today I share how they can be useful when implementing a type/subtype schema.

Filtered Indexes  -  Did you know you can create an index with a Where clause? When you do the only rows in your index are those meeting your where clause criteria. Check it out.

Materialized Views  -  You can improve the performance of your view by Materializing it (creating an index on your view). Do you think this is a good idea?

Non-materialized Data Sources  -  Do you know what a Materialized data source is? Then what is a non-materialized data source? How does it differ in performance and behavior? Check out today's editorial for some answers.

Query Plan Evaluation  -  Evaluating a Query Plan is a very helpful skill for working with slow performing queries. It's not terribly hard, so even an SQL NewB can benefit quickly. The more you understand about how SQL Server works the more a query plan will assist you in making your queries run faster.

Hinky Pinky  -  Today I just want to get you thinking. While it may not make you write better code, it will keep you busy if you give it a try.

Other Parallel Tools  -  Today Damian writes in with a number of different techniques to take advantage of parallel capabilities.

How is OData Doing?  -  OData came on the scene not too long ago. What a great idea. Is it catching on? Will adoption continue to grow?




Community Content - News, Articles, How-To Information and More from Around the World