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
Enable xp_cmdshell with sp_configure: turn on show advanced options, set xp_cmdshell to 1 and run RECONFIGURE. The full script is ready to run in SSMS.
SQL SERVER – 2005 Query Analyzer – Microsoft SQL SERVER Management Studio
Looking for Query Analyzer in SQL Server 2005? It moved into SQL Server Management Studio. Where to find it and tips to feel at home there.
SQL SERVER – Raid Configuration – RAID 10
Which RAID do I use for my SQL Servers? RAID 10. It gives great read and write performance, while RAID 5 pays a write penalty for parity.
SQL SERVER – @@DATEFIRST and SET DATEFIRST Relations and Usage
How SET DATEFIRST changes the first day of the week, and how @@DATEFIRST returns the current value, which also changes with SET LANGUAGE. Simple examples.
SQL SERVER – Fix : Error 1418 – Microsoft SQL Server – The server network address can not be reached
Error 1418 says the server network address cannot be reached or does not exist. Check the firewall, then enable TCP/IP for the server and client on port 1433.
SQL SERVER – Script to Find SQL Server on Network
I manage lots of SQL Servers and forget their names, so I use xp_CMDShell and ISQL -L to find SQL Server on network machines. A short video is included.