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,713 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,633 reads

Blogs

Streamline Dependency Management in Databases

By

In the intricate world of business, where precision and efficiency are paramount, managing database...

A New Word: Immerensis

By

immerensis – n.  the maddening inability to understand the reasons why someone loves you...

Deploy a Dockerized Python TODO App to Azure Container Apps Using Pulumi and Azure Key Vault

By

In this post, I will guide you on how to deploy a dockerized simple...

Read the latest Blogs

Forums

SQL Server is terminating in response to a 'stop' request from Service error

By naga.rohitkumar

Dear All, In one of the server its repeatedly restarting sqlserver services and not...

Understanding CROSS APPLY and OUTER APPLY in SQL Server

By Noman072

Comments posted to this topic are about the item Understanding CROSS APPLY and OUTER...

Database Files on Shares I

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Database Files on Shares I

Visit the forum

Question of the Day

Database Files on Shares I

I want to store database files on a file share for a SQL Server 2017 instance. Can I use \\fileserver\D$ as a location?

See possible answers