Saving Space – Vertical Partitioning
I wrote about data types recently, referencing Michelle Ufford’s presentation at the PASS 2009 Summit. In that post I talked...
2010-02-14
1,533 reads
Blog Posts
SQL Server 2005 SP4!
Microsoft has recently announced the planned release dates for the next round of SQL Server service packs. SQL Server 2008...
2010-02-14
696 reads
Useful reading this week
This is a short post for a Sunday afternoon, I thought I’d share some useful reading from the week gone...
2010-02-14
868 reads
SQL Server 2005 & 2008 SP Release Dates
Microsoft has announced that Service Pack 2 for SQL Server 2008 will be released in the third quarter of 2010,...
2010-02-13
807 reads
SQL Server 2005/2008 Servicing Plans
Microsoft Group Program Manager Matthias Berndt has a post up on the Microsoft SQL Server Release Services blog (which is...
2010-02-13
591 reads
A Tale Of Two Execution Plans – Solved!
Earlier this week I wrote about a perplexing problem I was having where identical servers were producing different execution plans...
2010-02-12
1,301 reads
eReading – Lending Books
I sent this to Barnes and Noble, as well as Random House recently after the much vaunted “lending” technology in...
2010-02-12
723 reads
Farewell, Robert B. Parker
I heard the news via a blog post by Ward Pond that one of my favorite authors had died at...
2010-02-12
1,729 reads
Foundation Class Review
This week was an exciting teaching week for me. I taught the Pragmatic Works Foundation class, one of my favorite...
2010-02-12
663 reads
Free SQL Server Training Webinar Series
SQLServerCentral.com, PragmaticWorks, and Wrox Press are sponsoring a series of free SQL Server webinars in February. Called the SQL Server...
2010-02-12
883 reads
Blogs
The Book of Redgate: Do the Right Things
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
Forums
Jabatan Imigresen Certified Translators: Trusted Support for Official Documents
When preparing documents for immigration in Malaysia, accuracy and compliance are essential. Working with...
Let's Talk Community Events!
Comments posted to this topic are about the item Let's Talk Community Events!
that one limitation in replication
Hi as shown below a replication target requires a primary key. if we want...
Question of the Day
Detecting Deadlocks
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers