|
|
-
|
|
Having the same non-qualified column name/alias in the ORDER BY clause results in an error. But what would happen if we define duplicate column aliases in the SELECT clause? Will SQL Server consider this to be an ambiguous column name? This post presents the answer to this interview question....
|
|
-
|
|
A week ago, I posted for Insert, Update and Delete statement with TOP clause and Merge statement as individual post. If you not read those posts then read it before to move next. In this posts I used TOP clause with DML operations and Merge statement bu...
|
|
-
|
|
In this post I explore the database and index related DMVs introduced in SQL Server 2012, namely: sys.dm_db_uncontained_entities, sys.dm_db_log_space_usage and sys.dm_db_fts_index_physical_stats....
|
|
-
|
|
In this post, I am going to explain about default keyword in c#. Introduction: As per MSDN default keyword in C# used to assign the default value of the type. In some situation its comes very handy where we don’t want to create object and direct...
|
|
-
|
|
Throughout my career as a Business Intelligence Consultant, I have met and interacted with a lot of DBAs. One thing (among many others) I particularly admire about them is that they have their own list of SQL scripts that they carry with them from job t...
|
|
-
|
|
When you run the following codeselect name from sys.objects
having 1=1
you get the following error Msg 8120, Level 16, State 1, Line 2
Column 'sys.objects.name' is invalid in the select list because it is not contained in either an aggregate function or...
|
|
-
|
|
In this post, I am going to explain how we can convert an generic list to simple int array with Help of Linq. Recently, I was working on an application and there I needed an Int array of for list of ids in generic list. I tried various methods and then ...
|
|
-
|
|
Using Temporary tables in SSIS...
|
|
-
|
|
A few days back, I spoke about the manual failover of mirroring and also explained one issue and workaround too. Continuing with the same failover, I want to express one more issue here. This issue is not very critical but it somehow to create an issue ...
|
|
-
|
|
Microsoft SQL Server 2008 introduced the DATE and TIME data-types. TIME could be added to DATETIME in SQL 2008, but can longer be done so in SQL Server 2012. In this post, we look at the Msg #402, and associated workaround....
|
|