Calculating the length of a string (Len vs DataLength)
This one is basic but still something that can catch you unawares if you aren’t careful. Most DBAs and developers...
2013-04-15
1,502 reads
Blog Posts
Customizing SSMS–Results
This is a short series on some customizations in SSMS to make it visually more appealing.
As a presenter, I’ve learned...
2013-04-15
1,389 reads
Determining when statistics were last updated in SQL Server?
I received an email from friend today asking how he can see when statistics were last updated in SQL Server....
2013-04-15
3,512 reads
DMV-7 : Find Queries waiting for memory ?……..sys.dm_exec_query_memory_grants
sys.dm_exec_query_memory_grants DMV (Dynamic Management View), described by BOL as follows : http://msdn.microsoft.com/en-IN/library/ms365393.aspx
Returns information about the queries that have acquired a memory...
2013-04-15
1,066 reads
Event Notifications 101 – Intro to Event Notifications
Once upon a time, in a blog post far, far away, I started talking about auditing in SQL Server. And...
2013-04-15
653 reads
Finding SQL Server Installs with Powershell, Again
But the SQL Listener isn’t started!
Yep, I heard you loud and clear. There is more than one way to find...
2013-04-15
946 reads
Free SQL Server 2012 Installation Guide
Everyone’s favorite four letter word is back, FREE! Yes, it is time I gave back to the community since I’ve...
2013-04-15
362 reads
Last Weeks Top “Reading” Links #28
For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of...
2013-04-15
489 reads
Microsoft GeoFlow new Excel 2013 add-in
Hi
Microsoft released new add-in (Preview) for Excel 2013 and we decided to do a video so here it is...
2013-04-15
747 reads
New SQL Server Cumulative Updates
Microsoft has released three new Cumulative Updates for SQL Server today, two for SQL Server 2008 R2 and one for...
2013-04-15
729 reads
Blogs
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
Forums
Training the next generation
Comments posted to this topic are about the item Training the next generation
Reusing Customer Specific Order Filtering Logic with CROSS APPLY and an Inline TVF (Part 4)
Comments posted to this topic are about the item Reusing Customer Specific Order Filtering...
PostgreSQL psql Meta Commands: Databases
Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Databases
Question of the Day
PostgreSQL psql Meta Commands: Databases
Which of the following meta commands (sometimes called backslash or slash commands) within psql will provide you with information about the databases on the cluster?
See possible answers