Managing SQL Server Databases and Tables
Data Types
Various data types serve specific purposes within SQL Server. Each type has defined ranges and applications for optimal use.
Server Configuration
Server Properties via SERVERPROPERTY
Retrieve server information using the SERVERPROPERTY function:
SELECT CONVERT(sysname, SERVERPROPERTY('servername'));
System Views for Server Details
Q ...
Posted on Mon, 18 May 2026 11:42:14 +0000 by ManicMax
Efficient Pagination and Window Functions in SQL Server
Paginatoin with Separate Count Query
When implementing pagination in SQL Server, one common approach is to execute two separate queries—one to retrieve the total record count and another to fetch the actual data page.
-- Retrieve total number of matching records
SELECT COUNT(*) AS TotalRecords
FROM Products
WHERE CategoryId = 5 AND IsActive = 1 ...
Posted on Sun, 17 May 2026 03:50:15 +0000 by Code_guy
Leveraging XQuery and XML within SQL Server
Modern relational databases bridge the gap between structured relational storage and hierarchical XML data. SQL Server provides robust features for both exporting result sets as XML and manipulating XML documents stored directly within database columns using XQuery.
Generaitng XML from Relational Queries
SQL Server allows you to transform query ...
Posted on Wed, 13 May 2026 03:42:52 +0000 by Catharsis