Episode 140: Why data types matter

Episode 140: Why data types matter

They're just numbers, right? A date's a date. It's just string data, who cares? I admit I have posed those questions before and only much later did I understand how complicated it can get. Angela Henry, our guest for today, has heard these same phrases many times before and she chats with us to enlighten us on the issue and ways we can get around it. Perhaps you have heard about terms like SARGable and implicit conversions. This episode seeks to tie these terms to one of the very first decisions you have to make about your data -- the data types.

The show notes for today's episode can be found at http://sqldatapartners.com/2018/06/20/episode-140-why-data-types-matter. Have fun on the SQL Trail!

Avsnitt(287)

Episode 15 Working at a University

Episode 15 Working at a University

Corporate culture is a BIG deal when it comes to job satisfaction, and it is interesting to see how different sectors can be.  Today we talk with Doug Purnell, DBA at Elon College in North Carolina an...

28 Okt 201525min

Episode 14: SQL Server Clustering

Episode 14: SQL Server Clustering

Clustering is a now tried and true technology to help increase the availability of your SQL Server environment.  I talk with Paul Popovich about his experiences with clustering and how his approach ha...

21 Okt 201523min

Episode 13 Apply Yourself

Episode 13 Apply Yourself

I attended Kevin Feasel's SQLSaturday session entitled Apply Yourself and thought it was pretty funny. While not close friends, I have know Kevin for a while and knew he had good stuff. He there sha...

14 Okt 201530min

Episode 12: Database Corruption

Episode 12: Database Corruption

Database corruption is something that will eventually come to all data professionals.  While I have been fortunate to only come across is a handful of times, I was glad that I was able to get back the...

7 Okt 201531min

Episode 11: SQL Server Statistics

Episode 11: SQL Server Statistics

So it turns out an old dog can learn new tricks--or at least that is what happened to me when I chatted with Grant Fritchey from Red Gate software about SQL Server Statistics.  Always taking an opport...

30 Sep 201534min

Episode 10: Test Anxiety and Test Preparation

Episode 10: Test Anxiety and Test Preparation

We mix things up a bit as I chat with Thomas Frank from collegeinfogeek.com about test anxiety and test preparation.  Taking a test can be a big deal and it is always interesting to get other options ...

23 Sep 201532min

Episode 09: Database Automation

Episode 09: Database Automation

Joey D'Antoni has been doing quite a bit with database automation and I caught with him to discuss his experiences about how database automation has helped him be more efficient and have fewer support...

16 Sep 201529min

Episode 08: Database Design

Episode 08: Database Design

I chat will Louis Davidson about database design and get his thoughts on some strategies about how to go about making your design and what tools are available to help you.  It may surprise you that, a...

9 Sep 201533min

Populärt inom Utbildning

rss-bara-en-till-om-missbruk-medberoende-2
historiepodden-se
det-skaver
nu-blir-det-historia
harrisons-dramatiska-historia
johannes-hansen-podcast
allt-du-velat-veta
not-fanny-anymore
rss-viktmedicinpodden
rss-foraldramotet-bring-lagercrantz
roda-vita-rosen
sektledare
i-vantan-pa-katastrofen
sa-in-i-sjalen
rss-max-tant-med-max-villman
alska-oss
rss-sjalsligt-avkladd
rss-om-vi-ska-vara-arliga
rss-basta-livet
sex-pa-riktigt-med-marika-smith