About SQL Server, Schema z, and Others
Local temporary tables are the unsung heroes of SQL programming — created in a flash, used extensively, and then often… left behind like forgotten leftovers in the fridge. Imagine a long script that creates temporary tables and references them throughout. Once executed, if you need to run it again in the same session, you’ll first … Read more
Removing objects in SQL Server can be straightforward, but it often requires you to know the specific type of the object you’re working with. For example: if object_id('obj1') is not null drop table obj1; or drop table if exists obj1; While these methods work for many object types, they require you to specify the object’s … Read more
Schema z introduces objects manipulating string and simplifies your work, https://github.com/sqlnotes/sql/wiki/FunTricks#string-operations . select z.fn_LettersOnly('Hello World 123') — HelloWorld select z.fn_NumbersOnly('Hello World 123') — 123 declare @LongString nvarchar(max) = replicate('a^^', 300) select * from z.fn_SplitString(@LongString, '^^') option(MaxRecursion 0) declare @LongString nvarchar(max) = replicate('a^^', 300) select * from z.fn_SplitStringFixedLength(@LongString, 3) option(MaxRecursion 0) select z.fn_SecondsToTimeString(98765) — 1.03:26:05 declare @str … Read more
Picture this: you’re ready to unleash your groundbreaking SQL code, only to find it blocked at every turn. Suddenly, you’re the “hero” of the office, staring intensely at sys.dm_exec_requests, identifying blocking sessions like a detective in a mystery novel, and manually KILLing them one by one. You look extremely professional, your keyboard clattering like a … Read more
The importance of object naming convention in a database system is a well known subject which will not be discussed in this article. Instead, this article focuses on how it’s defined and enforced in Schema Z. To enforce the naming conventions, function z.fn_GetExpectedName generates standard names for database objects. This function is referenced by views … Read more
Over the past 30 years of working with SQL Server, I’ve realized that many routines—like user migration, partition management, and more—can be streamlined with a shared library. So, I decided to create one to simplify these complexities. The code is available at: https://github.com/sqlnotes/sql. Documentation is available at https://github.com/sqlnotes/sql/wiki. This library isn’t designed to solve every … Read more