Multiple query plans for the same query?
A while back i was creating a stored procedure to be used for pulling data from the SQL Server into...
2011-10-25
13,712 reads
When was SQL Server restarted?
One of the main goals with this blog is to write stuff when we learn / discover new things or smarter...
2011-10-18
1,470 reads
Dude, Where is my memory?
We all know that SQL Server loves memory, and in my opinion SQL Server can never have to much RAM....
2011-10-11
682 reads
Index usage
Last week I blogged about how to get help identifying possible missing indexes by using some of the DMV’s provided...
2011-10-04
791 reads
Missing indexes
One of the most common things I encounter when asked to help with performance problems, is wrong or inadequate indexing....
2011-09-27
1,401 reads
How to monitor number of VLF’s in your database
A few weeks back we did a blog post about a file grow bug that has been fixed with SQL...
2011-09-20
1,624 reads
T-SQL Function: EOMONTH
We have all been in a situation where we had to get the last day of the month with T-SQL....
2011-09-13
5,766 reads
Blog Series: T-SQL Enhancements
Three months back in this blog post – T-SQL Enhancements in SQL Server Denali (2011) – we promised to do a series...
2011-09-06
992 reads
New LOGICAL functions in SQL Server Denali
IFF Function
If you are an old Access or Excel “developer” you know this one. This is not a function I...
2011-09-06
2,965 reads
T-SQL Enhancements: FIRST_VALUE() and LAST_VALUE()
A couple a weeks ago I blogged about a few of the enhancements in the OVER clause, and now I...
2011-08-30
4,630 reads
Blogs
SQL, MDX, DAX – the languages of data
By DataOnWheels
Ramblings of a retired data architect Let me start by saying that I have...
Setting PK Names in Redgate Data Modeler
By Steve Jones
A customer was testing Redgate Data Modeler and complained that it auto-generated PK names....
Flyway Tips: AI Deployment Script Descriptions
By Steve Jones
With the AI push being everywhere, Redgate is no exception. We’ve been getting requests,...
Forums
Connecting Power BI to SSAS and effective user not working
Hi everyone, Below is a consolidated summary of what we validated Architecture & data...
High Availability setup - has anyone seen this method?
Hi all, I recently moved to a new employer who have their HA setup...
Semantic Search in SQL Server 2025
Comments posted to this topic are about the item Semantic Search in SQL Server...
Question of the Day
Encoding URLs
I have this data in a SQL Server 2025 table:
CREATE TABLE Response ( ResponseID INT NOT NULL CONSTRAINT ResponsePK PRIMARY KEY , ResponseVal VARBINARY(5000) ) GOIf I want to get a value from this table that I can add to a URL in a browser, which of these code items produces a result I can use? See possible answers