SQL RAP
Technorati Tags: SQL Nexus,SQLDiag,PSSDiag,PAL,SQL RAP,SQL Server 2012,SQL Server 2005,SQL Performance
About one year ago I had a Microsoft Premier Field Engineer...
2013-03-12
7,886 reads
Blog Posts
SQL Saturday 194
On the weekend of the 9th March 2013, the second SQL Saturday in the UK occurred. A massive thank you...
2013-03-12
670 reads
SQL Server : Index Part 3 :Explaining the Clustered Table Structure
In SQL server, there are two types of table based on the storage.A table with clustered index is called Clustered...
2013-03-12
2,903 reads
Three cheers for SQL 2012 Analysis Services
I had some sales reports that were running poorly on SQL 2005 Analysis Services. The information on the reports was...
2013-03-12
690 reads
T-SQL Tuesday #040: File and Filegroup Wisdom
Backstory Each month the SQL community comes together for an important party. This is the blog party that was the brain child of Adam Machanic (Twitter) known as T-SQL Tuesday....
2013-03-12
13 reads
T-SQL Tuesday #040: File and Filegroup Wisdom
Backstory
Each month the SQL community comes together for an important party. This is the blog party that was the brain...
2013-03-12
1,081 reads
A Month of PowerShell – Day 27 (Scripting SQL Objects)
Welcome to Day 27 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-03-11 (first published: 2013-02-27)
3,484 reads
Building My Next Workstation–Part 5
With the motherboard and CPU installed I was ready to add the final and perhaps easiest parts to the build....
2013-03-11
664 reads
Colorado speaking tour
I’m happy to announce that I’ll be doing a tour of the 4 SQL Server user groups in central Colorado...
2013-03-11
690 reads
DMV-2 : Explore the secrets of session…… sys.dm_exec_sessions
sys.dm_exec_sessions DMV (Dynamic Management View), delineated by BOL as follows: http://msdn.microsoft.com/en-us/library/ms176013.aspx
Returns one row per authenticated session on SQL Server. sys.dm_exec_sessions is a server-scope view...
2013-03-11
3,800 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