Topic: FCI (Failover Cluster Instance)Topic: Clusters is alive, like alive 1) Can we rename named instance name in SQL server? - No /* Note that Instance Name rename is unsupported. In named instance the server name is in format of ServerName\InstanceName. So, you can change it to N...Aug 13, 2025 · 1 min readsqlserverinterview.hashnode.dev
#DynamicSQL: Create customized SQL queries from a query/* using Dynamic SQL – generate multiple customized Select query using dynamic sql */ select ‘select top 2 * from ‘ + table_name from information_schema.tables where table_type = ‘base table’ order by TABLE_NAME ASC /* using Dynamic SQL – generate ...May 20, 2025 · 1 min readsqlstation.hashnode.dev
Powershell : Open Powershell in CMD as Administrator> powershell start-process powershell -verb runas as shown below, open CMD from windows systemMay 20, 2025 · 1 min readpowershellstation.hashnode.dev
Unusual Wait types CLR_Join in SQL Server Matters After a Windows PatchIntroduction SQL Server is a robust platform, but even the strongest systems can falter when foundational components change—like the operating system. Recently, after applying a Windows Server 2016 Enterprise edition patch, we encountered a sudden an...May 20, 2025 · 2 min readsqlstation.hashnode.dev
Topic: Trace Flags1) what is trace flag 12310 used for in AG? 2) what are trace flags used for Deadlock - 1222, 1204 3) what is the use of trace flag 1117? - forces all db files on each db to grow uniformly. 4) master db files has to be relocated to different drive. h...Jul 1, 2024 · 1 min readsqlserverinterview.hashnode.dev
