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,957 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,198 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,355 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,111 reads
By Steve Jones
lackout – n. the sudden awareness that you’re finally over someone, noticing that the...
By Ed Elliott
All Spark Connect Posts I have just finished an update for the spark connect dotnet...
By Kamil
The Challenge: DevOps for Microsoft Fabric In the world of Microsoft Fabric, DevOps...
In Azure SQL DB, i want to merge records from the staging table to...
Full error message: SSRS error: The Value for the image 'Image1' has a constant...
We are in the process of upgrading to SQL Server 2022 and would like...
I have a table, called dbo.logger, in SQL Server 2022. I decide to add two new columns to this table with this code.
ALTER TABLE dbo.logger ADD CreateDate DATETIME CONSTRAINT dfGetDate DEFAULT GETDATE() GO ALTER TABLE dbo.logger ADD ModifyDate DATETIME DEFAULT dfGetDate GOWhat happens when I run these two batches? See possible answers