Tag - SQL

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...

Data Engineer vs. Data Scientist

Data science jobs have been in great demand in recent years, with the Bureau of Labor Statistics expecting a 22% increase in job growth from 2020 to 2030—much faster than the typical growth of other occupations. This need shows no signs of decreasing as organizations continue to focus on generating, collecting, and analyzing big...

Database Sharding

Let's imagine an app is well-known and receives a lot of traffic from all around the world. As a result, your database will be bombarded with thousands of new records every day. Now the subject of how to manage user data and for users emerges. In this case, database sharding is the appropriate course...

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...

Differences between SQL and NoSQL

1.Language SQL databases: SQL databases use structured query language (SQL) for defining and manipulating data. This is extremely powerful: SQL is one of the most many-sided and widely-used options available, making it a safe choice and especially great for complex queries. But it can be restrictive. SQL requires that you use predefined schemas to determine the structure of...

How to apply or execute a T-SQL command to every database in your server

We talked before on How to  apply or execute a T-SQL command to every tables in your database. Now we are going to have a quick look on the same but for databases not tables … There is a handy undocumented stored procedure that allows you to do this without needing to set up a cursor...

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...