Kanishka Basak


SQLServerCentral Article

Dynamic SQL Going Haywire

Those who work on various databases, or even those who do not, must have come across the term, Dynamic SQL. Dynamic SQL is basically a programming technique that enables you to build SQL statements dynamically at run time. It allows you to create more general purpose flexible SQL statement because the full text of the […]

4.8 (5)

2020-05-07

3,649 reads

SQLServerCentral Article

SQL Server performance issue after an upgrade

Recently, I came across a problem where the client reported severe performance degradation of their OLAP system. Most of the reports that were running were either timing out or were returning data after a long time. The problem started right after the client had undergone an upgrade, that included the following, Software change, that includes […]

4.82 (11)

2019-12-16

5,869 reads

Blogs

STRING_SPLIT Basics–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

My new Online Training: SQL Server Query Tuning Fundamentals – German Edition

By

As we all know there is already a lot of information available about SQL...

My new Online Training: SQL Server Query Tuning Fundamentals – German Edition

By

As we all know there is already a lot of information available about SQL...

Read the latest Blogs

Forums

Migrate the SSIS Catalog in Just a Few Clicks

By Kunal Rathi

Comments posted to this topic are about the item Migrate the SSIS Catalog in...

Using HttpClient in SSIS Script Component with visual studio 2015 framework4.8

By wiam.elab

Hi, I'm using HttpClient in an SSIS script component to retrieve data from a...

TSQL: Create dynamic partition DataRange

By Lidou123

Hello All I am facing difficulties to write a query to create partition. In...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers