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...1 min read·sqlserverinterview.hashnode.devAug 13, 2025
#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 ...1 min read·sqlstation.hashnode.devMay 20, 2025
Powershell : Open Powershell in CMD as Administrator> powershell start-process powershell -verb runas as shown below, open CMD from windows system1 min read·powershellstation.hashnode.devMay 20, 2025
Unusual Wait types CLR_Join in SQL Server Matters After a Windows PatchA critical lesson from CLR_JOIN waits and SQL Server performance bottlenecks2 min read·sqlstation.hashnode.devMay 20, 2025
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...1 min read·sqlserverinterview.hashnode.devJul 1, 2024
