On Nomenclature, and Execution Plan Plus
Nomenclature, or the science of using words to name things using a logical system, is important since accurate names portray with clarity what the thing does. Recently, there’s been a suggestion, posited by Erin Stellato…
List Recently Created Objects
The code below provides a list of all SQL Server objects created in the past “x” number of days. Dynamic T-SQL is used to construct a query for each database, including system databases. Each query…
Hidden tables in SSMS: detect and create them!
Did you know hidden tables may be lurking in your database? SQL Server Management Studio is a world-class database management toolset, and includes some really great features. Arguably the most-used feature is the Object Explorer…
Common data-type conversions between SQL Server, Oracle, Sybase ASE, and DB2.
SQL Server includes a little-known, but handy, function that can show you common data-type conversions for a target system; useful for ETL between disparate systems. Run this code:
DECLARE @source_dbms sysname = N'%'
, @source_version sysname = N'%'
, @source_type sysname = N'%'
, @destination_dbms sysname = N'%'
, @destination_version sysname = N'%'
, @destination_type sysname = N'%'
, @defaults_only bit = 0;
FROM sys.fn_helpdatatypemap (
The above code returns a result-set…
SQL Server 2000 Books Online Documentation
This simply serves as a repository for the SQL Server 2000 Books Online Documentation, in case Microsoft decides to no longer provide it on their website. To be clear, I’m not suggesting anyone actually use…