SQL SERVER – New DMV in SQL Server 2017 – sys.dm_os_enumerate_fixed_drives. A Replacement of xp_fixeddrives September 22, 2017SQL Tips and Tricks2 CommentsSQL Scripts, SQL Server, SQL Server 2017, SQL Stored ProcedurePinal Dave Read More
SQL SERVER – 7 Important Things to Remember While Taking Effective Backup September 20, 2017SQL Tips and TricksNo CommentsSQL Backup, SQL ServerPinal Dave Read More
SQL SERVER – How to Move SQL Server Cluster to Different Domain? September 16, 2017SQL Tips and TricksNo CommentsSQL Domain Controller, SQL Server, SQL Server ClusterPinal Dave Read More
SQL SERVER – Convert Decimal to Time Format in String September 13, 2017SQL Tips and Tricks4 CommentsSQL Datatype, SQL DateTime, SQL Function, SQL Scripts, SQL Server, SQL StringPinal Dave Read More
SQL SERVER – How to Create Linked Server to SQL Azure Database? September 12, 2017SQL Tips and TricksNo CommentsLinked Server, SQL Azure, SQL Error Messages, SQL ServerPinal Dave Read More
SQL SERVER – Remove Duplicate Chars From String – Part 2 September 11, 2017SQL Tips and Tricks2 CommentsSQL Function, SQL Scripts, SQL Server, SQL StringPinal Dave Read More
SQL SERVER – How to Find UNIQUE Key Columns? – sp_special_columns September 8, 2017SQL Tips and TricksNo CommentsSQL Constraint and Keys, SQL Scripts, SQL Server, SQL Stored ProcedurePinal Dave Read More
