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
They run, they return data. So what? Some SQL queries just waste your time...
By Steve Jones
I read Brent’s first look at SSMS and Copilot in there. He didn’t have...
By Steve Jones
falesia– n. the disquieting awareness that someone’s importance to you and your importance to...
We have very large tables in our database, some even more 1 B records,...
I have a few tools at my disposal but none of them seems like...
What parameters are required for the dab add command in the Data API Builder?
See possible answers