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
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,217 reads
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)
4,031 reads
Steve Jones talks about one of the highlights of his year: working the door at the PASS Community Summit.
2010-03-09
90 reads
There are some good reasons to think about attending the 2010 PASS Community Summit.
2010-07-26 (first published: 2010-02-25)
3,764 reads
2009-11-06
21 reads
2009-07-28
514 reads
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,982 reads
The 2009 PASS Summit is Nov 2-5, 2009 in Seattle. Come and grow your network, while learning about SQL Server.
2009-09-17 (first published: 2009-05-12)
710 reads
There are some good reasons to think about attending the 2009 PASS Community Summit.
2009-10-22 (first published: 2009-03-24)
4,533 reads
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
i see this in the definition of a linked server on our wh sql...
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
Comments posted to this topic are about the item Stairway to Snowflake Level 5...
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers