Home » Archive by categoryInterview Q&A (Page 3)

Select Primary Key value from Table dynamically-Sql Server

Select-Primary-Key-value-Table-dynamically-Sql-Server-technothirsty
Select Primary Key value from Table dynamically Hello friends, Today I am going to teach select primary key value from any table dynamically. At the time development we need primary key many times so no need to create another stored procedure.Below store procedure help to find out primary...
Continue reading

Should we Shrink database – Sql Server

Should we Shrink database – Sql Server Lets try to understand with an example. First we will create database and add some tables in that database with some sample data and then we will major fragmentation level as well size of database & log. After that we will...
Continue reading

Find Blocking queries in Sql Server

Find-blocking-queries-Sql-Server-technothirsty
Find Blocking queries in Sql Server Hello folks, today I will explain regarding most common problem of blocking in Sql Server. There are so many developers having same question “How can we find blocking queries in Sql Server”. Let’s try to take an example and understand how to...
Continue reading

Remove blank lines in Sql Server Script

Remove Unnessasary Blank lines
Remove blank lines in Sql Server Script Problem: Let’s say we have a script in which there are blank lines in between two lines and you want to remove these blank lines from that script. Have look into below image, As image we want to remove blank lines...
Continue reading

Difference between Nullable<> and ?

difference-between-Nullable-questionmark-technothirsty
Difference between Nullable<> and ? Hello friends, till now I have explained regarding different differences between. So I recommend you read all difference betweens. Today I am going to explain you regarding Difference between Nullable<> and ?. Every one is having question which should we use from Nullable<> and...
Continue reading

Difference between String and string in C#

difference-between-String-string-technothirsty
Difference between String and string string is an alias in C# for System.String. So technically, there is no difference. It’s like int vs. System.Int32. Find below code to prove above sentence. [crayon-5c15e9f340449055782783/]   As far as guidelines, I think it’s generally recommended to use string any time you’re...
Continue reading

Difference Between WCF and WebAPI

difference-between-WCF-WebAPI-technothirsty
Hello folks, hope you all are doing well. Today I want to explain regarding difference between WCF and Web API and which should you pick for your project with detailed explanation. I have already discussed regarding Difference between WCF and Web Service and Difference between SOAP and REST, You should look into...
Continue reading

Find Postback control of Page in asp.net

Find-Postback-control-in-asp.net-technothirsty
Find Postback control of Page in asp.net Problem: Let’s say your page has been posted back and you want to find from which control it has been initiated. Solution: We have to put some check at Page_Load even of the page and traverse for all controls and match request with...
Continue reading

What is cursor in SQL Server?

Cursor-SQL-Server-technothirsty
What is cursor in SQL Server? A cursor is a set of rows together with a pointer that identifies a current row. In other word, Cursor is a database object used by applications to manipulate data in a set on a row-by-row basis, its like record set in...
Continue reading




DISCLAIMER:
The content is copyrighted to technothirsty.com and may not be reproduced on other websites without permission from the owner.You may contact us using the information below.