SQL Server – SELECTing/Displaying Top N rows from a table
To SELECT only top N rows from a table we can use TOP clause in SELECT statement. Using TOP clause...
2013-07-15
863 reads
Blog Posts
SQL Server Database Backups and Recovery Models – (Part 2)
Checkout the part-2 of my three part article series on SQL Server Database Backups and Recovery Modelshere, in which you’ll learn...
2013-07-15
934 reads
SQL Server Database Backups and Recovery Models – (Part 3)
Checkout the part-3 of my three part article series on SQL Server Database Backups and Recovery Modelshere, in which I discussed...
2013-07-15
742 reads
SQL Server Needs Tempdb
I saw a post recently where someone noted they had moved tempdb like this:
USE master;
GO
ALTER DATABASE tempdb
MODIFY FILE (NAME = tempdev,...
2013-07-15
1,205 reads
Understanding SQL Server Database Restore Process
Data is a critical asset for an organization to keep information about their customers, inventory, products, purchasing, and financial stocks....
2013-07-15
699 reads
Understanding SQL Server Query Optimization Statistics
SQL Server query optimizer uses statistics to create query plans that improve query performance. For most queries, the query optimizer...
2013-07-15
1,521 reads
Upcoming Local NJ Events! Presenting Martin Schoombee and Allan Hirt
Just a quick word on some local events coming your way in the New Jersey area!
TOMORROW - The NJSQL user...
2013-07-15
963 reads
Colorado SQL Events : July 2013
All ColoradoSQL user group meetings start at 5:30 p.m. and provide food and refreshments. There is no cost to attend...
2013-07-14
505 reads
PASS SQL Saturday Events : July 2013
PASS SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Please note that in...
2013-07-14
519 reads
PASS Virtual Chapter Events : July 2013
Join SQL Server professionals from around the world for free online technical training and networking year round. PASS Virtual Chapters...
2013-07-14
799 reads
Blogs
Narrow Task Decomposition in AI Pipeline Agents
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
Car Update: August 2026
By Steve Jones
It’s been some time since I provided a car update, so I decided to...
Microsoft Fabric OneLake Shortcuts: When to Use Them and When Not To
By James Serra
An architecture scenario Imagine separate Sales, Finance, Shared Data, and Executive Analytics workspaces. Sales...
Forums
Searching for my own posts
I have a really stupid question... Is there an easy way to search for...
How to Work with On-Premises AI Models to Generate T-SQL Code
Comments posted to this topic are about the item How to Work with On-Premises...
Escaping Strings
Comments posted to this topic are about the item Escaping Strings
Question of the Day
Escaping Strings
The STRING_ESCAPE() function requires 2 parameters in SQL Server 2025. The first is a string of text and the second is the type of escape rules being used. What are the options for the second parameter?
See possible answers