I'm designing a table and I've decided to create an auto-generated primary key value as opposed to creating my own scheme or using natural keys. I see that SQL Server offers globally unique identifiers (GUIDs) as well as identities to create these values. What are the pros and cons of these approaches?
Agile, or maybe even hyper-agile. Steve Jones talks about some challenges in the web 2.0 world.
When a project is completed, one of the next steps is to roll this project out to the production environment. However a good rollback process is important to ensure that you can remove those changes if there are problems. Longtime author David Poole talks about how he handles this.
Steve Jones talks about virtualization with databases, but not in the way you might think.
Steve Jones talks about virtualization with databases, but not in the way you might think.
Steve Jones talks about virtualization with databases, but not in the way you might think.
This article demonstrates the performance improvements that can be achieved using Filtered Indexes in SQL server 2008
We are required to report from our SQL Server 2005 database. There are five or six tables regularly used for holding the reporting data, but these tables have five-to-seven million rows of data in them already. We need to use these tables consistently and our performance involving reporting is struggling. Do you have any tips to help improve it?
Sometimes determining who owns the data or information isn't that easy. Steve Jones has an example from the US election in 2008.
Diving deeper into Reporting Services with this SQL School video, MVP Brian Knight shows how to create a report with a multi-select parameter, allowing the user to select multiple items for inclusion in the report.
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Forgive me for the title. Mentally I’m 12. When I started my current day...
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Comments posted to this topic are about the item Expanding into Print
Comments posted to this topic are about the item Downtime Caused by the Postgres...
Comments posted to this topic are about the item The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers