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)

You rated this post out of 5. Change rating

2020-05-07

3,684 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)

You rated this post out of 5. Change rating

2019-12-16

7,309 reads

Blogs

Using Git Prune–#SQLNewBlogger

By

As I’ve been working with SQL Saturday and managing changes to events, I’ve accumulated...

Microsoft Purview new data governance features

By

Starting last week is a rollout of the public preview of a new and...

SQL Database Administration: Not For Everyone (But Maybe It’s for You)

By

Let's get one thing straight: database administration isn't the most glamorous tech job out...

Read the latest Blogs

Forums

Do I need a recursive query for this? bill of materials (sort of)

By pietlinden

I am working on a data warehouse project for a bakery. For the most...

Do I need a recursive query for this? bill of materials (sort of)

By pietlinden

I am working on a data warehouse project for a bakery. For the most...

Create Copy of DB in same server.

By terry999

Hi I want to create a copy of a DB on the same server....

Visit the forum

Question of the Day

Restoring the Resource Database

How can I restore a version of the Resource Database in SQL Server 2022?

See possible answers