Pulse » Recent Items from 10/22/2010
Welcome!
Pulse has a simple goal: to give you a quick view of what's happening in the SQL Server community.
-
Browse
Finding interesting content on Pulse is easy – you can drill down to a specific time period (by clicking on the bars of the chart), toggle different types of content on and off, and sort the results by popularity or recency.
-
Vote
Discovered an informative blog post or a hilarious tweet? Tell the rest of the community about it by voting it up or down. Behind the scenes, our popularity algorithm will make sure it rises to the top of the list.
-
Comment
When a simple up-or-down vote isn't enough, voice your opinions in a comment. Or check out what others are saying about something you posted or tweeted.
October
-
NULL ISSUE in a SUBQUERY
I had an interesting training session with one of the customers dealing with Nulls in queries. Below is the demo of the issue when NULLS are involved. create tables CREATE TABLE [Cust]( [custid] [int] IDENTITY(1,1) NOT NULL, [companyname] [nvarchar](40) NOT NULL, CONSTRAINT [PK_Customers] PRIMARY KEY CLUSTERED ( [custid ...
-
NULL ISSUE in a SUBQUERY
I had an interesting training session with one of the customers dealing with Nulls in queries. Below is the demo of the issue when NULLS are involved. create tables CREATE TABLE [Cust]( [custid] [int] IDENTITY(1,1) NOT NULL, [companyname] [nvarchar](40) NOT NULL, CONSTRAINT [PK_Customers] PRIMARY KEY CLUSTERED ( [custid ...
-
Return of Index Analysis Part 4
Let’s Anaylze An Index! We’ve got through the first three parts of this continued series on the Index Analysis query last week. The previous posts in this complete series are: Analyze Your Indexes Part 1 – Combine existing index statistics and missing indexes into a single output Analyze Your ...
Pulse is a section of SQLServerPedia that gives you a quick view of what's happening in the SQL Server community.