I am often invited to attend various interviews and once in a while, I see practical questions discussed in the interview. Here is one of the important interview question which is related to TempDB. 345 more words
Tags » T-SQL
It is quite common that when a new feature gets introduced, there is a lot of talk about them. Sometimes even the old capabilities are lesser known because they can be used interchangeably in conversations. 644 more words
Below one is the simple script to convert the sql_handle to text.
select top 1 tx.text, * from sys.dm_exec_query_stats as st cross apply sys.dm_exec_sql_text ( st.sql_handle) as tx… 26 more words
: This is an 87th episode of Notes from the Field series. Every week, I personally wait for the notes from the fields from Mike because it contains lessons of life which directly impacts DBA and Developer’s life positively. 723 more words
Every now and then I sit next to DBA to learn some of their tricks. One of this recent learning is what I plan to share here. 509 more words