Techno Freak

Difference Between AI, Machine Learning, and Deep Learning?

noreply@blogger.com (Anonymous) — Tue, 08 Jan 2019 06:27:00 +0000

Article Link: https://blogs.oracle.com/bigdata/difference-ai-machine-learning-deep-learning

Automation Anywhere Vs Blue Prism Vs UIPath

noreply@blogger.com (Anonymous) — Fri, 28 Dec 2018 08:42:00 +0000

These slides represent the difference between Automation Anywhere, Blue Prism and UI Path. I have considered all the key features and Analysis parameter. You can also see the Design Layout and Architecture Diagram. Any Query, please drop the comment.

Artificial Intelligence Insurance Chat Bot

noreply@blogger.com (Anonymous) — Fri, 09 Nov 2018 14:32:00 +0000

This video contains the information on how you can use the cognitive service in the Microsoft Bot Framework. Technologies used Azure Bot Framework, Azure Cloud and Cognitive Services. You can configure this bot on multiple channels like Web, Telegram, Skype and many more.

Please find the bot URL: https://insurancebotweb.azurewebsites.net/About

Alexa (IoT) Based DevOps Solution

noreply@blogger.com (Anonymous) — Tue, 03 Jul 2018 17:20:00 +0000

Design Thinking and Agile : Is it Same or Different ?

noreply@blogger.com (Anonymous) — Mon, 03 Jul 2017 05:08:00 +0000

What’s design thinking?

Design thinking is the methodology where your end user or your customer centric solution..Before starting the work you will interact with users take their feedback. Continuous research on the end users and find the best solution for the problem.

Standard Definition: Design thinking can be described as a discipline that uses the designer’s sensibility and methods to match people’s (end users) needs with what is technologically feasible and what a viable business strategy can convert into customer value and market opportunity...

Myth: Common mistake is peoples are thinking how the design looks like and how it feels to the end user but design thinking is nowhere related with “ looks and feel”.

Design Thinking Snapshot:

Reference URL: http://www.creativityatwork.com/design-thinking-strategy-for-innovation/

Design thinking Videos:

How’s agile fit with Design thinking?

In Design thinking, you have done the interaction, analysis, and research and with the end user. Now time to put all your analysis and research on board to find the best solution for the problem. Here you can use the agile methodology.
Using agile you can put all the problems on board, do the interaction, decide the solution and technology and start the work on the problem.
After every iteration take the feedback from end users ( the customer).
Evaluate, learn. Design and Innovate.

Conclusion: Design thinking is the methodology to interact with end users and define the problems that end user faced. Agile is the methodology to work fast on the problem and find the solution and take continuous feedback from the customer to reach the end user goal.

Final Video of Design Thinking and Agile:

PreSaveAction Function On Custom List

noreply@blogger.com (Anonymous) — Wed, 19 Apr 2017 15:00:00 +0000

How's it's Catch:

SharePoint 2007, I had written an article about how to modify Default OK Button to Customized Action (http://www.gandhipritesh.com/2009/10/change-default-ok-button-to-cusomized.html). Today I have come across the same scenario then I have suggested the same thing but now SharePoint is so advanced that It will default give the PreSaveAction Method.

When you can use:

We do have a requirement to perform some operation before data saved.PreSaveAction function allows overriding functionality when Save button is clicked. PreSaveAction function executes the code written for validation on click of Save button.

A couple of Useful Links:

* https://social.technet.microsoft.com/wiki/contents/articles/31330.sharepoint-using-presaveaction-function-on-custom-list-forms.aspx

* http://hannanazam.blogspot.in/2013/04/sharepoint-2013-apps-custom-validation.html

* http://www.c-sharpcorner.com/article/pre-save-action-on-document-libraries-in-sharepoint-2013-and/

Getting Started with Web API Tutorial

noreply@blogger.com (Anonymous) — Mon, 27 Mar 2017 16:30:00 +0000

Getting Started with ASP.NET Web API

Web API Routing

Working with Data in ASP.NET Web API

CASE STATEMENT IN WHERE CLAUSE USING SELF JOIN

noreply@blogger.com (Anonymous) — Fri, 24 Mar 2017 14:30:00 +0000

Sometimes it's possible that single table contains multiple logic. Generally we will use the self join to achieve the result but sometimes it's possible based on the some condition you need to join the self table. Is it possible in Single Query ?

Demo

/****** Object:  Table [dbo].[CircularRef]    Script Date: 3/24/2017 3:13:45 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[CircularRef](
 [ID] [int] IDENTITY(1,1) NOT NULL,
 [DisplayName] [varchar](50) NULL,
 [ParentID] [int] NULL,
 [ContainsValue] [varchar](50) NULL,
 [Notes] [varchar](50) NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

  -- Test Data
  /*

  ID DisplayName  ParentID ContainsValue
   1 BigBoss      NULL     Yes
   2 Boss      1         NULL
   3 Employee  1         Yes
   4 Independent  NULL     NULL

  */

-- CASE STATEMENT IN WHERE CLAUSE
SELECT CR1.* 
FROM [CircularRef] CR1 Inner join [dbo].[CircularRef] CR2 WITH (nolock)
 ON CR1.ID = CR2.ID
LEFT OUTER JOIN [CircularRef] AS CR3 WITH (nolock)
ON CASE WHEN CR1.ContainsValue IS NOT NULL THEN CR2.ID
     WHEN CR2.ParentID IS NOT NULL THEN CR2.ParentID
    ELSE CR2.ID END = CR3.ID
where CR1.ID=2 --- Change the Value and you can see the result

PowerShell Script for Split the Large File Into Small Files

noreply@blogger.com (Anonymous) — Wed, 22 Feb 2017 11:41:00 +0000

How to use: Attached Powershell script will Split the large files into the multiple small files based on the number of lines required in the each file.Place the large file in the SOURCELOCATION folder.Create an SPLITFILELOCATION and MOVEFILELOCATION folder. Copy the Powershell script and run in Windows PowerShell Console. Files will be created based on the line numbers.

#split File Functionality

$sw = new-object System.Diagnostics.Stopwatch
$sw.Start()
$todaysdate =  (Get-Date).ToString('yyyyMMdd_hhmmss')  # Todays Date
$SourceFileName="TEST_BIGFILE" #Source File Name
$ext = ".csv"   #File Extentsion
$filename = "E:\\SPLITFILES\SOURCELOCATION\" + $SourceFileName + $ext   #Source File location and File Name
$rootName = "E:\\SPLITFILES\SPLITFILELOCATION\SPLIT_FILE_"      # Split File Location 
$moveFileLocation = "E:\\SPLITFILES\MOVEFILELOCATION\" + $SourceFileName + $ext #Move File location and File Name
$renameFileName=$SourceFileName+"_"+$todaysdate+$ext #Rename File
$linesperFile = 100 #Number of Line Records
$filecount = 1
$reader = $null
if (Test-Path $filename)
{
try{
$reader = [io.file]::OpenText($filename)
try{
"Creating file number $filecount"
$writer = [io.file]::CreateText("{0}{1}_{2}{3}" -f ($rootName,$todaysdate,$filecount.ToString("000"),$ext))
$filecount++
$linecount = 0
while($reader.EndOfStream -ne $true) {
"Reading $linesperFile"
while( ($linecount -lt $linesperFile) -and ($reader.EndOfStream -ne $true)){
$writer.WriteLine($reader.ReadLine());
$linecount++
}
if($reader.EndOfStream -ne $true) {
"Closing file"
$writer.Dispose();
"Creating file number $filecount"
$writer = [io.file]::CreateText("{0}{1}_{2}{3}" -f ($rootName,$todaysdate,$filecount.ToString("000"),$ext))
$filecount++
$linecount = 0
}
}
} finally {
$writer.Dispose();
}
} finally {
$reader.Dispose();
}
Write-Host "Move File Started to " $filename $moveFileLocation
Move-Item $filename $moveFileLocation
Write-Host "Rename File " $moveFileLocation+"\"+$SourceFileName + $ext $renameFileName
Rename-Item $moveFileLocation $renameFileName

}
else
{
Write-Host "No File Found to Process " $filename 
}
$sw.Stop()
Write-Host "Split complete in " $sw.Elapsed.TotalSeconds "seconds"

=========================================

Create a Batch File For Split File

PowerShell -NoProfile -ExecutionPolicy Bypass -Command "& 
'E:\\SPLITFILES\SplitFilePowerShellCommands\SplitFileScript.ps1'"
pause

Achieved Level 4 MileStone For Google Local Guide

noreply@blogger.com (Anonymous) — Sun, 18 Dec 2016 03:46:00 +0000

Best SQL Queries

noreply@blogger.com (Anonymous) — Mon, 04 Apr 2016 11:52:00 +0000

Use TransactionError

SELECT * FROM DuplicateValues

-- SOLUTION 1: DELETE DUPLICATE VALUE 
DELETE FROM DuplicateValues
WHERE ID IN (
SELECT Min(ID)
FROM DuplicateValues
Group By Name
Having Count(Name) > 1)
GO
-- SOLUTION 2 : DELETE DUPLICATE VALUE 
SELECT *
from DuplicateValues A where ID != (select MIN(ID) from DuplicateValues B where  a.Name=b.Name);

-- Solution 1 : Display Comma Seprated List

SELECT E.State, STUFF((SELECT  ',' + City
            FROM StateCityComb EE
            WHERE  EE.State=E.State
            ORDER BY City
        FOR XML PATH('')), 1, 1, '') AS CityList
FROM StateCityComb E
GROUP BY E.State

-- 2 Min Salary
select distinct Salary from DuplicateValues a  where 2 >= (select count(distinct Salary) from DuplicateValues b  where a.Salary >= b.Salary);

-- Find the Difference Between two Dates
DROP TABLE #TEMP
SELECT * INTO #TEMP FROM(
SELECT 1 As EmpID,'Developer' As Position,'2012-10-10' As UpdateDate
UNION 
SELECT 1 As EmpID,'Sr. Developer' As Position,'2013-10-10' As UpdateDate
UNION 
SELECT 1 As EmpID,'Tech Lead' As Position,'2014-12-12' As UpdateDate
UNION 
SELECT 2 As EmpID,'QA' As Position,'2012-10-10' As UpdateDate
UNION 
SELECT 2 As EmpID,'SR.QA' As Position,'2014-10-10' As UpdateDate
)
As TEmp

SELECT A.EmpID,A.Position,A.UpdateDate,DATEDIFF("D",CONVERT(datetime,A.UpdateDate),MIN(CONVERT(datetime,B.UpdateDate))),
CONVERT(VARCHAR(20),(MIN(CONVERT(datetime,B.UpdateDate)) - CONVERT(datetime,A.UpdateDate)),120)
FROM #TEMP A LEFT JOIN #TEMP B
 ON B.EmpID=A.EmpID AND B.UpdateDate > A.UpdateDate
GROUP BY A.EmpID,A.Position,A.UpdateDate

SELECT A.EmpID,
 A.Position,
 A.UpdateDate,
 ( SELECT CASE WHEN ISNULL(DATEDIFF("DAY",CONVERT(datetime,A.UpdateDate),MIN(CONVERT(datetime,B.UpdateDate))),'') IS NULL THEN GetDate()
     ELSE  ISNULL(DATEDIFF("DAY",CONVERT(datetime,A.UpdateDate),MIN(CONVERT(datetime,B.UpdateDate))),'')
     END
 FROM #TEMP B 
 WHERE A.EmpID=B.EmpID AND B.UpdateDate > A.UpdateDate) As DiffColumn
FROM #TEMP A
GROUP BY A.EmpID,A.Position,A.UpdateDate

-- Allocate position to Students of a class based upon their marks, if same marks same position should be applied
select 'A' [class], 80 [marks], 'manoj' stuName
into #TempStudent
UNION
select 'A', 70 [marks],'harish' stuName
UNION
select 'A', 80 [marks],'kanchan' stuName
UNION
select 'A', 90 [marks],'pooja' stuName
UNION
select 'A', 90 [marks],'saurabh' stuName
UNION
select 'A', 50 [marks],'anita' stuName
UNION
select 'B', 60 [marks],'nitin' stuName
UNION
select 'B', 50 [marks],'kamar' stuName
UNION
select 'B', 80 [marks],'dinesh' stuName
UNION
select 'B', 90 [marks],'paras' stuName
UNION
select 'B', 50 [marks],'lalit' stuName
UNION
select 'B', 70 [marks],'hema' stuName
 
select * from #TempStudent

SELECT class,marks,stuName,
ROW_NUMBER() OVER (order By marks Desc) RowNumber,
RANK() over (order by Marks Desc) RankPosition
FROM #TempStudent

--Rank the Position Class wise
SELECT class,marks,stuName,
ROW_NUMBER() OVER (order By marks Desc) RowNumber,
RANK() over (partition by class order by Marks Desc) RankPosition
FROM #TempStudent

-- Student Class Avg , Sum, Max
select class, stuName, marks,
    AVG(marks) over(partition by class) AS [avg],
    SUM(marks) over(partition by class) AS [sum],
    MIN(marks) over(partition by class) AS [max],
    MAX(marks) over(partition by class) AS [min],
    COUNT(marks) over(partition by class) AS [count],
    STDEV(marks) over(partition by class) AS [ST_Dev],
    VAR(marks) over(partition by class) AS [VAR]
from #TempStudent

-- Identify the second highest salary from emp table having salary related data.
;WITH TCTE AS
(
SELECT SALARY,DENSE_RANK() OVER(order by SALARY Desc) RANKSALARY
FROM Customers
)

SELECT *
FROM TCTE A
WHERE A.RANKSALARY=2

-- 
SELECT TOP (1) SALARY FROM
(
    SELECT DISTINCT TOP (2) Salary FROM Customers ORDER BY Salary DESC
) AS Customers ORDER BY Salary

-- SELECT ALL THE EVEN RECORDS
Select * from Product where ProductID % 2 = 0 
-- SELECT ALL THE ODD RECORDS
Select * from Product where ProductID % 2 = 1

Scalar Function Used Multiple Times In Query ... will Impact Performance

noreply@blogger.com (Anonymous) — Thu, 26 Nov 2015 15:30:00 +0000

If you can see the below query I have used scalar function multiple times in the query.When we used scalar function multiple times it will impact the overall execution of the query.

Sample Query:

-- Scalar function Used Multiple Times in Query
SELECT 
 CASE WHEN [isValidEmailTableValue](Email) = 1 THEN 'Good Email Address' 
   WHEN [isValidEmailTableValue](Email) = 0 THEN 'Bad Email Address'  
 END As EmailOutput,
FROM CUSTOMER WITH (NOLOCK)

How to avoid the above situation and try to remove the multiple uses of the scalar function. Same above query I have generated without using a scalar function.

-- Avoid to use Same scalar function multiple times in Query
SELECT 
 CASE WHEN EmailFun.EmailValue = 1 THEN 'Good Email Address' 
   WHEN EmailFun.EmailValue = 0 THEN 'Bad Email Address'  
 END As EmailOutput,
FROM CUSTOMER WITH (NOLOCK)
CROSS APPLY  [isValidEmailTableValue](Email) EmailFun -- Table Value Function Used as a Table

Tutorial: Big Data Analytics: Concepts, Technologies, and Applications

noreply@blogger.com (Anonymous) — Fri, 30 Oct 2015 15:30:00 +0000

After a long time find a nice article on BigData. Give the brief introduction on What is Big Data, Big Data Sources, Big Data Anayltics, Example of Big Data Analytics and other useful concepts of Big Data ....

There are many unresolved queries you can find the answers in the attached PDF.

Tutorial: Big Data Analytics: Concepts, Technologies, and Applications

Download PDF File

Replace sp_Who2 with Other Approach

noreply@blogger.com (Anonymous) — Wed, 21 Oct 2015 11:29:00 +0000

Instead of using sp_who2 we can use the below sql statement to identify the lock etc...

SELECT  SUBSTRING(dest.text, ( der.statement_start_offset / 2 ) + 1,
                  ( CASE der.statement_end_offset
                      WHEN -1 THEN DATALENGTH(dest.text)
                      ELSE der.statement_end_offset
                           - der.statement_start_offset
                    END ) / 2 + 1) AS querystatement ,
        deqp.query_plan ,
        der.session_id ,
        der.start_time ,
        der.status ,
        DB_NAME(der.database_id) AS DBName ,
        USER_NAME(der.user_id) AS UserName ,
        der.blocking_session_id ,
        der.wait_type ,
        der.wait_time ,
        der.wait_resource ,
        der.last_wait_type ,
        der.cpu_time ,
        der.total_elapsed_time ,
        der.reads ,
        der.writes
FROM    sys.dm_exec_requests AS der
        CROSS APPLY sys.dm_exec_sql_text(der.sql_handle) AS dest
        CROSS APPLY sys.dm_exec_query_plan(der.plan_handle) AS deqp;
GO

Thank you for sharing the post : https://www.simple-talk.com/sql/t-sql-programming/top-10-most-common-database-scripts/

SPARSE COLUMN

noreply@blogger.com (Anonymous) — Wed, 26 Aug 2015 15:00:00 +0000

When you column contains more null values then you can use sparse keyword for reduce the storage space.

E.g. In your table contains 1000 rows , out of 1000 rows more than 700 rows contain null values then you can use the sparse column to reduce the database space. Using a sparse column you can also reduced the index size.

CREATE TABLE Student_sparse (

   STUDENTID INT IDENTITY(5001,1) PRIMARY KEY,

   SSN CHAR(9) NOT NULL,

   TITLE CHAR(10) SPARSE NULL,

   FIRSTNAME VARCHAR(50) NOT NULL,

   MIDDLEINIT CHAR(1) SPARSE NULL,

   LASTNAME VARCHAR(50) NOT NULL,

   EMAIL CHAR(50) SPARSE NULL)

GO

P.S : Do not use sparse column if column contains very less null values.

More details please refer : https://www.simple-talk.com/sql/t-sql-programming/null-friendly-using-sparse-columns-and-column-sets-in-sql-server/

Impact of NULL Values in SQL Server

noreply@blogger.com (Anonymous) — Wed, 26 Aug 2015 10:53:00 +0000

Nice article written on NULL values . How to result will change if your column contains NULL value.

https://www.simple-talk.com/sql/t-sql-programming/how-to-get-nulls-horribly-wrong-in-sql-server/

Performance Impact on Cluster Index and Data Types

noreply@blogger.com (Anonymous) — Thu, 13 Aug 2015 08:59:00 +0000

Effective Clustered Indexes - https://www.simple-talk.com/sql/learn-sql-server/effective-clustered-indexes/
Performance Considerations of Data Types - http://sqlfool.com/content/PerformanceConsiderationsOfDataTypes.pdf

Rules for Improve SQL Server Stored Procedure Performance

noreply@blogger.com (Anonymous) — Wed, 12 Aug 2015 17:00:00 +0000

Call stored procedure using its fully qualified name.

The complete name of an object consists of four identifiers: the server name ( Optional Only for linked server ), database name, owner name, and object name. An object name that specifies all four parts is known as a fully qualified name. Using fully qualified names eliminates any confusion about which stored procedure you want to run and can boost performance because SQL Server has a better chance to reuse the stored procedure's execution plans if they were executed using fully qualified names.

Use IF EXISTS (SELECT 1) instead of (SELECT *):

To check the existence of a record in another table, we uses the IF EXISTS clause. The IF EXISTS clause returns True if any value is returned from an internal statement, either a single value “1” or all columns of a record or complete recordset. The output of the internal statement is not used. Hence, to minimize the data for processing and network transferring, we should use “1” in the SELECT clause of an internal statement.

Use the sp_executesql stored procedure instead of the EXECUTE statement.

The sp_executesql stored procedure supports parameters. So, using the sp_executesql stored procedure instead of the EXECUTE statement improve the re-usability of your code. The execution plan of a dynamic statement can be reused only if each and every character, including case, space, comments and parameter, is same for two statements.

Use TRY-Catch for error handling
Optimize table access with NOLOCK
Avoid implicit conversation

implicit conversions prevent an index seek
Always be alert for implicit conversions, particularly when there are character strings storing numeric keys.
This problem when varchar columns are compared to nvarchar columns.
Fixing the problem is straight forward, just make sure you are performing the comparison on like data types.

Avoid nchar and nvarchar

only use nchar and nvarchar if there is a special characters we are storing.

Avoid * in SELECT statement

Practice to avoid * in Select statement since SQL Server converts the * to columns name before query execution. One more thing, instead of querying all columns by using * in select statement, give the name of columns which you required.

Avoid Cursors
Keep Transaction small

Practice to keep transaction as small as possible since transaction lock the processing tables data during its life. Some times long transaction may results into deadlocks.

Create Clustered and Non-Clustered Indexes

Practice to create clustered and non clustered index since indexes helps in to access data fastly. But be careful, more indexes on a tables will slow the INSERT,UPDATE,DELETE operations. Hence try to keep small no of indexes on a table.

Use table variables or temporary tables based on the use.

The second major difference is that any procedure with a temporary table cannot be pre-compiled, while an execution plan of procedures with table-variables can be statically compiled in advance. Pre-compiling a script gives a major advantage to its speed of execution. This advantage can be dramatic for long procedures, where recompilation can be too pricy.
Though Table variable was updated within the transaction, it is not a part of the transaction itself. If Temp variable was updated within the transaction,it's the part of the transaction.
The data set is fairly large a temporary table is the best option.

To help identify performance problems with Stored Procedures, use the SQL Server’s Profiler Create Trace Wizard to run the “Profile the Performance of a Stored Procedure” trace to provide you with the data you need to identify poorly performing stored procedures.
Check Query Execution plan

Error while setting transaction isolation level SERIALIZABLE IN DDL Command

noreply@blogger.com (Anonymous) — Thu, 11 Jun 2015 11:24:00 +0000

DDL operations and transactions on replicated tables may fail when serializable isolation level is requested. This is because replication queries use hints that may be incompatible with serializable isolation level.

Database Isolation Level Information :

https://technet.microsoft.com/en-us/library/ms189122(v=sql.105).aspx

SQL Where Clause : Write boolean logic to satisfied the multiple condition

noreply@blogger.com (Anonymous) — Wed, 13 May 2015 14:30:00 +0000

Scenario : For example if we have a Single Update statement and If we want to satisfied some condition based on some values.But at the same time this condition is not true if value is different than above condition should not applied.

UPDATE TEST

SET Salary=Salary+5000

WHERE Department='ALL'

AND (( JoinDate >= GetDATE()-365 AND Grade='C')

OR Grade<> 'C')

AND EmpStatus='ACTIVE'

Above query you can see one single boolean expression logic will satisfied both the condition.

TRY_CONVERT FUNCTION

noreply@blogger.com (Anonymous) — Mon, 30 Mar 2015 14:00:00 +0000

Problem : Do to the explicit conversation using CAST OR CONVERT function , sometimes it's possible that you have passed the value to the conversation is not an appropriate value for that conversation. It will return the conversion failed error.

SELECT CONVERT(INT,'034A')

-- Output

-- Conversion failed when converting the varchar value '034A' to data type int

Solution : To overcome for above issue you can use the TRY_CONVERT function for explicit DataConversation where you can check the datatype also before converting the value.

SELECT  TRY_CONVERT(INT,'012A')



SELECT 'Integer Value Exist' WHERE TRY_CONVERT(INT, '12') IS NOT NULL

-- OutPut

-- Integer Value Exist

NOT IN CONDITION RETURNS EMTPTY RESULT SET

noreply@blogger.com (Anonymous) — Wed, 18 Mar 2015 08:56:00 +0000

NOT IN query returns the empty result means NULL value exist in the list of the SubQuery.You need explicitly exclude them using IS NOT NULL Syntax.

SELECT *
FROM PurchaseOrder 
WHERE PurchaseOrderID NOT IN ( SELECT  PurchaseOrderID FROM PurchaseOrderDetail
WHERE PurchaseOrderID IS NOT NULL )

Reason behind writing IS NOT NULL condition in Subquery is that It will evaluate the expression based truth tables.In NULL condition what will happen the expression is Unknown state. It will ignore other records also.

NULLIF Function

noreply@blogger.com (Anonymous) — Wed, 11 Mar 2015 15:00:00 +0000

Definition : The NULLIF function takes two arguments. If the two arguments are equal, then NULL is returned. Otherwise, the first argument is returned. The syntax for NULLIF is as follows: NULLIF ("expression 1", "expressions 2")
Real world example of NULLIF : If you want to compare column with empty string or null condition in SQL Server then generally we are write two condition with OR operator.

Sample : SELECT  COLUMN1,COLUMN2 
  FROM TABLE1 
 WHERE ( COLUMN1 IS NULL OR COLUMN1 = ‘’)

Instead of writing two condition you can use NULLIF function and write the Single condition.

Sample : SELECT  COLUMN1,COLUMN2 
  FROM TABLE1 
                 WHERE NULLIF (COLUMN1,’’) IS NULL

Discontinued TEXTand NTEXT data type in the Next Version Of SQL Server

noreply@blogger.com (Anonymous) — Thu, 29 May 2014 15:30:00 +0000

Advantage to use navarchar(max) over text data type :

Use the string functions in navarchar(max) data type.
2 The default setting for NVARCHAR(MAX) is to store its text value in the table structure, unless the text is over 8,000 bytes at which point it behaves like an NTEXT and stores the text value in the LOB , and stores a pointer to the text in the table.
3 SQL Server 2014 ntext and text will be Discontinued features.
You can easily convert text to navarchar(max) column.
For performance reasons and future support it is advisable to change it to navarchar(max).

Migrate FROM SQL Server 2008 to 2012 -Understand the terms Discontinued features and Deprecated features properly

noreply@blogger.com (Anonymous) — Tue, 27 May 2014 17:30:00 +0000

Once a feature appears on the list, it moves from bottom to the top, i.e. it is first marked as “Deprecated” and then “Discontinued”. We know of “Breaking change” comes later on in the product life cycle.

What this means is that if you want to know what features would not work with SQL Server 2012 (and you are currently using SQL Server 2008 R2), you need to refer the list of breaking changes and discontinued features in SQL Server 2012.

Courtesy: http://blog.sqlauthority.com/2012/05/18/sql-server-thinking-about-deprecated-discontinued-features-and-breaking-changes-while-upgrading-to-sql-server-2012-guest-post-by-nakul-vachhrajani/