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,661 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

785 reads

Blogs

SQL Training Black Friday Deals

By Brian Kelley

If you're looking for particular "Black Friday" deals, here is what I've seen advertised...

Dry-run xp_delete_file Before Actually Deleting Files?

Dry-run xp_delete_file Before Actually Deleting Files? xp_delete_file doesn’t really have a...

Happy Thanksgiving! (USA Holiday)

By Brian Kelley

In the United States, today is Thanksgiving. The intent behind the holiday is to...

Read the latest Blogs

Forums

FinOps - the new name for performance tuning

Comments posted to this topic are about the item FinOps - the new name...

Which Object Definitions Are Available?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Which Object Definitions Are Available?

What's Your Theme Music?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item What's Your Theme Music?

Visit the forum

Question of the Day

Which Object Definitions Are Available?

For which of these object types can I get the code when I run the OBJECT_DEFINITION() function in SQL Server 2025? (choose 3)

See possible answers