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

757 reads

Blogs

T-SQL Tuesday #180: Good enough is perfect Roundup

By hellosqlkitty

This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...

Using SQL Compare with Read-only Access

Recently a customer asked if SQL Compare and SQL Data Compare can be used...

Off to Live 360

I am off to Live 360 today, on my last trip of the year....

Read the latest Blogs

Forums

how can i tell if our db2 driver is ms or ibm or other?

i see this in the definition of a linked server on our wh sql...

normal role member to be able to view list of other role members in his DB

Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...

Stairway to Snowflake Level 5 - Using Snowflake with SnowSQL and Visual Studio Code

By Mike McQuillan

Comments posted to this topic are about the item Stairway to Snowflake Level 5...

Visit the forum

Question of the Day

A Strange Result

What does this code return in SSMS 20 from SQL Server 2019?

select '|' + CHAR(0)+'abc' + '|';

See possible answers