Pulse » Recent Items from 12/4/2009
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.
-
Find NULL-able columns without DEFAULT Constraints
This is really handy when you have a large legacy database where the previous owner forgot to add DEFAULT constraints to NULL columns. ------------------------------------------------------------------------------- -- Finds all NULL-able columns that have no DEFAULT constraint. Also emits the -- ALTER TABLE statements needed to add the DEFAULT constraints ------------------------------------------------------------------------------- -- Copyright ...
-
How do -you- (I) use SQL Server?
I was recently tagged in an interesting blog post by A Misplaced New Englander, David Taylor. (dyfhid on twitter). The question sounds simple enough, “How do you use SQL Server where you work?” Of course the answer is not simple. I echo Grant Fritchey’s response in his blog post that ...
-
Highly Amusing Index Frag Anecdote
I can't believe I haven't told this story from SQLPASS yet... and by the way, here's Paul Randal's blog on this same event/topic. One of the few sessions I managed to attend was a really cool Grant Fritchey (blog, twitter) session on DMVs. He was ...
-
Allowing for Gradual Source System Changes in ETL
Recently, the main source system for my company's (eventual) data warehouse underwent a significant change. It's an in-house developed and maintained system - so most changes are very gradual over time, and the developers are very aware to keep the interface to external systems as static as possible. However, there ...
Pulse is a section of SQLServerPedia that gives you a quick view of what's happening in the SQL Server community.