|
|
|
|
-
Jan Novak Commented 1 Months ago through Blogs | 1 Point
My answer is it depends.
If we store NULL value there is no difference of consuming space.
If we store NOT NULL value for:
- char(n) - the storage size is n bytes
- varchar(n) - the storage size is the actual length of the data entered + 2...
|
|
|
|
|
|
|
-
Jan Novak Commented 11 Months ago through Blogs | 1 Point
Hi.
We can parse DBCC OUTPUTBUFFER, but personally I don't like this method. More details are here:
[http://www.sommarskog.se/error-handling-I.html#textretrieve][1]
[1]: http://www.sommarskog.se/error-handling-I.html#textretrieve
Please do...
|
|
|
-
Jan Novak Liked 1 Years ago through Blogs | 1 Point
SQL Server Wait Types are important factors to consider while analyzing performance problems of SQL Server databases. If you notice a particular wait type is occurring too often or for too long, it indicates a problem in most cases. There are several d...
|
-
Jan Novak Liked 1 Years ago through Blogs | 1 Point
Often peple ask this question in the forum. "I created a procedure with proper alignment. But when I wanted to alter the procedure, result of sp_helptext did not keep the original alignment. How do I keep the original format?"
Well. One answer is to ma...
|
-
Jan Novak refreshed 1 Years ago through Blogs | 1 Point
Often peple ask this question in the forum. "I created a procedure with proper alignment. But when I wanted to alter the procedure, result of sp_helptext did not keep the original alignment. How do I keep the original format?"
Well. One answer is to ma...
|