Tag - SQL Server

Coding Skills That Every Developer Should Have

Coding skills are essential for any developer. They allow you to create programs and websites that interact with computers. There are a variety of coding languages and tools that you can use to develop your skills. You can learn the basics of coding by working with a free coding platform or learning code through...

SQL Server vs PostgreSQL

With so many databases to choose from, users frequently debate PostgreSQL vs SQL Server to determine which is the better option for their use case. Organizations that use PostgreSQL for their operations may want to consider switching to a database such as Microsoft SQL Server, which primarily caters to various data warehousing solutions, ecommerce,...

We’re Hiring – Senior .NET Developer

JOB DESCRIPTION: Responsible for development, support, maintenance and implementation of a complex project module. You should have good experience in application of standard software development principles. Be able to work as an independent team member, capable of applying judgment to plan and execute your tasks. Be able to respond to technical queries / requests from...

Delete Duplicate Rows in SQL Server

I was working on a legacy Database with tables that has a lot of records, more than like 1M records. I noticed some duplicate rows there and I had to do something about this. After some research I came up with the following code that would delete duplicated rows in a table. DELETE FROM Table1 WHERE ID...

Some tips for improving the performance of SQL Server queries

When I observe performance optimizations for online apps, I often see them done at the application layer or by validating the index existence on a database table field column (s). The optimization of SQL queries receives very little attention. Even experienced architects and developers have a tendency to overlook the need of understanding how...

How to execute a T-SQL command to every table in SQL Server database

sp_MSforeachtable is a stored procedure that is mostly used to apply a T-SQL command to every table, iteratively, that exists in the current database. Examples on how to use it: 1-Perform an unconditional reindex over all tables in the database: EXEC sp_MSforeachtable 'DBCC DBREINDEX(''?'')' 2-Truncate all tables in the database: EXEC sp_MSforeachtable 'TRUNCATE TABLE ?' 3-Get the information about the...

How to format DateTime in SQL Server

When expression is a date or time data type, style can be one of the values shown in the below Text: 101 >>>>>>>> mm/dd/yy102 >>>>>>>> yy.mm.dd103 >>>>>>>> dd/mm/yy104 >>>>>>>> dd.mm.yy111 >>>>>>>> yy/mm/dd114 >>>>>>>> hh:mi:ss:mmm(24h) we will assume that we have a table contain a DateTime data type field, the result of the below query will be...

How to use SQL Membership Provider in ASP.NET

The ASP.NET membership feature provides secure credential storage for application users. We will use the following: Web Page Named Login.aspx and another Web Page named CreateUser.aspxLogin Control.Create User Wizard Control. Steps: 1- Configure Forms Authentication in Web.config File To configure forms authentication, set the <authentication> element's mode attribute to "Forms" and then configure your application's Web.config file as shown...