Kanishka Basak

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,595 reads

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

4,528 reads

Blogs

VMworld 2020 – Top 10 Database Sessions (Part 2)

By

Whether you are a SQL Server Database Administrator, Infrastructure Architect, or any other member...

Daily Coping 25 Sep 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

VMworld 2020 – Top 10 Database Sessions (Part 1)

By

Whether you are a SQL Server Database Administrator, Infrastructure Architect, or any other member...

Read the latest Blogs

Forums

New Stuff Can Be Scary

By Grant Fritchey

Comments posted to this topic are about the item New Stuff Can Be Scary

Stored Procedure Performance Woes... How to get around CURSORS for html gen.

By scarr030

Hi everyone, Working with a stored procedure that is used in an application of...

Any guides for sizing Azure managed instances.

By Sliverlight

Hi All, Has anyone got any tips for sizing a move from VM running...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers