Random Number Generator. There are many methods to generate random numbers in SQL Server.
Method 1: Generate Random Numbers (Int) between Rang
SQL SERVER – Enable xp_cmdshell using sp_configure
The xp_cmdshell option is a server configuration option that enables system administrators to control whether the xp_cmdshell extended stored procedure can be executed on a system.
SQL SERVER – 2005 Query Analyzer – Microsoft SQL SERVER Management Studio
Following may be very simple to some and helpful to other type of question. I have seen this in my server log as well as this has been always first question in my Developer Team. Where is SQL SERVER 2005 Query Analyzer? SQL SERVER 2005 has combined Query Analyzer and…
Read MoreSQL SERVER – Raid Configuration – RAID 10
I get question about what configuration of redundant array of inexpensive disks (RAID) I use for my SQL Servers. The answer is short is: RAID 10. Why? Excellent performance with Read and Write. RAID 10 has advantage of both RAID 0 and RAID 1. RAID 10 uses all the drives…
Read MoreSQL SERVER – @@DATEFIRST and SET DATEFIRST Relations and Usage
The master database’s syslanguages table has a DateFirst column that defines the first day of the week for a particular language. SQL Server with US English as default language, SQL Server sets DATEFIRST to 7 (Sunday) by default. We can reset any day as first day of the week using…
Read More
SQL SERVER – Fix : Error 1418 – Microsoft SQL Server – The server network address can not be reached
Error: 1418 – Microsoft SQL Server – The server network address can not be reached or does not exist. Check the network address name and reissue the command
The server network endpoint did not respond because the specified server network address cannot be reached or does not exist.
SQL SERVER – Script to Find SQL Server on Network
I manage lots of SQL Servers. Many times I forget how many server I have and what are their names. New servers are added frequently and old servers are replaced with powerful servers. I run following script to check if server is properly set up and announcing itself. This script…
Read More