Dharmendra Keshari

Dharmendra is a SQL Server/Microsoft Data Platform professional with over eight years of experience. He enjoys helping others in the SQL Server community and does this by contributing on blogs, speaking at several SQL events. His passion and focus is to explore and share more and more on SQL Server.

SQL Database File Wise Disk Space Monitoring

by Dharmendra Keshari

SQL Geek

As a DBA, you get alerts many times regarding the database file space issue. To address the issue, you may...

2017-04-21

1,154 reads

Microsoft Data Platform – MVP 2017!!!

by Dharmendra Keshari

SQL Geek

I’m very pleased and delighted to share that I have been awarded Microsoft Most Valuable Professional (MVP) award 2017. This...

2017-04-14

430 reads

Read Statistics Histogram using DMV

by Dharmendra Keshari

SQL Geek

DMV: sys.dm_db_stats_histogram (object_id, stats_id)
For a long time, the DBCC SHOW_STATISTICS command was the only way to get information about statistics....

2017-02-22

914 reads

Out of memory error because of the very low virtual address space – Error 701 – Trace Flag 8075

by Dharmendra Keshari

SQL Geek

If you are dealing with a SQL Server which got a lot of memory, you may encounter the out of...

2017-02-20

1,271 reads

After migrating SQL Server from 2005 to higher version, the waits type PAGELATCH_UP increased

by Dharmendra Keshari

SQL Geek

Recently, I experienced an interesting issue where I found SQL Server wait type PageLatch_UP went up drastically after migration. Let’s...

2017-02-06

518 reads

SQL Server Service Information

by Dharmendra Keshari

SQL Geek

DMV: sys.dm_server_services
Microsoft SQL Server 2008 R2 SP1 and SQL Server 2012 has a new set of DMVs. One of them...

2017-01-11

355 reads

Disk Space Monitoring using SQL Server DMV

by Dharmendra Keshari

SQL Geek

DMV : sys.dm_os_volume_stats
Being a SQL Server database administrator, you may often receive alerts or asked by Senior DBAs to check, if...

2017-01-09

17,190 reads

New String Function – TRIM – in SQL Server vNext

by Dharmendra Keshari

SQL Geek

As SQL developer, you must have often come across a scenario where you need to remove the empty spaces at...

2017-01-06

2,061 reads

When was SQL Server installed?

by Dharmendra Keshari

SQL Geek

In this blog post. Let us learn about how to retrieve date and time when the SQL Server was installed. To retrieve...

2017-01-04

12,711 reads

Identifying Blocking Chain in SQL Server

by Dharmendra Keshari

SQL Geek

HAPPY NEW YEAR 2017!!
I hope you all had a good Christmas and New Year. I always try to review my...

2017-01-01

10,187 reads

Blogs

Secure Azure SQL Server Backups Using Managed Identities

I do believe most people know about the ability to backup your SQL server...

Using a Local Large Language Model (LLM): Interacting with Local LLMs Using PowerShell

By Anthony Nocentino

As AI continues to evolve, many of us are looking for ways to leverage...

Monday Monitor Tips: Finding the Hostname for Queries

I was chatting with a customer recently and they wanted to know which host...

Read the latest Blogs

Forums

Internationalisation

By julian.fletcher

Quick one I hope in case I'm heading off in entirely the wrong direction!...

Size of DB on physical disk doesn't match Disk Usage by Table report

Hi everyone I am looking at the size of my db on disk (ie...

Getting the TEXTSIZE

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Getting the TEXTSIZE

Visit the forum

Question of the Day

Getting the TEXTSIZE

How can I check what value I used for TEXTSIZE? I ran this code:

SET TEXTSIZE 8096

But then deleted the code and couldn't remember. Is there a way to check this?

See possible answers