SQLRally Call for Speakers Closes December 15, 2010
The call for speakers is open through December 15, 2010, and I hope many of you will take the chance...
2010-12-09
1,187 reads
The call for speakers is open through December 15, 2010, and I hope many of you will take the chance...
2010-12-09
1,187 reads
“Next 24 Hours of PASS on March 15-16 2011, celebrating Women’s History Month with 24 female speakers!”
Thus goes the announcement on...
2010-12-08
1,206 reads
I know, We cant cover life span of query in short. here is my another try to list some high level information...
2010-12-08
3,073 reads
After seeing several cases in the past couple of months where I felt the basics of troubleshooting were violated, I...
2010-12-07
2,805 reads
Signal Waits vs. Resource Waits
During my presentation at SQLSaturday#59, I spoke about the categories of wait types, such as...
2010-12-06
3,713 reads
Last week, I talked about one of the worst type of management scenarios to work under – the micromanager. Now, let’s...
2010-12-03
2,401 reads
Today’s script took a long time to write. The concepts are fairly simple and the resulting script is quite trivial...
2010-12-03
3,056 reads
A big part of my DBA career has centered around identifying and sharing SQL Server DBA best practices. There are...
2010-12-02
1,630 reads
The other day I was asked to provide the port number that a SQL Server instance was listening on. As...
2010-12-01
1,744 reads
Windows PowerShell has the concept of execution policy that determines in which cases script and configuration files are able to...
2010-11-30
1,310 reads
By Zikato
I recently encountered an issue where an index rebuild set to wait_at_low_priority ended up...
In the data-driven landscape of 2024, advanced SQL isn't just a nice-to-have, it's a...
A couple of weeks ago, a developer came to me and wanted to know...
Comments posted to this topic are about the item Working with SQL Server in...
Comments posted to this topic are about the item Five Years and Counting
Comments posted to this topic are about the item A Lack of Memory Grant...
SQL Server has added an Intelligent Query Processing feature called Memory Grant Feedback. In SQL Server 2022, this can be persisted across queries to improve the performance of future executions. In SQL Server 2022, when is memory grant feedback not persisted if the plan is evicted from cache? (choose 2)
See possible answers