Last month, Phil Factor caused a furore amongst some MVPs with an article that dared to suggest that for reasonably small-scale strategic uses, and with a bit of due care and testing, table variables are a "good thing". Not everyone shared his opinion.
The DBA in Space competition ends this Friday, November 18. You can still enter, and answer all the questions this week. If you work with databases in any way, you're eligible.
For anyone eager for a long-term career in IT Development, humility and tact are probably more important habits to acquire than demon coding-skills. Phil Factor explains why.
We have less people studying technical subjects and an apparent shortage of technical talent in the IT field. Steve Jones thinks we might have an industry wide problem.
This article describes my experience in upgrading a four node cluster with three active instances to SQL 2008
Your job is to write a TSQL query that returns the advertisements most relevant to each web page given in the source table.
In this webinar consisting of 30 minutes of software demonstrations followed by Q&A, you will learn how to link your database to your existing source control system within SQL Server Management Studio using Red Gate’s SQL Source Control.
We will also give you an exclusive preview of forthcoming custom scripts features in the next version of SQL Source Control and SQL Compare.
With SQL Server 2012, we are soon to enjoy a full range of Window Functions. They are going to make for some much simpler SQL queries, as Fabiano Amorim ably demonstrates here.
Today we have a guest editorial from Andy Warren that examines the first impressions that you create when you meet someone.
This series of technical articles describes organizational approaches to master data management.
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
The DBA life is fraught with pain. Those battles that we endure are mostly...
WA:08218154393 Jl. Ps. Pagi Raya No.9, RT.2/RW.2, Roa Malaka, Kec. Tambora, Kota Jakarta Barat,...
Comments posted to this topic are about the item A Quick Second Opinion
Comments posted to this topic are about the item Five Intelligent Query Processing Features...
On my SQL Server 2025, I want to search the error log from my T-SQL code for potential issues and then inform an administrator. What is the current way to easily query the error log?
See possible answers