Profile cover photo
Profile photo
Amish Shah
20 followers
20 followers
About
Posts

Post has attachment
Add a comment...

Post has attachment
Specifying file groups in Select Into.
IN Select into we can not specify file
group and hence always table was created primary file group. Then we have to create clustered index
on other filegroup to change filegroup of created tabled.  This is time and resource consuming as it needs to move dat...
Add a comment...

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...
Add a comment...

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...
Add a comment...

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...
How to get login details
How to get login details
blog.sqltechie.com
Add a comment...

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 ...
Add a comment...

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...
Add a comment...

Post has attachment
Add a comment...

Post has attachment
Add a comment...

Post has shared content
Add a comment...
Wait while more posts are being loaded