TruncateInTeradata

Truncate Table in Teradata

Coming from SQL Server & Oracle, I wanted a quick way in Teradata to truncate all the records from a table.  The issue is the word TRUNCATE is not a … Continue Reading →


IdentityColumnsResults

List All Identity Columns in a Database in SQL Server

Problem: Received a request for a list of all identity columns existing in a database.  The example is from the SQL 2016 sample database: WideWorldImporters SELECT o.name as ‘OWNER’, t.name … Continue Reading →


ListFilestreamDatabases

List FILESTREAM databases in SQL Server

Problem: Received a support ticket requesting help with the FILESTREAM database for a SQL Server.  Was given only the server name.  This server had over 50 databases in the SQL Server … Continue Reading →


logonevent

Teradata Viewing Failed Logon Information

In Teradata, there is a way to view the reason that a username is not authenticating.  Teradata is good about collecting information at the time of authentication.  It can be … Continue Reading →


teradata_password_change02

Changing a Password in Teradata

There are a couple ways to change a user’s password in Teradata.  Two methods covered here are using a SQL statement in Teradata’s SQL Assistant, and the other is using … Continue Reading →


dbscontrol_display

Viewing the DBS Control Records in Teradata

Problem: I was asked about the “MaxLoadTasks” setting in Teradata.  There are a couple of ways to view this information.  In this case I am going to show the command-line … Continue Reading →


Emailed DBCC CHECKDB Output

Email the results of DBCC CHECKDB

Situation: We had a very busy SQL Server, that could not have “DBCC CHECKDB” run during business hours with out impacting others.  I was being asking for the output from … Continue Reading →


BynetDriverInformation

Teradata BYNET driver information

Note: this is being shown on Teradata Express. Working with Teradata support, I was asked for the version of the BYNET drivers.  This is done with a utility called: bam … Continue Reading →


FerretExited

The Teradata Ferret Utility Says It Exited, But It Is Still Running

Problem:  I thought that I had quit the Teradata Ferret utility when I typed “quit”, because the screen displayed “Ferret Exited”.  My problem was I exited the utility with out … Continue Reading →


SSMSinstallComplete

Install SQL Server Management Studio (SSMS) 2016 Without Internet Access

One of my frustrations with SQL Server 2016, is that the SQL Server Management Studio (SSMS) is no longer included with the database instance installation.  It is now has its … Continue Reading →