The most optimal join type
What’s the best join type for a query? Should we aspire to seeing nested loop joins in all our queries?...
2009-11-24
986 reads
Planning Out a Holiday Weekend
I've got a four day weekend thanks to the Thanksgiving holiday here in the United States. After reading Jazz in...
2009-11-24
884 reads
SQL Server 2008: Table-valued parameters
A new feature of SQL Server 2008 is Table-valued parameters (TVP). This feature will allow Developers and DBAs to pass...
2009-11-24
825 reads
SQL Server 2008: Table-valued parameters
A new feature of SQL Server 2008 is Table-valued parameters (TVP). This feature will allow Developers and DBAs to pass...
2009-11-24
1,600 reads
Balancing Time Today v Time Tomorrow
I’ve always thought that you should invest where you can. Make a little effort now that will pay back later,...
2009-11-24
744 reads
Opening Doors – Part 2
Yesterday in Part 1 I wrote about opening doors – the art of showing others what is possible within the context...
2009-11-23
540 reads
Some Intel Westmere Benchmarks
PCLab.pl has an interesting review and benchmarks of a 3.07GHz Westmere-EP processor (which is the six-core, 32nm successor to the...
2009-11-23
994 reads
Replication Scripts: Show All Transactional Publications & Subscribers At Distributor
Anybody who has talked with me about replication or heard me present about it knows that I recommend using a...
2009-11-23
640 reads
Some Ways To Look For Things in SQL Server Modules
If you have a medium to large database in SQL Server, with lots of stored procedures, functions or views, it...
2009-11-23
516 reads
Slow Blogging
Sorry, I’ve been travelling for three weeks and, except for the posts around the PASS Summit, I’ve been blogging very...
2009-11-23
547 reads
Blogs
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Local Models Using GPUs with Ollama
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
Forums
Absolute and Relative References
Comments posted to this topic are about the item Absolute and Relative References
Moving Beyond the Reboot: Finding the Culprit Behind Memory Pressure
Comments posted to this topic are about the item Moving Beyond the Reboot: Finding...
Reserved Words I
Comments posted to this topic are about the item Reserved Words I