Finding Checked Out Files in TFS
There may be an easier way, but this was a quick way to find ALL the checked out files in...
2014-06-24
1,398 reads
SQLAndy
No Files For You
No Files For You is another Question Of The Day. I ended up making this one just a little more...
2014-06-24
476 reads
SSC Editorial: Bad Meetings or Meeting Badly
Bad Meetings or Meeting Badly is the editorial of the day today. Looking at it today, I wish I had...
2014-06-23
514 reads
Reading, Writing, and Riskmetic-Question of the Day
Reading, Writing, and Riskmetic is another Question of the Day, this one about how to allow developers to understand performance...
2014-06-23
538 reads
Poecilonym Madness-Question of the Day
Poecilonym Madness! is my latest question that tests your knowledge of creating/dropping tables, views, and synonyms. Here’s the fun part...
2014-06-20
603 reads
Building The SQLSaturday Orlando Marketing Plan-Part 20
Next week will begin our weekly planning call, so ahead of that (and perhaps a bit later than I should...
2014-06-19
563 reads
Building The SQLSaturday Orlando Marketing Plan-Part 19
Below is the chart Kendal Van Dyke maintains for us in Orlando showing year over year registration counts. Don’t I...
2014-06-19
499 reads
Building The SQLSaturday Orlando Marketing Plan-Part 18
I’m on vacation this week, but enjoying some quiet time during the day to think a little, going back through...
2014-06-17
746 reads
SSC Editorial: Kitchen Duty
I try to find good stories for editorials at SQLServerCentral and the one this week about Kitchen Duty seems to...
2014-06-17
583 reads
Notes From SQLSaturday South Florida
Notes from the trip:
Four hour drive between traffic and rain, about an hour longer than I would have liked. The...
2014-06-16
443 reads
Blogs
T-SQL Tuesday #192 Invitation: SQL Server 2025 Excitement
By Steve Jones
It’s that time of the month again, and once again, I’m late and I’m...
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...
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