Home »
Archive by categoryTutorials (Page 3)
Problem: Sometime DBA’s want to get script of indexes from their current database. How anyone can get “Drop and Create script” directly from any database is the another problem!!! Solution: We have different two below scripts from which we could get “Drop and Create script”, both scripts are working identically...
Continue reading
April 4, 2018 Dhruv Sheth
Performance Improvement in SQL, SQL Downloads, SQL SERVER, Sql Server Scripts, Tutorials
No Comment
Get YouTube video thumbnail – YouTube API Each YouTube video has 4 generated images. They are predictably formatted as follows: https://img.youtube.com/vi/<insert-youtube-video-id-here>/0.jpg https://img.youtube.com/vi/<insert-youtube-video-id-here>/1.jpg https://img.youtube.com/vi/<insert-youtube-video-id-here>/2.jpg https://img.youtube.com/vi/<insert-youtube-video-id-here>/3.jpg The first one in the list is a full size image and others are thumbnail images. The default thumbnail image (ie. one of 1.jpg,...
Continue reading
April 3, 2018 Dhruv Sheth
Tutorials, Youtube API
No Comment
Problem: An important step in optimizing a system is to take a holistic approach and look at stored procedures that are called very often. These procedures can often be the backbone of a system. Sometimes optimizing these procedures can have a dramatic effect on relieving the physical bottlenecks...
Continue reading
April 2, 2018 Dhruv Sheth
Interview Q&A, Performance Improvement in SQL, SQL Downloads, SQL Interview Questions, SQL SERVER, Sql Server Scripts, Tutorials
1 Comment
How to enumerate Enum C# Problem: We have enum declared in our class and we want to enumerate enum. How could we enumerate enum let’s together try to understand. Sometimes we get error message like “Enum is a type but used as a variable”. So how can we overcome...
Continue reading
April 1, 2018 Dhruv Sheth
C#, C# Interview Questions, Interview Q&A, Tutorials
No Comment
Remove Cross duplicate rows in SQL Hello friends, I got one question from my friend who recently appeared for an interview, that how to remove cross duplicate rows in SQL.? So I was looking for a solution but after many failures I got correct solution. Let you...
Continue reading
January 18, 2018 Yesha Kansagra
Interview Q&A, SQL Interview Questions, SQL SERVER, Tutorials
No Comment
Analyse Missing Index Sql Server- Script 1 [crayon-5c15e4ce9e6b7719845835/] Analyse Missing Index Sql Server- Script 2 [crayon-5c15e4ce9e6be282671463/] I request you to run both scripts in your testing environment and verify and then run to Analyse Missing Index in Sql Server.
Continue reading
November 18, 2017 Dhruv Sheth
Performance Improvement in SQL, SQL Downloads, SQL SERVER, Sql Server Scripts, Tutorials
1 Comment
[crayon-5c15e4ce9ea6a184381119/]
Continue reading
November 16, 2017 Dhruv Sheth
Interview Q&A, Performance Improvement in SQL, SQL Downloads, SQL Interview Questions, SQL SERVER, Sql Server Scripts, Tutorials
[crayon-5c15e4ce9ec29558412822/]
Continue reading
November 15, 2017 Dhruv Sheth
Performance Improvement in SQL, SQL Downloads, SQL SERVER, Sql Server Scripts, Tutorials
[crayon-5c15e4ce9edee058935289/]
Continue reading
November 14, 2017 Dhruv Sheth
Interview Q&A, Performance Improvement in SQL, SQL Downloads, SQL Interview Questions, SQL SERVER, Sql Server Scripts, Tutorials
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
November 13, 2017 Sohil Raval
SQL Downloads, SQL Interview Questions, SQL SERVER, Sql Server Scripts
No Comment
