Watch this week's video on YouTube
A while back I learned that it's possible to create temporary stored procedures in SQL Server.
I never put that knowledge into practice however because I...
2019-04-02
4 reads
One of my favorite recent additions to SQL Server is the ability to use temporal tables to retain change history. As I wrote in an earlier post on this...
2019-04-02
129 reads
As we get closer to the end of mainstream support for both SQL Server 2008 and SQL Server 2008 R2...
2019-04-02 (first published: 2014-01-27)
2,469 reads
The use of statistics in SQL Server is tightly embedded in the query optimizer and query processor. The creation and maintenance of statistics is usually handled by the SQL...
2019-04-01
212 reads
The Complaint(s) When I was young, I went to nursing school. In school, we were taught that in order to come up with a proper diagnosis, the doctor first...
2019-04-01
38 reads
An indexed view is a view where the result set from the query (the view definition) becomes materialized in lieu of the virtual table result set of a standard (non-indexed) view. Many...
2019-04-01
4 reads
I was inspired by Jen McCown’s story here. Read that first. It’s WAY better than mine. This is not an April Fools post. Fools are involved, but none were...
2019-04-01
111 reads
It is with a very heavy heart that I announce I will no longer be working with SQL Server. In ... Continue reading
2019-04-01
92 reads
Mentorship is the influence, guidance, or direction given by a mentor as defined by Webster’s dictionary. I believe it involved a little more than that. It also involves investing...
2019-04-01
3 reads
Mentorship is the influence, guidance, or direction given by a mentor as defined by Webster’s dictionary. I believe it involved a little more than that. It also involves investing...
2019-04-01
2 reads
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Comments posted to this topic are about the item Finding Motivation
Comments posted to this topic are about the item The Last Binary Value of...
Comments posted to this topic are about the item SQL Art, Part 2: New...
What does this code return?
SELECT cast(0x2025 AS NVARCHAR(20))Image 1:
Image 2: 
Image 3: 
Image 4: 
See possible answers