Sqlserverlearner - sqlserverlearner.com - SQLSERVERLEARNER
General Information:
Latest News:
All about SQL Server Views 30 Apr 2013 | 08:00 pm
Advanced topics: Check Option Encryption SchemaBinding ViewMetadata More info can be found in books online
When To Use LOWER/UPPER for comparing data in SQL Server – Alternatives 15 Mar 2013 | 02:46 pm
In SQL Server LOWER Can be used to convert uppercase/mixedcase string to lower case string. More about LOWER can be found here Similarly, UPPER Can be used to convert lowercase/mixedcase string to upp...
How to get number of rows in a table without using count function 8 Mar 2013 | 02:44 pm
How to get number of rows in a table without using count function? In SQL Server you can get the approximate number of rows in the table using the below sample script. This script uses sys.partitions ...
Deadlock Internals with Real Time Scenario – Explanation and Resolution 20 Feb 2013 | 04:26 pm
What is deadlock? A deadlock is a situation in which two or more competing actions are each waiting for the other to finish, and thus neither ever does. Refer: http://en.wikipedia.org/wiki/Deadlock Sc...
SSMS ISSUE: Connection information does not change in SSMS when a new Query is created from Dedicated Administrator Connection 2 Jan 2013 | 05:00 pm
Description: Connection information does not change in SQL Server Management Studio for SQL Server 2008 r2 when a new Query is created from Dedicated Administrator Connection. Steps: 1. Open SQL Serve...
How To View Data in Hidden System Tables. 2 Jan 2013 | 04:38 pm
SQL Server has System base tables which are hidden cannot be directly queried. For example: Output: Msg 208, Level 16, State 1, Line 1 Invalid object name ‘sys.sysrscols’. In order to view data from t...
Impact of TEMPDB Collations on Other Databases 2 Jan 2013 | 03:36 pm
When you create databases with different collations then you have to be very careful when using the temporary tables. In the below script let us analyze such a scenario. Creating Sample database with ...
Interesting Observation – Declaring Table Variables impact on Tempdb 31 Dec 2012 | 05:39 pm
Following was an intresting observation when creating table variables. 1. Table variables are created in tempdb. 2. Table variables are created in tempdb even before the declare table is called. Steps...
SSMS Available Databases DropDown Acts weird if Connection Properties Are Changed 11 Sep 2012 | 04:55 pm
SQL Server Management Studio (SSMS) Has a available databases dropdown ( to select a database to execute the query.). This dropdown behaves weird when you change the connection properties. Observation...
‘Ӈ耇’ was found in the text of this event 11 Sep 2012 | 04:19 pm
When you are running a SQL Server profiler and the SQL Server Service it is connected to got Stopped/Restarted, then you get the below message in the TextData in SQL Profiler.
