During management of SQL server database many times we need to get list all triggers in SQL Server database with table name and table's schema . Following query can be used to get the desired result.

export_sql_server_tables Export list of tables from list of databases using bcp from sql server database. This powershell is created for exporting data from sql server and creating csv files using ...

SQL Server 2005 or later script to generate TRUNCATE statements for all tables. Anyone that has tried this on anything but the most simplistic database has found, as I did, that this won't work.

Any table they reference cannot be dropped without first dropping all of the stored procedures that reference it. Unfortunately normal stored procedures don’t support this option in SQL Server 2014.

Every table in SQL Server contains at least one partition (default partition) even if the table is not explicitly partitioned. -- The T-SQL query below uses the sys.partitions catalog view to capture ...

If screaming speed in data access is the most important thing in your life, SQL Server's durable in-memory, memory-optimized tables are your answer. They were good in SQL Server 2014 and they're even ...

Part of the SQL Server 2022 blog series. The main difference between tempdb and other databases is the workload. With tempdb we are constantly creating and destroying objects such as temp tables. This ...