If I declare a varchar(1000) for a field and someone enters "hi", I'm wondering how the memory is allocated for it. I was under the impression that varchar2(1000) in Oracle would only allocate space ...

Building on the DATETIMEFROMPARTS, DATETIME2FROMPARTS offers similar functionality, but yields more precise DateTime2 data type, containing fractions of a second to a specified precision. Naturally, ...

I need to query against a column which contains build numbers stored as an NVARCHAR.<BR>Sorting works fine until you get into double-digit versions.<BR><BR>This works ...

In the age of big data, efficiently managing relational databases, particularly SQL Server, may be the single most important issue facing a growing number of CIOs and data center managers. Throughout ...

At a rather muted Microsoft TechEd in Los Angeles in May, the crowds were diminished and the educational content was slimmed down. In the past, SQL Server sessions were so abundant that you'd have ...

Q: We use a lot of distributed transactions and we are now investigating database mirroring to provide high availability to one of our critical databases. During our testing, we discovered that ...

Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement. It’s sometimes difficult to know which SQL syntax to use when ...