Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Reason for dropping TEXT, IMAGE data types Expand / Collapse
Author
Message
Posted Tuesday, July 16, 2013 3:18 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, June 24, 2014 12:38 AM
Points: 2,023, Visits: 2,517
All,

what is the reason for dropping TEXT & IMAGE data type from the latest version?

Memory issue ?
Performance issue?
Maintenance issue ?


karthik
Post #1474038
Posted Tuesday, July 16, 2013 3:24 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 8:50 PM
Points: 23,003, Visits: 31,495
karthik M (7/16/2013)
All,

what is the reason for dropping TEXT & IMAGE data type from the latest version?

Memory issue ?
Performance issue?
Maintenance issue ?


These data types have been deprecated since the introduction of SQL Server 2005 and the VARCHAR(MAX), NVARCHAR(MAX), and VARBINARY(MAX) data types.




Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1474039
Posted Tuesday, July 16, 2013 4:15 PM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: 2 days ago @ 2:28 PM
Points: 786, Visits: 691
From where do you have information that SQL 2014 would not support text/ntext/image? They certainly work in CTP1, and there is no information in Books Online, saying that they will be removed.

And as much as I would love to see these ugly bastards go away, I don't think it will happen for a long time. While the types have been deprecated for a long time, Microsoft has not cleaned up their own act. For instance SQL Trace uses these types. And since SQL Trace itself is deprecated, they will not change SQL Trace, so as long SQL Trace is there, the old LOB types will be there.


Erland Sommarskog, SQL Server MVP, www.sommarskog.se
Post #1474328
Posted Friday, August 9, 2013 3:53 AM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Yesterday @ 12:05 AM
Points: 718, Visits: 542
With large-value data types You can define variables that can store large amounts of data, up to 2^31-1 bytes of character, binary, and Unicode data. That was not possible using the text, ntext and image data types from earlier versions of SQL Server.


Post #1482702
Posted Friday, August 9, 2013 4:23 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 9:56 AM
Points: 7,120, Visits: 13,491
T.Ashish (8/9/2013)
With large-value data types You can define variables that can store large amounts of data, up to 2^31-1 bytes of character, binary, and Unicode data. That was not possible using the text, ntext and image data types from earlier versions of SQL Server.



You what?


“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
Exploring Recursive CTEs by Example Dwain Camps
Post #1482710
Posted Sunday, August 11, 2013 11:12 PM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Yesterday @ 12:05 AM
Points: 718, Visits: 542
Text, Ntext, and Image data types are invalid for local variables.
Post #1483138
Posted Monday, August 12, 2013 2:26 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 9:56 AM
Points: 7,120, Visits: 13,491
T.Ashish (8/11/2013)
Text, Ntext, and Image data types are invalid for local variables.


Gosh, where did you read that?


“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
Exploring Recursive CTEs by Example Dwain Camps
Post #1483179
Posted Monday, August 12, 2013 2:35 AM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: 2 days ago @ 2:28 PM
Points: 786, Visits: 691
ChrisM@Work (8/12/2013)
[quote]Gosh, where did you read that?


Maybe in an error message?

DECLARE @a text


Erland Sommarskog, SQL Server MVP, www.sommarskog.se
Post #1483181
Posted Monday, August 12, 2013 3:04 AM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Yesterday @ 12:05 AM
Points: 718, Visits: 542
declare @image1 image
declare @text1 text
declare @ntext1 ntext
declare @varchar2 varchar
declare @nvarchar2 nvarchar
declare @varbinary2 varbinary
declare @varchar1 varchar(max)
declare @nvarchar1 nvarchar(max)
declare @varbinary1 varbinary(max)

First three variable declarations are definitely going to produce an error.

Post #1483196
Posted Monday, August 12, 2013 4:00 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 9:56 AM
Points: 7,120, Visits: 13,491
T.Ashish (8/12/2013)
declare @image1 image
declare @text1 text
declare @ntext1 ntext
declare @varchar2 varchar
declare @nvarchar2 nvarchar
declare @varbinary2 varbinary
declare @varchar1 varchar(max)
declare @nvarchar1 nvarchar(max)
declare @varbinary1 varbinary(max)

First three variable declarations are definitely going to produce an error.



Yes of course they will. But this won't:
declare @image1	varbinary(max)
declare @text1 varchar(max)
declare @ntext1 nvarchar(max)
declare @varchar2 varchar
declare @nvarchar2 nvarchar
declare @varbinary2 varbinary
declare @varchar1 varchar(max)
declare @nvarchar1 nvarchar(max)
declare @varbinary1 varbinary(max)

"Text, Ntext, and Image data types are invalid for local variables." is misleading:

DROP TABLE #TEST
CREATE TABLE #TEST (text1 text)
INSERT INTO #TEST (text1)
SELECT CAST(REPLICATE('A',8000) AS VARCHAR(MAX))
+ CAST(REPLICATE('B',8000) AS VARCHAR(MAX))
+ 'THE END'

SELECT SUBSTRING(CAST(text1 AS VARCHAR(MAX)),16001,7) FROM #TEST



“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
Exploring Recursive CTEs by Example Dwain Camps
Post #1483209
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse