—– ************ Find most expensive tables Starts ****** ————– Select Object_Name(ix.[object_id]) as objectName , Sum(ddius.user_seeks) As ‘table_seeks’ , Sum(ddius.user_scans)
Author: Dhruv Sheth
Hello friends, My self Dhruv Sheth, I have more than 10 years of Industrial experience as a Software Developer. In my career I got chance to work with asp.net, c#,Web API, JavaScript, JQuery, WPF, WCF , Windows Application, PostScript, vb.net, GhostScript etc. So I have decided to share my knowledge with everyone and finally I have come up with TechnoThirsty.
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
002. Find Blocking queries in Sql Server
Find Blocking queries in Sql Server Hello folks, today I will explain regarding most common problem of blocking in Sql
Remove blank lines in Sql Server Script
Remove blank lines in Sql Server Script Problem: Let’s say we have a script in which there are blank lines
Difference between Nullable<> and ?
Difference between Nullable<> and ? Hello friends, till now I have explained regarding different differences between. So I recommend you
Difference between String and string in C#
Difference between String and string string is an alias in C# for System.String. So technically, there is no difference. It’s
Difference Between WCF and WebAPI
Hello folks, hope you all are doing well. Today I want to explain regarding difference between WCF and Web API
Find Postback control of Page in asp.net
Find Postback control of Page in asp.net Problem: Let’s say your page has been posted back and you want to find
What is cursor in SQL Server?
What is cursor in SQL Server? A cursor is a set of rows together with a pointer that identifies a
What is OPENXML in SQL Server?
What is OPENXML in SQL Server? OPENXML can parse the xml data in SQL server very efficiently in SQL Server.
Difference Between Implict Transaction And Explict Transaction in sql
Implicit Transaction is the auto commit. There is no beginning or ending of the transaction. Explicit Transaction has the beginning,
Limitation of ISDATE() Function in Sql Server
Limitation of ISDATE() Function in Sql Server Hey folks till now we have discussed Performance improvement of cursor SQL Server, User defined