Part 19 digs deep into two of SQL 2005's ranking functions: RANK() and DENSE_RANK(). It includes performance considerations and using CTEs to avoid table variables.
We try to keep control of the data in our databases, but as the world becomes more connected, it's harder to ensure integrity. Steve Jones talks about some of the issues in this new Web 2.0 world.
We try to keep control of the data in our databases, but as the world becomes more connected, it's harder to ensure integrity. Steve Jones talks about some of the issues in this new Web 2.0 world.
We try to keep control of the data in our databases, but as the world becomes more connected, it's harder to ensure integrity. Steve Jones talks about some of the issues in this new Web 2.0 world.
Steve Jones looks back at some of the news from the week ending Oct 6, 2008.
Steve Jones looks back at some of the news from the week ending Oct 6, 2008.
Steve Jones looks back at some of the news from the week ending Oct 6, 2008.
This article describes how you can use excel to pull the data from the SQL Server and use it for report generating.
Everyone wants extreme performance from their systems, but is that always the way to look at things? This Friday Steve Jones asks about how you consider performance in your purchasing decisions.
Learn how to apply the new tracing functionality in Microsoft data access technologies such as ADO.NET 2.0, MDAC 2.82, SQL Server Native Client, and the JDBC driver; and in the SQL Server network protocols and the Microsoft SQL Server 2005 database engine. You can also download associated sample code for this article.
By Steve Jones
AI is a big deal in 2026, and at Redgate, we’re experimenting with how...
By Steve Jones
Another of our values: The facing page has this quote: “We admire people who...
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
Comments posted to this topic are about the item No Defaults Passwords Ever
Hi, We have low latency high volume system. I have a table having 3...
Comments posted to this topic are about the item The Long Name
I run this code to create a table:
When I check the length, I get these results:
A table name is limited to 128 characters. How does this work?