Script to find all the running queries/jobs on the Database Server
Below is the query to find out all the Queries and their details like SSID etc. running on the SQL...
2015-01-04
1,588 reads
Blog Posts
A Very Happy New 2015
Wishing you a very happy new year to you. May this year bring success & happiness in your life. Reference : Rohit Garg (http://mssqlfun.com/) You can find and follow...
2015-01-03
6 reads
A Very Happy New 2015
Wishing you a very happy new year to you.
May this year bring success & happiness in your life.
Reference : Rohit Garg (http://mssqlfun.com/)
You...
2015-01-03
597 reads
Clustered Columnstore Indexes – part 46 (“DateTime compression and performance”)
Continuation from the previous 45 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
At the last SQLPort event in December 2014, I have listened to...
2015-01-03
725 reads
How to pass Microsoft Certification Exams
Many times I was asked how to pass Microsoft certifications and how difficult it is. In my point of view,...
2015-01-03
1,007 reads
[SQL Snacks Video] Performance Tuning 102 – Files, FileGroups, and TempDB
Finally the arrival of Part 2 of my SQL Snack Pack on Performance Tuning! The series is dedicated to help beginners...
2015-01-02 (first published: 2014-12-30)
7,445 reads
Contained Database–A new feature in SQL SERVER 2012 TIP #81
While working on a project sometimes it happened that we need to shift the database from one server to another...
2015-01-02
488 reads
E-Book Offer – Coming to an End
Back in December just before Christmas I wrote a post about a deal that Packt publishing has on its ebook...
2015-01-02
415 reads
Friday Followup For January 2, 2015
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2015-01-02
368 reads
My 2015 Plan
I started this on Jan 1, but with family commitments, I ended up delaying it until today. I wrote about...
2015-01-02
880 reads
Blogs
Flyway Tips: AI Helps with Commit Messages
By Steve Jones
At Redgate, we’re experimenting with how AI can help developers and DBAs become better...
Startup scripts in SQL Server containers
I was messing around performing investigative work on a pod running SQL Server 2025...
Using SQL Compare with Redgate Data Modeler
By Steve Jones
Redgate recently released SQL Compare v16, which included a new feature to work with...
Forums
What is Page Density
Comments posted to this topic are about the item What is Page Density
T-SQL in SQL Server 2025: Fuzzy String Search II
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Azure-SSIS, Self-Hosted Integration Runtime, & Data Gateway?
Looking to confirm my understanding of these three products and how they can be...
Question of the Day
What is Page Density
In SQL Server, there is a concept of page density. This is determined by how much data is stored on each page. What is a page density of 90%?
See possible answers