Tags » SQL

Interview Question of the Week #047 - Logic To Find Weekdays Between Two Dates

I often enjoy seeing interview questions where the contestant has to write SQL Scripts. Here is another such example.

Question: How to find weekdays between two dates? 76 more words

SQL Authority

Delete Duplicate row from table without any key

How to Delete Duplicate row from table without any key in SQL?

Hello friends, how are you all? In this article I am going to explain you how to delete duplicate row from table without any key in SQL? 310 more words

Interview Questions

SQL SERVER 2016 - Comparing Execution Plans

New tools bring new capabilities and sometimes these are ingrained deep into the product that we can easily miss them out. And SQL Server 2016 is no different. 387 more words

SQL Authority


echo -e "set head off pages 0 feed off\nselect 1 from dual\nexit;" | sqlplus -s / as sysdba

99.99% available ASP.NET and SQL Server SaaS Production Architecture

Production Architecture for a SaaS web application built using ASP.NET and SQL Server that guarantees 99.99% availability and super performance


You have a hot ASP.NET+SQL Server product, growing at thousand users per day and you have hit the limit of your own garage hosting capability. 4,792 more words

Web Development

Passing Date Parameter To SubReport SSRS SharePoint Integrated Mode

When SSRS is rendered in SharePoint Integrated Mode if there is a drop down parameter of type DateTime and it is passed to a parameter of DateTime in the SubReport, the subreport fails to load when rendering in browser though it loads correctly from reportbuilder. 165 more words