SQL Server Code,Tips and Tricks, Performance Tuning
I interviewed Louis Davidson in 2005 about the 2005 edition of his book. I did another one today about Pro SQL Server 2008 Relational Database Design and Implementation. You can check out the interview at the link below, you will enjoy itInterview With Louis Davidson Author of Pro SQL Server 2008 Relational Database Design (Read More)
Denis Gobo
Microsoft just released an interesting press release: Microsoft Closes Acquisition of DATAllegroThe important stuff from this press release: Microsoft will offer a new solution based on DATAllegro’s technology that extends Microsoft SQL Server to scale into hundreds of terabytes of data. The company will begin giving custo (Read More)
Data Management
ISO Week in SQL ServerFirst let’s take a look at what ISO week is, from WikiPedia:Week date representations are in the format as shown below.YYYY-Www or YYYYWwwYYYY-Www-D or YYYYWwwD[YYYY] indicates the so-called ISO year which is slightly different than the calendar year (see below). [Www] is the week number prefixed (Read More)
Silicon Alley Insider
YouTube has always been very clear about the separation of editorial content and sponsored ads on its site: While the site is eager to sell advertising, placements as "featured" or "promoted" videos -- incredibly valuable, high-traffic spots on the homepage -- are not for sale.The "featured" and "promoted" videos on the hom (Read More)
Data Management
Adam Machanic created an item on connect explaining how LINQ to SQL queries involving strings cause SQL Server procedure cache bloatIf an application is using LINQ to SQL and the queries involve the use of strings that can be highly variable in length, the SQL Server procedure cache will become bloated with one version of t (Read More)
Data Management
Take a look at this query.tsqlLine number On/Off | Show/Hide | Select allSELECT * FROM ( SELECT customer_id, ‘MTD’ AS record_type, COUNT(*), SUM(…), AVG(…) FROM payment_table WHERE YEAR(payment_dt) = YEAR(GETDATE()) and MONTH(payment_dt) = MONTH(GETDATE()) GROUP BY customer_id) MTD_payments UNION A (Read More)
: Only In A Database Can You Get 1000% + Improvement By Changing A Few Lines Of Code. In this case the query run time went from 24 hours+ to 36 seconds!!!
Data Management
Visual Studio 2008 does not support having both Visual Studio 2008 without a service pack and Visual Studio 2008 with SP1 installed on the same computer. Because certain SQL Server 2008 features install components that are also part of the release version of Visual Studio 2008 SP1, SQL Server 2008 requires Visual Studio 200 (Read More)
Crunch Gear
Steve Jobs has admitted that the MobileMe launch was “not up to Apple’s standards.” That’s in reference to all the problems the service has had since it launched last month. Jobs admitted as much in an internal e-mail sent to Apple employees, which Ars Technica got a hold of. He said MobileMe shouldn’t hav (Read More)
Submitted by Startrak118:
Who doesn't like a helpful cheat sheet to have around? They save so much time and really help you learn what you are working with in an easy to understand format. I have gathered a list of the cheat sheets I have found to be the most helpful. There are cheat sheets from PHP to CSS to RegEx, and I have listed over 40 differe (Read More)
: Great find. A lot of work there. If you already know one or two languages pretty well, a cheat sheet is sometimes all you need to use another new one on the fly.