June 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – Find Number of Rows and Disk Space Reserved – Using sp_spaceused Interesting Observation

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Data Storage, SQL Function, SQL Scripts, SQL Server DBCC, SQL Stored Procedure, SQL Utility
Previously I posted SQL SERVER – Find Row Count in Table – Find Largest Table in Database – T-SQL. Today we will look into the same issue but with some additional interesting detail. We can find the row count using another system SP sp_spaceused. This SP gives additional information regarding…
Read More

SQLAuthority News – Security White Papers

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
SQL Download, SQL Server Security, SQL White Papers
Microsoft Dynamics AX 2009 White Paper: Configuring Kerberos Authentication with Role Centers This document describes how to configure Kerberos authentication with Enterprise Portal and Role Centers. Kerberos authentication is required to display reports created using Microsoft SQL Server Reporting Services and Microsoft SQL Server Analysis Services on Role Center pages.…
Read More

SQL SERVER – sqlcmd – Using a Dedicated Administrator Connection to Kill Currently Running Query

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
SQL Scripts, SQL Server Security, SQL Utility, sqlcmd
People are judged from their questions and not their answers. I received wonderful question the other day. How sqlcmd can be used along with currently running query script posted on your blog? Please read following two posts before continuing this article as they cover background of this article. SQL SERVER…
Read More