Question: What is N in nvarchar?
Answer: n in nvarchar or nchar stands for world national. Let us learn today about datatypes.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Datatype Decimal Explained – Datatype Numeric
Just the other day I received an email from a client who was confused about the Datatype Decimal. Let us learn today how it works.
Room for an Index Build: Free Space and TempDB Placement
Room for an index build is the free space that your database and tempdb need before the build starts. This post estimates the index, checks both places, breaks a build on purpose, and shows what SORT_IN_TEMPDB moves and what it leaves in your database.
Finding the Indexes Behind Lock Waits With Operational Stats
Rank indexes behind lock waits with operational stats, separate latches from locks, and test targeted access or row versioning fixes.
Grid vs Text Output in SSMS: Why Line Breaks Disappear
Grid vs text output is a Management Studio setting that decides whether the line breaks in your data stay visible. This post builds a value with a line break, proves with T-SQL that the data holds it, and shows how to keep the break in each mode.
SQL SERVER – Move a Table From One Schema to Another Schema
ALTER SCHEMA can Move a Table between schemas within one database. A customer had imported under the wrong schema.
Generate a Date Range: List All Dates Between Two Dates
To generate a date range in SQL Server, number the days between a start date and an end date and add each number to the start. This post shows a recursive CTE, its limit of 100 recursions, GENERATE_SERIES, a version for older servers, and how to handle times and missing days.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.