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...

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?

Correctly Configuring Parallelism  -  Today we are reminded that Parallelism is not just a custom software problem, but is often configurable in packaged software too, such as SQL Server. Even then it is important to get your parallelism configured correctly.

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