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
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
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,845 reads
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,561 reads
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,954 reads
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
I’ve always found clusters a pain in the neck. For my latest pain I just spent the last 2 days...
2012-09-26
627 reads
A couple of days ago I read Steve Jones’ blog on creating a user defined table type. This reminded me...
2012-09-25
1,176 reads
I recently turned on OPTIMIZE FOR AD HOC WORKLOADS for the first time on one of my servers. When I...
2012-09-18
1,354 reads
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
728 reads
My manager has been quietly laughing under his breath at me for years. Usually because I much prefer queries and...
2012-09-02
4,110 reads
By DataOnWheels
What a year … At the end of May 2024, I went on full...
By Steve Jones
I wrote an editorial on the view of GenAI tech from execs and someone...
By Rohit Garg
Top 10 Features of SQL Server 2025 #SQLServer2025 #MicrosoftSQL #DatabaseUpdates #SQLAI #SQLFeatures #SQLServerCopilot #VectorSearch...
Hi, We are getting issue of Insert bulk failed due to schema change of...
Hi I have sql2022 in H/A with a primary and a secondary server. My...
I want to calculate the end of the previous month as a date that I can use in running a report. What is the best way to do this in SQL Server 2022, assuming I have a date stored in @d?
See possible answers