The Northwind database has a place in our collective hearts, despite all efforts to displace it in favor of AdventureWorks. However, a lot has happened in the past twelve or so years, and Phil Factor wonders if we can't, as a community, do better.
2009-03-11
161 reads
Phil Factor muses on the power, and potential failings, of the relational database, and wonders if those responsible for its development should feel any guilt about the opportunities for abuse of the power that it affords.
2009-03-02
128 reads
In which Phil illustrates an old trick using STUFF to intert a number of substrings from a table into a string, and explains why the technique might speed up your code...
2009-02-18
1,631 reads
Now, we are going to get slightly esoteric here. I'd noticed that the performance of string concatenation tasks didn't increase...
2009-02-16
14,606 reads
There are a number of occasions when one might want to insert information at various places in a string. Where...
2009-02-12
1,885 reads
Phil takes us through one of the best kept secrets of SSMS - Templates. Even for a 'plain-screen' man like Phil, Templates are an excellent tool, and a major reason to use SSMS.
2009-02-06
277 reads
In which Phil Factor's attention wanders whilst reading some software product announcements and imagines what would have happened if the current IT Bloggers had been in charge of the White Star Line at the time of RMS Titanic.
2009-02-03
131 reads
In which Phil Factor responds to the muse and writes a poem in the style of a School Song, in which he tries to give a mention to all the top writers and forum-posters.
2009-02-02
84 reads
I have been admonished in the past for the use of this code which makes as many
substitutions as you like...
2009-01-23
1,158 reads
In which Phil hears about an extra 'leap' second added over the new year, and broods on the missing INTERVAL datatype in SQL Server
2009-01-05
128 reads
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Jl. Paus No.81, RT.1/RW.8, Wil, Kec. Pulo Gadung, Kota Jakarta Timur, Daerah Khusus Ibukota...
BCA KCU PASAR BARU Telpon/WA:087768193341.Jl. Samanhudi No.8, Ps. Baru, Kecamatan Sawah Besar, Kota Jakarta...
Gg. Tengah No.88, Kranggan, Kec. Semarang Tengah, Kota Semarang, Jawa Tengah 50137
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers