Profile cover photo
Profile photo
Amish Shah
20 followers
20 followers
About
Amish's posts

Post has attachment
How to set shortcuts in query editor
If we set short cuts for commands like sp_lock, sp_helptext , sp_who2 it can be handy as its frequently required for any developers. Lets see how to set short cut for this in query editor. Go to Tools-> Option->Environemnt->Keyboard->Query Shortcuts Set sho...

Post has attachment
Dm_db_stats_properties - to get statistics properties
Managing statistics is important part for developers. Many times we have seen improper statistics screwed up the queries and queries which completes in seconds takes hours to complete. Monitoring statistics and updating it regularly is important for this as...

Post has attachment
How to get login details
Many times we need to check users logged in our system for various reasons. This reasons can be many but main requirement we need to know who logged in out system. There are many ways in SQL Server for this and with introduction of newer versions many new m...

Post has attachment
Error 8623 and 8632 in SQL Server 2016.
Recently after migrating to SQL Server 2016 one of our app start to failing. While debugging I found the query which was failing. The query is like this. This was working fine SQL Server 2014 but now failing in SQL Server 2016. I tried it on various serves ...

Post has attachment
pwdcompare - to check predictable password
How to check week passwords? As a strong security policy we also need that password are not predictable. Many time we need to test this but checking all such predictable password with all logins is very tedious task and any one will try to avoid. Recently I...

Post has attachment

Post has attachment

Post has shared content

Post has attachment

Post has attachment
New data compression - Columnstore Archive
All who have used columnstore index must know that columnstore index also compress data. Many cases after some time this data become historical and use of this data reduces over time. In this case we can further compress data sung columnsore_archive compres...
Wait while more posts are being loaded