Profile cover photo
Profile photo
s vr
80 followers
80 followers
About
s's posts

Post has attachment

Post has attachment
Public
About Trace Flag -T 1117
In your SQL Server environment for any data base having more than one data file along with temp database data files with the same size and with auto-grow option. Lets assume that you have a database with eight files & initial size of 1024 MB and auto-grow o...

Post has attachment

Post has attachment
Public
sql server configuration default values of 2008R2/2012/2014 versions
Below are the SQL Server Default configuration values for 2008R2/2012/2014 SQL 2008R2 SQL 2012 SQL2014 Configuration Option Minimum Value Maximum Value Minimum Value Maximum Value Minimum Value Maximum Value access check cache bucket
count 0 65536 0 65536...

Post has attachment
Public
how to invoke a second PS script with argument from a PS script
Inside the first power shell script use below statement to start second script. Invoke-Expression "$scriptPath $argument" E.g  Invoke-Expression "D:\PSScript\SecoundScript.ps1 $arg1" 

Post has attachment

Post has attachment

Post has attachment

Post has attachment
Public
The cluster group SRVSQLCL1 already exists. To contine, specify a new sql server failover cluster group name
At the time of Cluster installation the given resource already used by Cluster. you will get below error To resolve the issue. 1. Remove the given SQL Cluster name from Cluster Resource Open the Failover Cluster Manager Goto Roles or Services and Applicatio...

Post has attachment
Public
Server Configuration options - SQL Server
SQL Server configuration option displayed and changed using SP_Configure system stored procedure. Using this system stored procedure you can view server setting or you can make configuration changes quickly using SSMS. Even you change the couple of configur...
Wait while more posts are being loaded