Relational database
Microsoft's enterprise relational database engine.
A full-featured RDBMS with T-SQL, a cost-based optimizer, columnstore indexes, in-memory OLTP, Always On availability groups and deep tooling. Runs on Windows, Linux, containers and as Azure SQL.
SQL ServerAdvancedError 1205 again? Pull the deadlock graph from the system_health session, read it like a DBA and fix the access pattern that causes it.
#concurrency#locking#troubleshooting
The single most important physical design decision in SQL Server, explained from first principles — with the queries to prove it.
#indexing#performance#schema-design
SQL ServerIntermediateWhat each isolation level protects you from, what it costs, and why so many teams switch on READ_COMMITTED_SNAPSHOT.
#concurrency#locking#transactions
SQL ServerBeginnerRestore a SQL Server database with T-SQL or Management Studio: WITH MOVE, NORECOVERY chains, point-in-time recovery, and fixes for errors such as 3154 and 3201.
#restore#sql-server-2014
SQL ServerBeginnerAdd or subtract days, months, hours and other units from a date with DATEADD in SQL Server, and handle month-end results, overflow errors and index-friendly filters.
#t-sql
SQL ServerBeginnerGet row counts for every user and system table in a SQL Server database instantly from catalog metadata, and know when you need an exact COUNT instead.
#t-sql
SQL ServerBeginnerFind out how much disk space a SQL Server database, table or index uses with sp_spaceused and sys.dm_db_partition_stats, and read the numbers correctly.
#t-sql
SQL ServerBeginnerUse ASCII, CHAR, NCHAR, CHARINDEX, LEFT, LEN, LOWER, LTRIM and DIFFERENCE correctly in SQL Server, with examples, results and the pitfalls of each.
#t-sql
SQL ServerBeginnerCreate, alter and drop views in SQL Server, update data through them safely, and understand schema binding, indexed views, permissions and common mistakes.
#t-sql
SQL ServerBeginnerFind failed SQL Server logins in the error log, read the error 18456 state codes, check SQL logins with LOGINPROPERTY, and set up a lasting audit.
SQL ServerBeginnerNumber rows with ROW_NUMBER() in SQL Server, then use it to get the latest row per group, delete duplicates and page results without surprises.
#t-sql
