I actually saw the above statement posted online. The person making the claim further stated that choosing between these three constructs was “personal...
2016-08-01
1,386 reads
Blog post #7 in support of Tim Ford’s (b|t) #iwanttohelp, #entrylevel. Read about it here.
Sooner or later when you’re working...
2016-07-28 (first published: 2016-07-25)
2,619 reads
The Common Table Expression (CTE) is a great tool in T-SQL. The CTE provides a mechanism to define a query that...
2016-07-21 (first published: 2016-07-18)
3,600 reads
Based on the number of times I see this question on forums, it must be occurring all the time. You...
2016-07-19 (first published: 2016-07-11)
2,413 reads
Set based operations means you should put everything into a single statement, right?
Well, not really. People seem to think that...
2016-07-06 (first published: 2016-06-28)
4,815 reads
Let’s get the caveat out of the way up front, I work for a tool vendor.
If you look around at...
2016-07-05
1,230 reads
On the First of June, SQL Server 2016 was officially released. While it is still early days to measure the full impact of the release, the one thing that is exceedingly clear is that this is a very successful software release. There have been very few complaints online beyond the standard heard during any upgrade: […]
2016-06-27
159 reads
Because there’s nothing else I can do at the moment.
The post Because appeared first on Home Of The Scary DBA.
2016-06-14
523 reads
Post #6 of #entrylevel #iwanttohelp in support of Tim Ford’s (b|t) beginner’s initiative.
If you’re just getting started with SQL Server,...
2016-06-13
1,235 reads
The question came up, how do the constructs necessary for Elastic Query within Azure SQL Database affect your ability to...
2016-06-13 (first published: 2016-06-06)
2,143 reads
By Brian Kelley
There's a great article from MIT Technology Review about resetting on the hype of...
By Steve Jones
etherness – n. the wistful feeling of looking around a gathering of loved ones,...
By Steve Jones
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...
Comments posted to this topic are about the item The Microsoft SQL Year in...
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Comments posted to this topic are about the item Your Value from a Conference
What does this code return in SQL Server 2025+? (assume the database has an appropriate collation)
SELECT UNISTR('Hello 4E16754C') AS 'A Classic';
A: 
B: 
See possible answers