Alex Lima

Category: Table

December 26, 2010

|

SQL Server, Table

Using sp_tableoption to change “text in row”

sp_tableoption is used to turn on/off features on tables like turn on the text in row feature for datatype text,… READ MORE
September 10, 2010

|

SQL Server, Table

How to list triggers on a database in SQLServer?

Using the following SQL statement, it will list triggers on database. It also prints trigger name, table the trigger is… READ MORE
March 23, 2010

|

General DBA, SQL Server, Table

SQLServer create as (CTAS)

In Oracle there is CREATE TABLE…AS to backup table into a new table and the syntax on SQL Server is… READ MORE

Recent posts

November 19, 2025

Moral Intelligence: The Compass I Try to Live By Every Single Day
November 10, 2025

How to Discover and Build Your GoldenGate REST API Calls
October 18, 2025

My Week at Oracle AI World 2025: Innovation, Connection, and Reflection

Quote of the week

“Control what I can control”
~ Alex Lima

Alex Lima

About

Taking one day at a time.

Follow Us

Blog at WordPress.com.