SQL Server Education (by the geeks, for the geeks)
Yes, a SQL Server database can be case sensitive. Case sensitive here means that SQL Server will return different result set for CASE, Case, CaSe etc. and it will treat the …
Case sensitive search in SQL Server Read MoreHere are few ways to list all databases in SQL Server SELECT database_id, name from sys.databases GO SELECT dbid, name from sysdatabases GO sp_helpdb GO sp_databases GO sp_MSforeachDB ‘ PRINT ”?” …
List all databases in SQL Server Read MoreMany a times one may need to change compatibility level of a database. In this blog we’ll see how to change database compatibility level or mode of a SQL Server database. …
How to change database compatibility level in SQL Server Read MoreA SQL Server collation setting governs the code page to store non Unicode data in SQL Server and the rules to sort and compare non Unicode characters. The SQL Server installation …
SQL Server change collation of database Read MoreRestore database SQL Server command with replace option is used when we need overwrite an existing database from a backup. The T-SQL command for same is shown below. RESTORE DATABASE [AdventureWorks2014] …
Restore database SQL Server command with replace Read MoreHi Geeks, First of all I would like to thank Amit Sir and SQLServerGeeks.com for giving me this opportunity to blog. This is my 1st blog on SQL Server Statistics Only …
SQL Server Statistics Only Database Read MoreHey Folks, You would have seen in my previous posts, that how the Collation Settings is configured during the Installation of SQL Server. You can also refer to that article by …
SQL Server – How to Configure Collation for the Server, Database, Column, and Query Level in SQL SERVER??? Read More