Since I was not aware of this particular blob column in one of my large core tables (important I suspect some other tables in my environment have column text, image, ntext, etc data types. .
Problem, after some recent SQL Server performance tuning, I noticed that one of my large core tables (important) has a column with a text data type. .
Newer Post, older Post, home, subscribe to: Post Comments (Atom).
Inner join stypes t,.xtype.xtype, where.xtype IN (35, 165, 99, 34, 173).By: Jeremy Kadlec, read Comments, related Tips: More Database Design, new Whitepaper 10 Ways We Can Steal Your Data download now.SQ Service queue, tA Assembly (CLR) DML trigger, tF Table function.AND me NOT like 'sys aND me 'dtproperties aND.xtype 'U'.TR SQL DML Trigger, tT Table type, u User table.In addition, validate with the development team that they are open to changing the data type and length as well as pick their brains in terms of any potential issues prior to testing.Solution, bLOG data types (text, image, ntext, etc) may be a performance and storage issue in your environment especially if they are not needed. .If you notice that queries that have the blog data types are performing poorly, it is worth trying browse upload file html code to understand how the data is used and some alternatives to address the issue. .Conduct some analysis on the tablescolumns to find out an appropriate data type and length.As such, review the following scripts that query the corresponding system objects in SQL Server 2005 and SQL Server 2000 to determine if columns are using a blob data type: SQL Server 2005, select me,.object_id,.object_id, me,.
Contact your development team to find out what data length is supported in the front end and middle tier of the application. .
V View, x Extended stored procedure and I could put those into a case statement, but is there a table I can just join on to lookup that xtype description?
XType on syscolumns, unlike 'xType' in sysObjects, you wont be able to find what exactly those values mean in syscolumns table as in the BOL it is written mentioned as 'For Internal purpose'.Make the application and database changes then test your applications to ensure they functionally operate as expected. .I don't know a ton about it) and so I'd like to build that description into this query without a case statement: select object_name me, length,.xtype from syscolumns c join sysobjects o on where me like 'jobcode' Update, below is the end result after.GO, sQL Server 2000, select me, me,.Types t, oN stem_type_id stem_type_id, where stem_type_id IN (35, 165, 99, 34, 173).I had no idea that this table had a blob (binary large object) data type. .The sysstem table which stores this information is sysTypes.