Dinesh's Blog :::: Being Compiled ::::

Showing posts with label Data Type. Show all posts
Showing posts with label Data Type. Show all posts
Monday, February 27, 2017

NULL values consume storage in SQL Server Tables?

›
While we were discussing on data types to be used and null-able columns, a question was raised, asking whether the space is used for NULLs...
Wednesday, February 8, 2017

How do I set the size of SqlParameter of SqlCommand for varchar(max)?

›
If you need to execute a Stored Procedure  that implemented with varchar(max) parameter, using .Net Application , how do you set the size ...
Wednesday, August 3, 2016

Arithmetic overflow error converting expression to data type int - It works for larger number but not for a smaller number

›
One of my colleagues sent me a simple code that has two lines. The first line works without any issue but second throws an error. This is ...
Saturday, March 7, 2015

How to change the data type of a column of a large table

›
Here is another common question appeared in forums, how to change the data type of column, specifically a large table. If you search for i...
›
Home
View web version

About Me

My photo
Dinesh Priyankara
Colombo, Sri Lanka
Dinesh Priyankara (MSc IT) is an MVP – Data Platform (Microsoft Most Valuable Professional) in Sri Lanka with 16 years’ experience in various aspects of database technologies including business intelligence. He has done many local and foreign business intelligence implementations and has worked as a subject matter expert on various database and business intelligence related projects. He is the Founder/Principal Architect of dinesQL (Pvt) Ltd and he consults, teaches and runs training programs on data related solutions and subjects.
View my complete profile
Powered by Blogger.