There are lots of things to think about when you design a physical database. What data types should I use? What column is appropriate for the primary key? Are there particular indexes that I should use to improve performance? How should I implement data integrity rules? This list goes on and on. In this article Greg Larsen will be exploring different physical database design elements.
There should be some method to your madness when fixing code. At least, that's what Linus Torvalds thinks and Steve Jones agrees.
Databases are unique in IT that they are singularly resistant to 'best practice' advice. Any such advice can never be anything other than a starting position for tests in your own environment.
The challenge is to create a query for a report that show expiring material
Step-by-step instructions how to build a stored procedure that dynamically constructs and executes a merge statement within SSIS.
In this next article in our series where well-known SQL Server people write about their favorite SQL Server Howlers, we asked Tom Larock for his top five common misunderstandings about how SQL Server works that end in tears, and plaintive forum questions.
A detailed look the B-Tree structure – Leaf level and non-leaf level.
Do sub query expressions introduce a performance penalty on retrieving large data sets?
Today we have a guest editorial from Andy Warren. Are you in a survival job? Read Andy's thoughts and let us know.
XML data can become a full participant in a SQL Server Database, and can be used in views, functions, check constraints, computed columns and defaults. Views and table-valued functions can be used to provide a tabular view of XML data that can be used in SQL Expressions. Robert Sheldon explains how.
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...
At FARE Labs Pvt. Ltd., our inspection and auditing services focus on precision, quality...
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Comments posted to this topic are about the item Expanding into Print
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers