|
|
|
|
Got a SQL Server question that needs answering? SQLblog now has a SQL Server forum that can be found at http://sqlblog.com/forums/57/ShowForum.aspx.
Latest Blog Posts
-
|
My previous post shows that data compression may not come for free, although hopefully by the RTM time the adverse performance impact on inserts will have been reduced significantly. In this post, I want to show you that data compression can enhance read...
|
-
|
After my The Sad State Of Programmers Part 1 : The Phone Interview series I got an email from a person. Thank you so much for making me realise how little I know. I’ve been programming first in Microsoft Access VBA and VB6 since 1997 (Some little playing...
|
-
|
A good friend of mine is putting together a presentation on the top DBA Blunders from the view point of a SQL Server Database Admin, not developer. He would love to hear what other people consider to be in the big mistake list. Of course, you don't have...
|
-
|
Yet another very common error is when someone puts a wrong condition in a WHERE clause and that essentially renders an outer join into an inner join. A great advice on coding predicates in outer joins comes from a DB2 expert Terry Purcell. "Meet the experts:...
|
-
|
I will be presenting Change Data Capture, Incremental ETL, and SSIS 2008 to Philadelphia Code Camp 2008.2 Saturday, 17 May 2008! The good folks in Philadelphia always do a great job with Code Camps and the attendance numbers are growing to reflect that!...
|
-
|
I'll be in Kansas City next week doing some SSIS training. I don't think I've ever been to KC so I'm looking forward to the trip! When I found out I would be in town, I dutifully contacted the Kansas City SQL Server Users Group to see if they were having...
|
-
|
Yesterday, I did a webcast on "Avoiding stored procedure recompiles" for PASS and SolidQ India. They recorded the webcast and it's freely available for download from here: http://www.solidq.com/webcasts/SqmAndPass2008Series/3/ReplayMeeting.htm Share this...
|
-
|
Happy Spring everybody! As of late I've been heads down working on a new course on SQL Server 2008 and its been a lot of fun. So the other way when the Visual Studio team dropped SP1 Beta1 for Visual Studio 2008 ( see here ) I was all over it. And it...
|
-
|
You might encounter a situation, under a very heavy workload, where processing for certain transactions starts out very efficiently, but over time becomes much less efficient. A good place to start troubleshooting is, of course, PerfMon. But PerfMon can...
|
-
|
I am going to discuss several potential problems with referential integrity, because they keep coming up in the newsgroups. Parent and Child Tables Are in Different Databases. Although you cannot use a foreign key in this situation, there are workarounds...
|
-
|
Before I begin, let me be very clear that the results I report in this post were obtained with SQL Server 2008 CTP6. Microsoft is still working on improving the performance of data compression. And in particular, the performance of inserting into a compressed...
|
-
|
ScottGu has a great post about enhancements in Visual Studio 2008 Service Pack 1, released today in Beta. Of particular interest to database developers: SQL Server 2008 support, a built-in Entity Data Modeler, and REST support! :{> Andy Share this...
|
-
|
Time is almost up; this is the last chance to submit your questions to Erland Sommarskog and Craig Freedman . I mean, you don’t want me to come up with all the questions myself do you? That would be considered cruel and unusual punishment. Share this...
|
-
|
In my previous post on data compression, I looked at how rebuilding a table with page compression works with multiple processors via the MAXDOP option. In this post, I'll focus on what compression ratios I have seen in the real-world databases. Now, if...
|
-
|
I am disappointed in Cisco. I have Vista Ultimate x64 installed on my snappy new Red laptop but I cannot install Cisco VPN Client software on it because Cisco VPN Client does not run on Vista 64-bit platforms. Digging around for a work-around, I came...
|
-
|
Kevin Hazzard did an outstanding job presenting to the Richmond SQL Server Users Group this evening on LINQ To SQL! I really like the ORM / code generation aspects of this new feature of the .Net Framework 3.5. Seeing it in action made me yearn (a little)...
|
-
|
Mladen Prajdić just released SSMS Tools PACK 1.0 . SSMS Tools PACK is an Add-In (Add-On) for Microsoft SQL Server Management Studio and Microsoft SQL Server Management Studio Express. Here are some of the features Uppercase/Lowercase keywords. Run one...
|
-
|
This question came up today and here is one way of doing it. It requires running xp_cmdshell so this is probably not such a good idea. The problem with functions is that you cannot just insert into any table. INSERT, UPDATE, and DELETE statements modifying...
|
-
|
Without running this what do you think will be printed? SET ROWCOUNT 0 DECLARE @ int SET @ = 6 IF @@ROWCOUNT = 1 PRINT 'yes' ELSE PRINT 'no' PRINT @@rowcount Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | live it!...
|
-
|
After numerous questions and requests, we decided to create a forum for all SQL Server related questions. You can view the new forum at http://sqlblog.com/forums/57/ShowForum.aspx or use the Forums menu item on the site to browse there. We hope this new...
|
|
|
|
|
|