PowerShell & SQL Server: Search & Find Indexes By SchemaName, TableName, IndexName Or ColumnName Across Instances/DB’s

Necessity is the mother of new PowerShell code :-)! Today, I received an email request to get the list of all indexes in a given TableName but the requester did not specify the DatabaseName although the SQL InstanceName was specified. It would be too easy to ask the person for the DBName and script it …

Advertisement

SQL Server – Aliasing Tables In UPDATES For The Oracle Folks

If you transition from Oracle to SQL Server, something as simple as aliasing a table in an UPDATE statement might stump you (things that SQL Server developers take for granted) Here is what I mean: Create a temporary table (#Temp) to play with: Get the structure of #Temp This is also a trick to view the …