The Database Weekly Update for May 19. 2008
Steve Jones looks at the performance of column changes, petaflop computing, and a few ways to beef up your DBA skills.
2008-05-17
38 reads
Articles
Everybody Reports to Somebody
One of the very common questions posted about T-SQL is how to traverse a hierarchy in a set based manner. New author Craig Hatley brings us his techniques for handling the common scenario of employees and managers.
2008-05-16 (first published: 2007-06-04)
5,926 reads
Recursive Queries in SQL:1999 and SQL Server 2005
How many of you have written resursive queries in SQL? Or any language since school for that matter? Not many people write recusrive queries because of the complexity, the difficulty to understand how they work, and the chance for heap overflows. However, SQL Server 2005 implements Common Table Expressions and recursion in a way that is much easier to code and incorporates some safeguards. New author SQL Server MVP Frederic Brouard has written a fantastic article looking at resursive queries.
2008-05-16 (first published: 2005-04-25)
68,345 reads
SQL Server T-SQL in 10 Minutes
A short review of this book by Ben Forta giving you the basics of T-SQL
2008-05-16
4,789 reads
Row Value Constructor in SQL Server 2008
This article illustrates different methods to insert data into a table, including the new Row Value Constructor, which simplifies the data insertion.
2008-05-16
3,194 reads
The Database Weekly Update for May 19. 2008
Steve Jones looks at the performance of column changes, petaflop computing, and a few ways to beef up your DBA skills.
2008-05-16
300 reads
Using Policy-Based Management in SQL Server 2008
As we are reviewing the new features in SQL Server 2008, we found one that looks really interesting - Policy-Based Management. Could you help us to understand how this works and provide some examples? Can you please explain each of the components and how to manage them in the interface and with commands?
2008-05-16
2,942 reads
What Makes a Good Programmer
Are top notch programming skills innate or can they be learned? Janet Wong takes a look at the skills and capabilities of great programmers in this essay.
2008-05-15 (first published: 2007-07-03)
21,016 reads
XML Workshop XIX - Generating an ATOM 1.0 Feed
Continuing on with his amazing series on XML, SQL Server MVP Jacob Sebastian shows us how to use XML in SQL Server 2005 to generate an ATOM feed.
2008-05-15
3,211 reads
A Worthwhile Goal
Steve Jones talks about two competing priorities for many people that start at a new job and asks which one you value more in this Friday poll.
2008-05-15
42 reads
Blogs
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Local Models Using GPUs with Ollama
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
Forums
Absolute and Relative References
Comments posted to this topic are about the item Absolute and Relative References
Moving Beyond the Reboot: Finding the Culprit Behind Memory Pressure
Comments posted to this topic are about the item Moving Beyond the Reboot: Finding...
Reserved Words I
Comments posted to this topic are about the item Reserved Words I