Use varchar(max) instead of text in SQL Server

databases As you may know on SQL Server a varchar column can hold up to 8000 characters (each row can hold up to 8K, so it depends on the size of other columns), when you need to store more it is common to use the text or ntext datatypes.


This entry was:

Cheat Sheet for SQL Server

databases I have been writing a lot of T-SQL Scripts for SQL Server for a client to migrate to a new database schema. Whenever I get deeply involved in something like that I find that it is handy to create a cheatsheet for all of the things you have to lookup in the docs.


This entry was:

DateFormat for SQL Server

databases Have you ever tried to find a DateFormat or date_format function in SQL Server? Chances are you probably ended up concatenating a bunch of DatePart strings to get the format you are looking for.


This entry was:

Dear SQL Server Enterprise Manager Developer

databases Please add a button to make a column an identity.

You have a button to set as primary key, why do we have to scroll down through 3/4 of the properties, click the plus under "Identity", and then choose "Yes" for such a common operation?

Thank You


This entry was:

foundeo


did you hack my cf?