Denali – Day 25: Tools: Add-on to Sql server 2008 (R2)
Denali – Day 25: Tools: Add-on to Sql server 2008 (R2)
MDS and Best Practice Analyzer new features were introduced in sql...
2012-05-25
704 reads
Blog Posts
Exercise in the Margins
This article about exercising when you can is really interesting. It contains a number of hints about exercising and fitting...
2012-05-25
1,170 reads
From the Labs of SQL Prompt
I love SQL Prompt as an add-in for SSMS. The intellisense is very handy for me and I’ve gotten used...
2012-05-25 (first published: 2012-05-21)
2,709 reads
How to restore the tail end of a transaction log
Have you ever tried to restore a backup over an existing database and receive an error stating the tail of...
2012-05-25 (first published: 2012-05-21)
2,536 reads
SQL Server – Cannot resolve collation conflict
A friend of mine contacted me through email today having a very common problem with a query he had written....
2012-05-25
806 reads
The Done Stamp
I’m fond of replying with “done” when a task is complete, no need for anything more elaborate. I’ve been experimenting...
2012-05-25
590 reads
Denali – Day 24: True Black Box Recorder – sp_server_diagnostics
Denali – Day 24: True Black Box Recorder – sp_server_diagnostics
Earlier sql server was having diagnoses tool.
Default trace.
SQLDiag
And other tools but could not...
2012-05-24
1,431 reads
It’s OK To Eat Alone
There’s a lot to be said for the philosophy of Never Eat Alone, using meals as a great time to...
2012-05-24
766 reads
Recently Used Tables and Databases
Recently developed these queries to assist with the evaluation of development or sandbox environments. Sometimes disk space demands that old...
2012-05-24
1,590 reads
SQLServerCentral.com Track Offered at 2012 SQL Server Connections in Las Vegas this Fall
As we have done for the last several years, SQLServerCentral.com will be offering its own track at SQL Server Connections...
2012-05-24 (first published: 2012-05-21)
2,175 reads
Blogs
Quick Tip: Check Most DTU Expensive Queries in Azure SQL Database
Optimizing Azure SQL Database performance often begins with identifying the most resource-intensive queries. Understanding...
PowerShell Newbie – Variables
By gbargsley
This is Week 2 of PowerShell Strikes Back – a four-week May series for...
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
Forums
SSRS Is Dead. Here Are Your Real Options
Comments posted to this topic are about the item SSRS Is Dead. Here Are...
The Distance Metric
Comments posted to this topic are about the item The Distance Metric
The New Wave of Security Threats
Comments posted to this topic are about the item The New Wave of Security...
Question of the Day
The Distance Metric
In the new VECTOR_DISTANCE() function in SQL Server 2025, the first parameter is the distance_metric. What is this?
See possible answers