Born SQL with Randolph West

Phew! There’s a lot to take in with data types, collation, precision, scale, length, and Unicode, and we’re just getting...

2017-03-29

309 reads

Fundamentals of Data Types

Last week, we discussed storing text in a database. This week we will dive deeper into data types. When storing...

2017-03-22

98 reads

I wanted to figure out how big (or approximately how big) my dump file...

This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...

Recently a customer asked if SQL Compare and SQL Data Compare can be used...

I have a table. Structure in script below. I have to compare and see...

I have an application team that is insisting on daily (and for some, weekly)...

i see this in the definition of a linked server on our wh sql...

What does this code return in SSMS 20 from SQL Server 2019?

select '|' + CHAR(0)+'abc' + '|';