In this article I discuss a new feature in SQL 2008, table-valued parameters and particularly the restriction that they have to be read-only. I argue that this makes this feature considerably less useful that it could be, and that in order to build scalable applications be able to pass read-write table parameters between stored procedures is essential.
2008-04-02
2,677 reads
A new XBOX 360 title is being released today for the DBA in you.
2008-04-01
7,662 reads
2008-04-01
4,971 reads
2008-04-01
9,302 reads
What changes are coming in the editions for SQL Server 2008. Steve Jones finds a rather scary piece of literature.
2008-04-01
40 reads
What changes are coming in the editions for SQL Server 2008. Steve Jones finds a rather scary piece of literature.
2008-04-01
40 reads
Today, in a surprise development that has stunned industry analysts, SQLskills.com announced a new technology for DBAs that will help in the never-ending battle against human-error and unforeseen disasters. The patent-pending Time-Setback technology allows DBAs of SQL Server to literally rewind time and avoid disasters before they happen.
2008-04-01
2,298 reads
A discussion on using CTEs to speed the development and maintenance of reports and enhance readability.
2008-03-31
6,207 reads
How many times have you wished that your queries performed better? Performance Tuning is a bit of an art, but learning about new techniques and which things work help grow your knowledge. Jacob Sebastian brings us the first part of a series on writing better performing queries.
2008-03-31 (first published: 2007-05-22)
30,079 reads
Steve takes a day off from the editorials with this blooper reel from the podcasts. Be sure to watch the video.
2008-03-31
41 reads
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
You can find the slides and SQL scripts for my session “Spice up your...
Comments posted to this topic are about the item Communication, For Incidents and Life
Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Tables
Comments posted to this topic are about the item Building a Support Ticket Triage...
Which of the following psql meta commands (also called backslash or slash commands) will provide information about tables within a database?
See possible answers