2019-11-07
205 reads
PASS Summit
Predictions for PASS
Steve is missing the PASS opening keynote, but he has a few predictions for the day.
2019-11-06
143 reads
"But It Worked in Development!" - 3 Hard SQL Server Performance Problems
You’ve been performance tuning queries and indexes for a few years, but lately, you’ve been running into problems you can’t explain. Could it be RESOURCE_SEMAPHORE, THREADPOOL, or lock escalation? These problems only pop up under heavy load or concurrency, so they’re very hard to detect in a development environment.
2018-02-23
7,201 reads
Five Things I Learned at the PASS Summit
Steve Jones has attended the PASS Summit almost every year, and in that time he's learned a few things. He shares a few today that might convince you or your boss that it's worth funding the trip this year.
2010-09-21 (first published: 2010-05-17)
5,201 reads
The 2010 SQLServerCentral Opening Night Party
SQLServerCentral is hosting an opening night party at the 2010 PASS Summit. Read more about this and learn how to get a ticket.
2010-10-26 (first published: 2010-05-13)
3,856 reads
Working the Door
Steve Jones talks about one of the highlights of his year: working the door at the PASS Community Summit.
2010-03-09
82 reads
Top Ten Reasons to Attend the 2010 PASS Community Summit
There are some good reasons to think about attending the 2010 PASS Community Summit.
2010-07-23 (first published: 2010-02-25)
3,718 reads
2009-11-06
14 reads
2009-07-28
514 reads
The ROI for PASS 2009
A few of the reasons why you might want to attend the PASS Summit this November.
2009-09-29 (first published: 2009-05-29)
1,965 reads
Blogs
ACM Lecture at SELU
By Will Assaf
Had the pleasure of presenting to Dr. Ghassan Alkadi and a full house at...
T-SQL Copy & Paste Pattern – Increasing a performance problem
By Cludio-Silva
Disclaimer: The title is my assumption because I saw it in the past happening...
Removing ad hoc plans from Query Store
By DesertDBA
This is not a post about the “optimize for ad hoc workloads” setting on...
Forums
Optimize Cursor
I inherited this script that has a cursor and I know this query can...
Unable to add secondary node existing node due to DCOM is unavaialble
Dear Team, This is Naveen, Hope all are doing well. I need emergency help...
To show the count per month from the date provided
I have two tables namely Vendors & Visits. Create Table Vendor (VendorId BIGINT IDENTITY(1,1)...
Ask SSC