Lookup tables can be a force for good in a relational database. Whereas the 'One True Lookup Table' remains a classic of bad database design, an auxiliary table that holds static data, and is used to lookup values, still has powerful magic. Joe Celko explains....
The 2011 edition of MVP Jacob Sebastian's T-SQL Quiz is underway. You can take part in the quiz each day, submitting your answers for the chance to show off your knowledge and perhaps win some prizes.
Today we have an editorial reprinted from Jan 15, 2006 as Steve is on vacation. This one talks about the patching process at Microsoft, and why it sometimes is slower than we might like.
How the JOIN operator works, the different types of JOINs and relevant information about joining tables.
Probably not the kind of change you're expecting. I've recently been contacted by the Kimball Group, and they've asked me...
You need to provide data validation at the server level for complex strings like phone numbers, email addresses, etc. You may also need to do data cleanup / standardization before moving it from source to target. Although SQL Server provides a fair number of string functions, the code developed with these built-in functions can become complex and hard to maintain or reuse.
This article provides a practical example of minimizing the growth of a distribution database.
Depending on your anticipated workload and which SQL Server components you have installed, there are a number of instance level...
A free day of training in Denver on Mar 5, 2011. Learn about Windows, .NET, SQL Server, Sharepoint and more. Spread the word to people you know in the area.
Steve Jones talks a little about the 2011 MVP Summit and what the annual event means to the average DBA.
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
Comments posted to this topic are about the item Forward Deployed Engineers
Comments posted to this topic are about the item TRY_PARSE vs TRY_CONVERT in SQL...
Comments posted to this topic are about the item DBCC CHECKDB Limits II
I have a SQL Server 2025 database that I want to check for corruption every night. One of the things we do is disable indexes used for ETL loads during the weekend and re-enable them on Monday morning. If we run DBCC over the weekend, are our disabled indexes checked for consistency?
See possible answers