Categoria: Banco de Dados

1. load the script called Generate Change Column CollationEnsure that the Collation setting at the top is correctRun it against the DatabaseSave the results as 01_Change_Column_Collation.SQL 2. Load the Script called Generate Primary Key ConstraintsRun it against the databaseSave the results...

SELECTqs.creation_time,qs.last_execution_time,qs.execution_count,qt.text AS sql_text,qp.query_planFROMsys.dm_exec_query_stats AS qsCROSS APPLYsys.dm_exec_sql_text(qs.sql_handle) AS qtCROSS APPLYsys.dm_exec_query_plan(qs.plan_handle) AS qpORDER BYqs.last_execution_time DESC;...

SELECT  s.[name] AS [schema],        t.[name] AS [table_name],        p.[rows] AS [row_count],        CAST(ROUND(((SUM(a.total_pages) * 8) / 1024.00), 2) AS NUMERIC(36, 2)) AS [size_mb],        CAST(ROUND(((SUM(a.used_pages) * 8) / 1024.00), 2) AS NUMERIC(36, 2)) AS [used_mb],        CAST(ROUND(((SUM(a.total_pages) – SUM(a.used_pages)) * 8) / 1024.00, 2) AS NUMERIC(36,...

ALTER DATABASE xxxxx SET EMERGENCY;GO ALTER DATABASE xxxxx set single_userGO DBCC CHECKDB (xxxxx , REPAIR_ALLOW_DATA_LOSS) WITH ALL_ERRORMSGS;GO ALTER DATABASE xxxxx set multi_userGO...

https://leetcode.com/...

https://www.weebly.com/br https://www.netlify.com/...

https://contentdrips.com/...

https://cleanup.pictures/...

https://www.codewars.com/ https://grasshopper.app/pt_br/ https://codecombat.com/ https://flukeout.github.io/ https://checkio.org/ https://mystery.knightlab.com/...

https://tinywow.com https://express.adobe.com/pt-BR/sp...