This topic is nothing new, but well worth revisiting for those who have not used CROSS JOINS. You may have faced a problem where you need to compare historical records for a particular set of records to ensure that records have been saved in the correct order.
2009-01-28
4,596 reads
Lynn Pettis gives us a look at a new way to solve a T-SQL problem.
2009-01-27
12,363 reads
It can be helpful in ETL operations to know what the distribution of your data is. Brian Knight shows how to use the Data Profiling task in this video.
2009-01-27
5,133 reads
I have found that I like to generate a script once and roll it out to multiple servers at the same time. SQL Server 2008 Management Studio makes that fairly easy by allowing one window to connect to multiple instances simultaneously
2009-01-27
1,518 reads
The topic of plagiarism rears its head at SQLServerCentral and Steve Jones has some comments and an apology.
2009-01-27
537 reads
The topic of plagiarism rears its head at SQLServerCentral and Steve Jones has some comments and an apology.
2009-01-27
530 reads
The topic of plagiarism rears its head at SQLServerCentral and Steve Jones has some comments and an apology.
2009-01-27
805 reads
This technical note is part of the Building and Deploying Large Scale SQL Server Reporting Services Environments technical note series, which provides general guidance on how to set up, implement, and optimize an enterprise scale-out architecture for your Reporting Services environment. This note provides guidance for Reporting Services in both Microsoft® SQL Server® 2005 and SQL Server 2008. The focus of this technical note is to optimize your Reporting Services architecture for better performance and higher report execution throughput and user loads
2009-01-27
3,553 reads
New author Greg Bates brings us a few tips for those of you new to being a DBA or without much experience.
2009-01-26
14,623 reads
Learn how you can monitor the SQL Server instances for failover of a cluster or a restart.
2009-01-26
3,621 reads
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Comments posted to this topic are about the item SSRS Is Dead. Here Are...
Comments posted to this topic are about the item The Distance Metric
Comments posted to this topic are about the item The New Wave of Security...
In the new VECTOR_DISTANCE() function in SQL Server 2025, the first parameter is the distance_metric. What is this?
See possible answers