Nagaraj Venkatesan

I am Nagaraj (aka Raj), a SQL Server Database Administrator for one of the busiest OLTP systems in Singapore. Being a SQL Enthusiast for over 10 years now, I love to explore and share more and more on SQL Server.

Backup log Truncate_Only in SQL Server 2008

by Nagaraj Venkatesan

SQL and SQL Only

BACKUP LOG <db_name> WITH truncate_only command, used for clearing the log file, is deprecated in SQL Server 2008. So this post will explain option...

2010-11-16

1,689 reads

Finding CPU Pressure - dm_os_schedulers DMV

by Nagaraj Venkatesan

SQL and SQL Only

The last post dealt with checking CPU pressure using wait_stats DMV. But, to get a complete picture of CPU Pressure,...

2010-11-09

800 reads

Blogs

Microsoft Tools for Making Data AI-Ready

Making Data AI-Ready, Part 2 (This is the second article in a three-part series...

Local Models Using GPUs with Ollama

Can you use your GPUs when running a local model under Ollama? You can,...

Don’t Fear the Technology

By Brian Kelley

The concern that a particular technology is going to destroy the world seems to...

Read the latest Blogs

Forums

Moving Beyond the Reboot: Finding the Culprit Behind Memory Pressure

By Pablo Echeverria

Comments posted to this topic are about the item Moving Beyond the Reboot: Finding...

Reserved Words I

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Reserved Words I

Get Along

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Get Along

Visit the forum

Question of the Day

Reserved Words I

Which of these are not reserved words?

See possible answers