Powershell in a windows scripting tool which helps SQL Server Administrator and developer to automate the administration and deployment activity. Windows PowerShell scripts can also be used to administer other Microsoft server products. This gives administrators a common scripting language across servers. Sources: MSDN
Mostly when we are dealing with performance issue , we tend to see every aspect of the system which may have cause this issue. One among those thing is Indexed View. If you have number of view in your database, then checking them individually by...
There are various occasions when we see the Estimated execution plan & Actual Execution plan to be completely different. There can be various reason to that, one being that the statistics is not updated. How what does, these means? Actually internally SQL Server stores the...
When we are studying the Estimated Execution Plan we should never mixed up DML with DDL, because Query optimizer in Estimated Execution Plan does not really executes the query, It Parse it with the help of Algebrizer & Query Processor Tree. Hence when we try...
In SQL Server Algebrizer is the process(we can say a piece of code) which is part of SQL Server Execution Plan. The task of Algebrizer, is to uniquely identify various objects like the tables & columns. It determines which column to take from which table,...
To find the datatype of a column for a particular table is a simple task in SSMS. It can be done by right click on table name –> Design. But consider a suituation where you want to prepared a data dictionary for your Database and...
When you are working with more then one account, which ideally should not be the condition, you tend to get confused that as which user you had executed the command. To find out on the current instance as which user you had login , kindly...
We must remember that when we make some schema level change to the table present in the view then in order that the changes should be reflected in the table we must execute sp_refreshview as follow: EXEC sp_refreshview To understand this let us consider the...
There might be some situations where we may have to add the clustered index on the existing column of a table or create a new column and add the Primary key. One situation where i remember that this can be usefull is when we are...
When dealing with complex projects related to SSAS, we might come across some scenario’s where the number of columns are more. Sometimes we need to count the number of column in a table. Following is the query to find the number of columns in a...
