Recent Posts
<<
Page 1 of 41
>>
Oct 9 Thu
Using Table Variable vs Temp Table and Estimated vs Actual Query Plan
SQLCAT Team writes "When examining query plans be careful to consider possible plan change during the batch execution due to recompiles. Bear in mind that while table variables are not causing recompiles, you may need just the opposite to get the best query plan...You will find some great information about table variables and temporary tables in..."
Oct 8 Wed
Summarizing the SQL Server Support Running in a Hardware Virtualization Environment
PSS SQL Engineers writes "...If you use Windows Server 2008 with Hyper-V or Microsoft Hyper-V Server 2008, you are supported for SQL Server 2005 and 2008..If your configuration is not SVVP certified, be prepared for Microsoft CSS to ask you..."
Easiest Way to Get Data Mining Results Into SQL Tables
Jamie MacLennan writes "The way to do it is to simply use linked servers. Anyone who uses DMX knows to connect to SQL data with OPENQUERY. There's no reason you can't simply connect to Data Mining data using the same mechanism. For example, use a query like this to establish a link to an AS server:"
Oct 5 Sun
Model Collation vs. Database Collation
Gert Drapers writes "When you are using the latest CTP of the GDR release, you might have noticed that we introduced a new collation, named the "model collation". However if you go to the Database.sqlsettings file, which contains all the database properties, you will also find the "Database collation" like we had this in the previous releases. What is the difference and why should you care?"
Oct 3 Fri
Troubleshooting "Error applying transforms" During Uninstall
Julie Lerman writes "Today's time-sucker was not Crystal's fault but the fact that when I installed the earlier version of Crystal on to the laptop, I had done it from an external drive. When I tried to install the newer version, it chugged along then said that it failed because it couldn't uninstall the previous version. I attempted to do the uninstall myself..."
Sep 30 Tue
Code Showing How to Preserve Formatting with LINQ to XML
Charlie Calvert writes "...how to: Read in an XML file with an arbitrary format, and then write it back out to disk in exactly the same format. Read in an XML file with an arbitrary format, and write it back out with standard formatting Some scenarios where you might need this..."
The Journey of SQL Server 2008 Patching
PSS SQL Engineers writes "We have posted the first cumulative update for SQL Server 2008 aptly named Cumulative Update 1 (CU1). I thought before you considered installing a patch for SQL Server 2008, you would like to see a tour of what it looks like compared to SQL Server 2005 patch installations."
EF Queries for Parents Who Have 1:0..1 Relationships to Their Children
Julie Lerman writes "When you query an entity that has a parent, for example an OrderDetail, that query will go over to Order so that EF can build the related EntityKeys. This is because when OrderDetail is materialized, it will need to populate..."
Examples of LINQ to TEXT and LINQ to CSV
Eric White writes "...I simply use File.ReadAllLines and write queries over the returned string array. After all, my computer has a lot of RAM (and probably yours does too), and the CSV files I receive are maybe in the 50K size, and are rarely greater than a few hundred K. It simply doesn’t matter that I read the entire text file into memory..."
Sep 26 Fri
Comparing SQL Server 2008 Patching to SQL 2005
PSS SQL Engineers writes "
I thought before you considered installing a patch for SQL Server 2008, you would like to see a tour of what it looks like compared to SQL Server 2005 patch installations...The uninstall of CU1 does something very interesting when it is done. It does not remove the updates to the SQL Server 2008 Setup Support Files..."
Sep 25 Thu
SQL Server Error: 916 Browsing Hosted Databases With SQL Server 2008 Mgmt Studio
Julie Lerman writes "I was just having a particular security problem with the Object Browser. When I tried to expand the list of the databases so that I could see mine and work with my db objects, I kept getting an error message that my login was invalid for someone else's database - even though I wasn't trying to access it..."
Sorting Out issues When Moving to Crystal Reports 2008
Julie Lerman writes "...The VS part was a breeze. It was the move to Crystal Reports 2008 that slayed me. I learned a lot of lessons during this process...in the hopes of helping others have a smoother transition..."
Sep 23 Tue
LINQ to SQL T4 Template for Visual Studio 2008
Steele Price writes "I was looking for a better way to customize the Linq to SQL CodeSpit and this lets us do it from inside Visual Studio in a very painless way. No extra tools required. CodeSmith and CodeRush are still quite valueable, but this method integrates very nicely without requiring extra tools..."
Sep 19 Fri
CLR Methods Not Always the Best for LINQ to Entities
Julie Lerman writes "Not all CLR methods can be used when building LINQ to Entities or LINQ to SQL queries. The method needs to be something that can be expressed in the native query language. So if you have a date field, you can't use ToShortDateString..."
ForEach is a Very Useful Extension Method
Glenn Block writes "...I was writing some code...for an Xml based MEF catalog I am prototyping. I came across the need to invoke a set of methods on an IEnumerable < T > that was returned from a LINQ to XML query...It took me < 5 mins to write this"
<<
Page 1 of 41
>>