How can we check whether the port number is connecting or not on a Server
How can we check whether the port number is connecting or not on a Server? TELNET
Advertising
SQL Server is not responding. What is action plan?
SQL Server is not responding. What is action plan? Connect using DAC via CMD or SSMS Connect via CMD SQLCMD -A –U myadminlogin –P mypassword -SMyServer –dmaster Once you connect to the master database run the diagnostic quires to find the problem Correct...
What are the Hotfixes and Patches?
What are the Hotfixes and Patches? Hotfixs are software patches that were applied to live i.e. still running systems. A hotfixis a single, cumulative package that includes one or more files that are used to address a problem in a software product (i.e....
Why Shrink file/ Shrink DB/ Auto Shrink is really bad?
Why Shrink file/ Shrink DB/ Auto Shrink is really bad? In the SHRINKFILE command, SQL Server isn’t especially careful about where it puts the pages being moved from the end of the file to open pages towards the beginning of the file. The data becomes...
Advertising
What are the different log files and how to access it?
What are the different log files and how to access it? SQL Server Error Log: The Error Log, the most important log file, is used to troubleshoot system problems. SQL Server retains backups of the previous six logs, naming each archived log file sequentially....
How many datafiles I can put in Tempdb? What is the effect of adding multiple data files.
Q. How many datafiles I can put in Tempdb? What is the effect of adding multiple data files. By far, the most effective configuration is to set tempdb on its own separate fast drive away from the user databases. I would set the number of files based on...
What is the common trace flags used with SQL Server?
What is the common trace flags used with SQL Server? Deadlock Information: 1204, 1205, 1222 Network Database files: 1807 Log Record for Connections: 4013 Skip Startup Stored Procedures: 4022 Disable Locking Hints: 8755 Forces uniform extent allocations...
Do you know about Resource Database?
Do you know about Resource Database? All sys objects are physically stored in resource database and logically available on every database. Resource database can faster the service packs or upgrades
Advertising
SQL SERVER -Resource db mdf and ldf file names?
Q. Any idea what is the Resource db mdf and ldf file names? Ans: mssqlsystemresource.mdf and mssqlsystemresource.ldf
SQL SERVER – Improvements in TempDB
SQL SERVER – 2005 Improvements in TempDB Following are some important improvements in tempdb in SQL Server 2005 over SQL Server 2000 Input/Output traffic to TempDB is reduced as logging is improved. In SQL Server 2005 TempDB does not log “after value”...