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…
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…
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…