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...
2015-01-03
597 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 can find and follow...
2015-01-03
6 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
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Forums
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
The String Distance I
Comments posted to this topic are about the item The String Distance I
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers