Uncategorized

  • Moving / Migrating Database Planning and insights

    Hello Friends, The post i am posting here is reference from very good techonologiest for SQL Server . this explains how to plan migration of DB between servers / storage if adding any more space or due to any reason. What all options we have and with in the downtime. Hope you will be get…

  • Kill me

    Kill the Bill SPID. We use sp_who2 to find out all the sesions existing in the server , and to find the blocking SPID we need to execute select * from sys.sysprocesses where spid0; and then kill the Main spid blocking by using KILL , and then to know when is the rollback process complete…

  • SQLServer Labs …

    SQLServer Labs welcome to all and warm greetings to every SQLServer techie & learning geeks… It’s not the age, which says you grown old it’s the time when you stop learning … enjoy blogging and keep positing you’re all queries for real time answers. Enjoy blogging. Will update with all my recent postings and collection.