Adam Kreul | Blog

I recently readMicrosoft’s research paper on Hekaton, the new in-memory database engine in SQL Server 2014. When I first heard...

2013-10-22

2,321 reads

SQL Server Partitioning: Getting Started

Partitioning is a feature that has been around since SQL Server 2005. It allows for users to split a table...

2013-10-12

2,592 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' + '|';