TSQL

Carlos L Chacon
September 15, 2021
No Comments

Episode 233: ScriptDOM

Episode 233: ScriptDOM https://sqldatapartners.com/wp-content/uploads/2021/09/233.png 560 420 Carlos L Chacon Carlos L Chacon https://secure.gravatar.com/avatar/5e3365b6a313f63d0ad1fd6748a46345?s=96&d=mm&r=g September 15, 2021 September 16, 2021

Never heard of ScriptDOM? Neither had we…okay, except Kevin, who obviously knows all. Apparently, the…

Carlos L Chacon
December 22, 2014
No Comments

Updating Default Values for Columns

Updating Default Values for Columns https://sqldatapartners.com/wp-content/themes/crocal/images/empty/thumbnail.jpg 150 150 Carlos L Chacon Carlos L Chacon https://secure.gravatar.com/avatar/5e3365b6a313f63d0ad1fd6748a46345?s=96&d=mm&r=g December 22, 2014 December 29, 2020

To make life a little simpler, a default value can be added to a column…

Carlos L Chacon
December 22, 2014
No Comments

Converting to UTC Time

Converting to UTC Time https://sqldatapartners.com/wp-content/themes/crocal/images/empty/thumbnail.jpg 150 150 Carlos L Chacon Carlos L Chacon https://secure.gravatar.com/avatar/5e3365b6a313f63d0ad1fd6748a46345?s=96&d=mm&r=g December 22, 2014 December 16, 2020

In preparation for a migration to Azure SQL Database, we found we had to adjust…

Carlos L Chacon
September 26, 2014
No Comments

GETUTCDATE Function

GETUTCDATE Function https://sqldatapartners.com/wp-content/themes/crocal/images/empty/thumbnail.jpg 150 150 Carlos L Chacon Carlos L Chacon https://secure.gravatar.com/avatar/5e3365b6a313f63d0ad1fd6748a46345?s=96&d=mm&r=g September 26, 2014 December 29, 2020

I came across a database that stores the execution date in UTC time. I needed…

Carlos L Chacon
August 22, 2014
No Comments

Backup History

Backup History https://sqldatapartners.com/wp-content/uploads/2014/06/SQL-Data-Safe-Logo-website-carousel.png 560 420 Carlos L Chacon Carlos L Chacon https://secure.gravatar.com/avatar/5e3365b6a313f63d0ad1fd6748a46345?s=96&d=mm&r=g August 22, 2014 March 16, 2022

As someone who has helped design systems, I know auditing can take a back seat…

Carlos L Chacon
August 1, 2014
No Comments

We Can Pivot If You Want To

We Can Pivot If You Want To https://sqldatapartners.com/wp-content/themes/crocal/images/empty/thumbnail.jpg 150 150 Carlos L Chacon Carlos L Chacon https://secure.gravatar.com/avatar/5e3365b6a313f63d0ad1fd6748a46345?s=96&d=mm&r=g August 1, 2014 December 29, 2020

So I get that I am a little late to the party here; however, I…

Carlos L Chacon
March 31, 2014
No Comments

Finding Active Heap Tables

Finding Active Heap Tables https://sqldatapartners.com/wp-content/themes/crocal/images/empty/thumbnail.jpg 150 150 Carlos L Chacon Carlos L Chacon https://secure.gravatar.com/avatar/5e3365b6a313f63d0ad1fd6748a46345?s=96&d=mm&r=g March 31, 2014 December 16, 2020

As part of a review of a system, I look for tables without clustered indexes;…

Carlos L Chacon
December 15, 2012
No Comments

Coalesce instead of Max

Coalesce instead of Max https://sqldatapartners.com/wp-content/themes/crocal/images/empty/thumbnail.jpg 150 150 Carlos L Chacon Carlos L Chacon https://secure.gravatar.com/avatar/5e3365b6a313f63d0ad1fd6748a46345?s=96&d=mm&r=g December 15, 2012 December 16, 2020

I was asked to tune a query which was used in an export of registration…

Carlos L Chacon
September 28, 2012
No Comments

Recursive CTE Query

Recursive CTE Query https://sqldatapartners.com/wp-content/themes/crocal/images/empty/thumbnail.jpg 150 150 Carlos L Chacon Carlos L Chacon https://secure.gravatar.com/avatar/5e3365b6a313f63d0ad1fd6748a46345?s=96&d=mm&r=g September 28, 2012 December 16, 2020

A client came to me and had the similar to data set below. Create Table…

Carlos L Chacon
August 31, 2012
No Comments

sp_executesql

sp_executesql https://sqldatapartners.com/wp-content/themes/crocal/images/empty/thumbnail.jpg 150 150 Carlos L Chacon Carlos L Chacon https://secure.gravatar.com/avatar/5e3365b6a313f63d0ad1fd6748a46345?s=96&d=mm&r=g August 31, 2012 December 16, 2020

I don’t normally have a need to do dynamic sql; however, I found myself at…

TSQL

Episode 233: ScriptDOM

Updating Default Values for Columns

Converting to UTC Time

GETUTCDATE Function

Backup History

We Can Pivot If You Want To

Finding Active Heap Tables

Coalesce instead of Max

Recursive CTE Query

sp_executesql

Learn More

What We Do

Say Hello

©2020 SQL Data Partners. All rights reserved.

Learn More

What We Do

Say Hello

©2020 SQL Data Partners. All rights reserved.

SQL Data Partners is Joining

Marathon Consulting

Read more about the transition and what to expect