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,675 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

6,457 reads

Blogs

Tales From The Field Weekly Wrap Up for the Week of 01-31-2023

By

 Hello Dear Reader!  After a weekend with a lot of activities, it was a...

Creating a Flyway Desktop Shadow Database in PostgreSQL

By

In order to generate migrations, we need to configure Flyway to use a shadow...

Daily Coping 6 Feb 2023

By

Today’s coping tip is to get back in contact with an old friend. This...

Read the latest Blogs

Forums

To Drop or Not to Drop (the temp table question)

By Brandie Tarvin

So here's a thing that I've been told several times over the past few...

bcp is giving SQL State = 1000 Native error =0 SQL Server

By surafeb7

Hi experts, Seeking your help. I am using a bcp command in a tool...

Convert query output into email

By Bruin

How can I take the output from this query and turn that into an...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers