LINQ to SQL in Action: Joining and GroupingCommented on: 6 years ago
(May 12, 2009)
Marco, thanks for your comment. Here's Dino Esposito's reply:
"The reader is right when he says that most of the time T-SQL statements written by programmers are the main cause of troubles. However...
Build the Numbers Table You NeedCommented on: 6 years ago
(February 19, 2009)
Uh oh, I don't know what happened to the article, but I'll get the problem fixed as soon as possible. Anne Grubb, web editor
SQL Server 2008 Editions - 30 Oct 2008Commented on: 6 years ago
(November 6, 2008)
ledman, here's Mike Otey's response to your question: "Yes. The SQL Server 2008 Developer Edition can be used by multiple developers. You don’t need a separate copy for each developer." Thanks for...
Performance Effects of Using GUIDs as Primary KeysCommented on: 6 years ago
(October 23, 2008)
Eugene, thanks for pointing out the missing links. I've updated them with the correct URLS in the article. The links are:
The Cost of GUIDs as Primary Keys, http://www.informit.com/articles/article....
Migrating to SQL Server 2008Commented on: 7 years ago
(August 18, 2008)
Hi pward, Thanks for your feedback. Have you checked out any of the articles or other resources in the Learning Path, Related Articles, and resources lists--see the list titled "Learning Path,"...
Using DTS to Populate a Data WarehouseCommented on: 7 years ago
(July 24, 2008)
Thanks, Marcos. As you mentioned, we do have online archives for SQL Server Magazine articles, going back to the first issue--March 1999. I often see reader comments on older articles and am glad to...
Rebuild Only the Indexes that Need HelpCommented on: 7 years ago
(July 1, 2008)
DHAY1999, thanks for notifying us of the problem. The procedure in Listing 1 does indeed appear incomplete. I will contact the editor and get the problem resolved ASAP.
This blog post is a bit of a ‘repeat’ – since I already covered much of the rationale behind this post in Part 23 of my multi-part series on AlwaysOn Availability Groups and SQL Server Agent Jobs. But, I also figured that this is enough of an important topic to merit its own blog post....More
Virtualization has long been a staple when it comes to computing. In essence, virtualization is really just the use of abstraction to make things either easier to manage or more fault-tolerant. Disks, for example, have long been virtualized in the sense that a single, physical, can easily be divided up into multiple logical (or virtual) volumes (or drives) just as easily as a number of discreet physical disks can also be virtualized into a single drive (via RAID) – which can further be partitioned into volumes, LUNs, and so....More
My initial goal in writing this series of posts was to outline some of the concerns surrounding Availability Groups (AGs) and SQL Server Agent Jobs – and call out how there is virtually no guidance from Microsoft on this front and then detail some of the pitfalls and options available for tackling this problem domain. I initially expected this series of posts to have between 25 and 30 posts – according to some of the early outlines I created ‘way back when’....More