fn_OBJECT_TYPE
I recently started using OBJECT_NAME, OBJECT_SCHEMA_NAME and OBJECT_ID functions; unfortunately I really could have used OBJECT_TYPE but it doesn’t exist...
2012-10-19
1,234 reads
SQLStudies
A review of SQL Interoperability / Joes 2 Pros Volume 5 by Rick A Morelan
I recently passed my MCTS 2008 Development (70-433). Yay me! That made my 3rd 2008 certification. This one was probably the...
2012-10-15
1,839 reads
Multiple CTEs
Multiple CTEs
It’s somewhat obscure in BOL and I wasn’t able to find any examples but it turns out you can...
2012-10-11 (first published: 2012-10-09)
4,560 reads
Active flag on the TCP/IP Properties page of SQL Server Configuration Manager
I’ve been unable to connect to a server via one of its aliases for about a week. When I looked...
2012-10-05
1,929 reads
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,197 reads
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
625 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,174 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,352 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
727 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,108 reads
Blogs
Ways to land data into Fabric OneLake
By James Serra
Microsoft Fabric is rapidly gaining popularity as a unified data platform, leveraging OneLake as...
A Very Cool Benefit in SSMS 21
By Steve Jones
I saw a post from Erin that Preview 2 is available. I’d gotten a...
AI Helping with an API
By Steve Jones
Can an AI help me with some database API work? Let’s see. This is...
Forums
Topic marked as spam - by mistake?
I received the following notification a few hours ago. It seems legit but has...
Getting blockage on Update Statement
Hi, Need your help. I've a SP that is using Update statement on a...
Query is filling Tempdb
I have query which is filling TEMPDB I need suggestion how to modify this...
Question of the Day
The Hash Join III
In a hash join, if all the build input does not fit in memory, what type of hash join is this?
See possible answers