Las Vegas UG This week
What a fun week we have tuned up for the folks in Las Vegas. It is the first full week...
2015-01-05
537 reads
SQL RNNR
Las Vegas UG This week
What a fun week we have tuned up for the folks in Las Vegas. It is the first full week of January and there is this huge convention going...
2015-01-05
Effects of Max Mem on Plan Cache
Reading a Microsoft Article (which can be found here) while making sure I understood what can cause a query plan to...
2015-01-07 (first published: 2015-01-05)
7,897 reads
Effects of Max Mem on Plan Cache
Some effects on plan cache and max memory settings
Related Posts:
The Curiously Large CASE Statement March 20, 2019
Maintenance Plan Owner - Back to Basics December 13, 2018
ArithAbort and...
2015-01-05
Happy Holidays
Quick and simple for today. Happy Holidays to you!
Related Posts:
Always Waiting, Waiting WaitingFinally, it has happened…On the Seventh Day…September 2014...
2014-12-26
637 reads
Happy Holidays
Quick and simple for today. Happy Holidays to you!
Related Posts:
Easy Permissions Audit January 21, 2019
T-SQL Tuesday Participation Over the Years December 19, 2018
Quick Permissions Audit January...
2014-12-26
T-SQL Tuesday 61: A Season of Giving
Tis the season for TSQL Tuesday. Not only is it that season again, but it is also the Holiday season.
During...
2014-12-09
748 reads
T-SQL Tuesday 61: A Season of Giving
Tis the season for TSQL Tuesday. Not only is it that season again, but it is also the Holiday season. During this season, many people start to think about...
2014-12-09
SQLSat in DC – it’s a wrap
This past weekend I had the opportunity to go visit Washington DC. It was just the second time I got to...
2014-12-08
542 reads
SQLSat in DC – it’s a wrap
This past weekend I had the opportunity to go visit Washington DC. It was just the second time I got to stay in the Nation’s capitol for more than just...
2014-12-08
Blogs
The Book of Redgate: What Our Customers Say
By Steve Jones
This is from 2010, but I loved that people felt this way about Redgate...
Export a Power BI Report that cannot be Downloaded
Yes, you’re reading that right, we’re going to download a report that cannot be...
Query Intelligence in SQL Server 2025: What Developers Need to Know
By Chris Yates
When Microsoft announced SQL Server 2025, I was curious about what would truly change...
Forums
Poor Name Choice
Comments posted to this topic are about the item Poor Name Choice
Getting the Indexed Columns
Comments posted to this topic are about the item Getting the Indexed Columns
T-SQL in SQL Server 2025: Substring Changes
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Question of the Day
Getting the Indexed Columns
I run this code on SQL Server 2022 to get a list of all the indexes and their key columns. What is returned?
SELECT
INDEX_COL (N'AdventureWorks2017.Sales.SalesOrderDetail') See possible answers