Blog

(Articles with tag:Database Administrator) - Remove Filter

How to Insert Carriage Return or Line Break Or Tab into a string in MS SQL Server

From some reason when I first ran MS SQL 2016 I realized when I run some code with Carriage Return Return and Line Break it stays in one line after coping that into a note pad or below the SQL code in Microsoft SQL Server Studio. So, what happened here? After digging deep into it I found out that this feature that worked as default from MS SQL 2014 and below is not working as a default feature anymore. You need to set it up in order to make that work.

3 Strong Reasons You Need a Software Application Rewrite

One key point is embracing the fact that the product you are selling your clients is not the travel tours. There are certainly other businesses that sell travel tours for students or otherwise. But what makes your clients come to you and not a competitor is the technological aspect of the business. Having a good online presence is important. User satisfaction is the main thing that separates a successful product from a non-successful one.

SQL Consulting

We are experts at SQL Server database administration, performance tuning and database optimization to maximize your company's productivity. In our team we have MS SQL MVP consultant and our highest experience person has 26 years of database solutions. We are located in central NJ and provide MS SQL consulting solutions all over the USA.

Processing hundreds of millions records got much easier

SQL 2012 or higher - Processing hundreds of millions records can be done in less than an hour. Processing hundreds of millions of records requires a different strategy and the implementation should be different compared to smaller tables with only several millions of records.