When I get stumped I ….
I work with a reasonably large team of DBAs. There are 9 of us and we support not only 70+...
2012-10-02
1,199 reads
Kenneth Fisher
DBMail on a cluster
I’ve always found clusters a pain in the neck. For my latest pain I just spent the last 2 days...
2012-09-26
628 reads
Using a TVP instead of Dynamic SQL to pass a list into a SP
A couple of days ago I read Steve Jones’ blog on creating a user defined table type. This reminded me...
2012-09-25
1,178 reads
Funny results from OPTIMIZE FOR AD HOC WORKLOADS
I recently turned on OPTIMIZE FOR AD HOC WORKLOADS for the first time on one of my servers. When I...
2012-09-18
1,360 reads
2012-09-13
2,862 reads
EXECUTE AS USER = ‘Somebody else’
As a database administrator I get lots of security requests. “Please grant me read authority on this table, write on that table,...
2012-09-10
730 reads
2012-09-07
2,787 reads
sp_helptext
My manager has been quietly laughing under his breath at me for years. Usually because I much prefer queries and...
2012-09-02
4,113 reads
At Startup SSMS setting
I came across this handy dandy little setting earlier this year. It was well hidden from me, by which I...
2012-08-27
652 reads
keyword DEFAULT
In 12 years of working with SQL it was only last year that I came across the keyword DEFAULT and...
2012-08-20
1,341 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
fast farward curson vs while loop on @table
hi, need to known weather fast farwand cursor is faster than a while loop...
Economics of AI: What is the Real Cost to Profit?
Comments posted to this topic are about the item Economics of AI: What is...
Poor Name Choice
Comments posted to this topic are about the item Poor Name Choice
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