Skip to content
TheSQLReport.com

TheSQLReport.com

Resolutions found with SQL Server and other types of databases

Primary menu

  • Home
  • SQL Server
  • Oracle
  • Teradata
  • AIX
  • Linux
  • Windows
  • SQL Saturday Presentations
  • About Me

Category: Teradata

Data Warehousing

Setting A Teradata Maintenance Window – Updated 2021

  • By BlogAdmin
  • 31 December, 2021
  • No Comments

Teradata in a recent design change moved where to set the Maintenance Window with the roll out of their newer equipment. Note: The reason that you would want to set … Continue Reading →

Teradata – Most Currently Updated Stats

  • By BlogAdmin
  • 17 May, 2020
  • No Comments

This is a quick query that I use to check if the on the stats job that ran over night.  Much faster then running the “SHOW STATISTICS” for each table. … Continue Reading →

Teradata chk_node VS nodecheck

  • By BlogAdmin
  • 28 January, 2020
  • No Comments

Teradata systems have a couple of command-line utilities to verify the health of a Teradata node.  Both these command-line utilities are good to run when looking for something like hardware … Continue Reading →

node.check Utility in Teradata

  • By BlogAdmin
  • 28 December, 2019
  • No Comments

The “node.check” utility has been been around for a while with Teradata.  Recently I was working with Teradata’s Hardware Support team, and watched them use this utility to uncover a … Continue Reading →

Teradata – Convert Timestamp to the Month of the Year

  • By BlogAdmin
  • 22 November, 2019
  • No Comments

This one also surprises me that someone has not already posted. The TD_Month_Of_Year function returns an integer value that need to converted to string value.  Careful when using this on … Continue Reading →

Teradata – Convert Timestamp to the Day of the Week

  • By BlogAdmin
  • 22 November, 2019
  • No Comments

This surprises me that someone has not already posted this. The TD_Day_of_Week function returns an integer value that need to converted to string value.  Careful when using this on a … Continue Reading →

Collect Statistics Spool Space Error in Teradata

  • By BlogAdmin
  • 9 October, 2019
  • No Comments

Recently I received an e-mail alert that my collect statistics job had a spool space error (“Failure 2646 No more spool space in…”) for one of the statements it ran … Continue Reading →

Unable to Connect to Teradata from Toad DataPoint with an Active Directory Account

  • By BlogAdmin
  • 8 August, 2019
  • No Comments

A user was unable to connect to Teradata from Toad DataPoint using a Microsoft Active Directory account.  When I looked at the user account in Teradata, it was showing as … Continue Reading →

Stopping & Starting Teradata Viewpoint Services

  • By BlogAdmin
  • 5 November, 2018
  • No Comments

Stopping & Starting the services for Teradata Viewpoint are the same in Teradata Express as they would be on an actual Teradata Viewpoint server.  Recently I needed to do this … Continue Reading →

TERADATA ERROR – DROP DATABASE Failed. 3552:

  • By BlogAdmin
  • 30 September, 2018
  • No Comments

When attempting to drop a database that I created for temporary use, I received the following error when I ran the “DROP DATABASE < database name >” command: DROP DATABASE … Continue Reading →

Posts navigation

Page 1 Page 2 … Page 4 Next

Recommended Blogs

  • James Serra’s Blog Big Data and Data Warehousing
  • TF3604 Blog — Probing the internals of SQL Server
  • SQL Server World
  • Rottengeek?
  • Frugal Fixes
  • Ray Kim’s Blog
  • ClevelandDotNet

Recent Posts

  • Query – Percentage of Physical Memory SQL Server is Currently Using
  • Using Microsoft’s TroubleShootingScript Version 2 (TSSv2) Toolset to Collect Support Information
  • Error: 18452 – login is from an untrusted domain and cannot be used with Windows authentication
  • Excel Error: SSL Provider, error: 0 – The certificate chain was issued…
  • SQL Server – List of All Databases with Compatibility Levels

Archives

  • March 2023
  • February 2023
  • January 2023
  • July 2022
  • February 2022
  • December 2021
  • December 2020
  • August 2020
  • July 2020
  • June 2020
  • May 2020
  • April 2020
  • March 2020
  • February 2020
  • January 2020
  • December 2019
  • November 2019
  • October 2019
  • August 2019
  • July 2019
  • June 2019
  • May 2019
  • April 2019
  • March 2019
  • February 2019
  • January 2019
  • December 2018
  • November 2018
  • October 2018
  • September 2018
  • August 2018
  • July 2018
  • June 2018
  • May 2018
  • April 2018
  • March 2018
  • February 2018
  • January 2018
  • December 2017
  • November 2017
  • October 2017
  • September 2017
  • August 2017
  • July 2017
  • June 2017
  • May 2017
  • April 2017
  • March 2017
  • February 2017
  • January 2017
  • December 2016
  • November 2016
  • October 2016
  • September 2016
  • August 2016
  • July 2016
  • June 2016
  • May 2016
  • April 2016
  • March 2016
  • January 2016
  • December 2015
  • November 2015
  • October 2015
  • September 2015
  • August 2015
  • June 2015
  • May 2015
  • April 2015
  • March 2015
  • February 2015
  • January 2015
  • December 2014
  • November 2014
  • October 2014
  • September 2014
  • August 2014
  • July 2014
  • June 2014
  • May 2014
  • March 2014
  • February 2014
  • January 2014
  • December 2013
  • November 2013
  • October 2013
  • September 2013
  • August 2013
  • June 2013
  • April 2013
  • March 2013
  • January 2013
  • December 2012

Categories

  • AIX
  • Linux
  • Oracle
  • SQL Server
  • Teradata
  • Windows
TheSQLReport.com Copyright © 2023 TheSQLReport.com . All Rights Reserved.
Powered by: WordPress | Theme: Simple Catch