SqlServer

Basically, collation defines the rules for how strings of characters data are stored and compared. Based on the norms of a particular language it will vary. Query conditions will change depending on the language configured. The server collation acts as the default collation for all the system databases and also newly created databases. we can … [Read more…]

By Default in SqlServer, new database files are being created and stored in %Program Files%\Microsoft SQL Server\MSSQLXXX.MSSQLSERVER\MSSQL\DATA. This path can be changed to desired or configured path. To change Data and log files path Connect to SqlServre using SSMS Select connected Server and then Properties From Server properties –> Select Page (left side) –> Database … [Read more…]