SQL Server differences of char, nchar, varchar and nvarchar data types
Sherlee Dizon looks at the basic differences between char, nchar, varchar, and nvarchar, as well as what to be aware of when using each data type.
2016-07-21
5,665 reads
nchar
Generate script to change column length of string datatypes in a DB
This script can be used to generate alter column length of any string data type column(s) in a database.
2011-12-27 (first published: 2011-11-22)
1,155 reads
Rights to view\run jobs
What role or rights do I give a user to be able to see jobs in Enterprise Manager and run them? I just want to give the bare minimum rights for this.I'm using SQL 7 Thanks!
2004-10-21
RE: QOD 17th Nov
Ok, I got it wrong !?!? too. But I will have to join the rest of this posters because "VERSIONING" is something way past that functionality. Can you get rid of just one "VERSION"? I can do that with ANY version-aware product, so I hope the above makes it clear that "Versioning" is not correct […]
2003-11-17
RE: Cycling Those Error Logs
We use the sp_cycle_errorlog. We have not had issues with it. Scheduled tasks have been running for years.
2003-10-27
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers