Profile cover photo
Profile photo
jai verma
870 followers -
Wel come my fnd :-)
Wel come my fnd :-)

870 followers
About
jai's posts

Post has attachment
SQL Server -How to move the “system database” files in SQL Server
It’s Very Simple 10 steps to
do this. In
this example System database files existing in C: Drive and I will move it in
D: Drive. Step1- Check the D drive is access.
Right click on D drive and go to Properties, go to security tab and find the Administrator
“...

Post has attachment
SQL Server: Best practice to Move database from one Location to another location.
Most of  SQL Server professional may know the how to move the database
form One location to another location. And most of the professional use the
"detach and attach" method but.. "Is it best
practice?"   NO!! WHY? – If your database file size
is1TB or arou...

Post has attachment

Post has attachment
SQL Server : Important Commands for SQL Server DBA
--To check for
Blocked Processes: Sp_who2     --To find all
the log files and the percentage space used of those log files in an instance: dbcc sqlperf ( logspace )    --To list all
the files and their details in a particular database: exec sp_helpfile --To...

Post has shared content
दुनिया का सबसे बड़ा सिद्ध साइबर अपराधी।
क्या यही है आम आदमी की पहचान?
Photo

Post has attachment
SQL Server - How to resolve TempDB get FULL issue.
Please find the complete details to troubleshooting and resolving If the TempDB database get full:-   Description : The LOG FILE FOR DATABASE 'tempdb' IS FULL.  Back up the TRANSACTION LOG FOR the DATABASE TO free  up SOME LOG SPACE   Reason for temp DB ful...

Post has attachment
SQL Server- How many IP Addresses used in SQL Server Clustering?
2 IP for heartbeat network (1 per node) 2 IP for public network (1 per node) 1 IP for Windows Cluster. 2 IP for SQL Server Virtual Network Name (SQL instance on each node) 1 IP for MSDTC (this is optional however required if you use distributed transaction ...

Post has attachment
SQL Server: Everything about SQL Server Database Mirroring step by step and all Question and Answer of SQL Server Database mirroring
SQL Server: Everything about SQL Server
Database Mirroring step by step and all Question and Answer of SQL Server
Database mirroring. Friends believe me it’s very easy and anybody can create the mirroring and
work on it. For testing I am creating mirroring
...

Post has attachment
SQL Server: Important DMV scripts for troubleshoot the issue in SQL Server
Please find the below important DMV scripts for troubleshoot the issue in SQL Server.   sys.dm_exec_requests sys.dm_exec_sql_text sys.dm_os_waiting_task sys.dm_os_wait_stats sys.dm_exec_sessions   sys.dm_tran_locks --Here is a
sample script that shows wait ...

Post has attachment
SQL Server : Complete DBCC commands for Performance Tunning in SQL Server
SQL Server : Complete DBCC commands for Performance Tunning in SQL Server. Using below queries we can tune the DB. /*Returns size
and fragmentation information for the data and indexes of the specified table
or view*/ SELECT * FROM sys . dm_db_index_physica...
Wait while more posts are being loaded