Using this query you can easy to track that, Which running SQL Query is taking extra time or load, check reads and writes. Output will be. Query
Using this query you can easy to get all primary keys of from all tables of current database. Output will be like this.
Using this query we can easy to check all relationships in current Database. We have 2 different queries you can find below. Example picture this there. 1st Query 2nd Query
Some time table identity value comes wrong sake of we delete manual entries, we added wrong data in edit mode or it takes next value of identity or some time automatically comes. So in this case many developer are delete data or re-design to table structure (schema). No need to do this you just clear … Read more
A very rare example of this. But I find out suppose you have a list of key values, or you want to search value corresponding of the key, you will pass key and get the value of that from JSON list. Using the below example you can easy to achieve this. I have this json … Read more
We will create a recursive query when getting data as per parent and its level. Mostly we use this query in MLM software (Multilevel marketing software). Using this you can easy to get who is my parent till the level we wanted to find. for more info follow this URL: https://stackoverflow.com/questions/16749095/sql-recursive-query-that-gets-all-ancestors-of-an-item Create new stored procedure … Read more
A sub-query is a query that can be nested inside the main query like Select, Update, Insert, or Delete statements. This can be used when the expression is allowed. Properties of sub query you can follow points sub query should be placed on the right-hand side of the comparison operator of the main query sub … Read more
SQL Profiler is a tool that allows the system administrator to monitor events in the SQL server. This is mainly used to capture and save data about each event of a file or a table for analysis. Using this we can easy to capture in realtime which queries are executing. We have no need to … Read more
solved: SQL server slow performance | just check where you need to create indexes , so that you can get data faster. Use below code run in your query window and check which table is take too time to load.