Ramunas Balukonis

Drop Indexes

This script drop all indexes from table, including Primary Key contraint. First it del nonclustered indexes, then clustered and at last - drops PK contraint. This scirpt is useful, when you need drop all indexes, like when doing ETL process.

4 (1)

2004-03-17

523 reads

Blogs

A simple powershell script to look up server hardware and OS information

By

This is a simple powershell script to query and display hardware and OS information...

Collecting Server Performance Metrics: Performance Monitor

By

Whether you’re a DBA/administrator looking to tune a server, planning for hardware updates, or...

Introduction to SQL Server Execution Plans

By

Watch this week’s episode on YouTube! I nearly always use execution plans as the...

Read the latest Blogs

Forums

How to send queued emails

By dubem1-878067

After an upgrade,   sql server stopped sending emails.   Problem is not solved but during...

TLS 1.2 and Database mail

By miapjp

Hi, We use office 365, and just recently received an email from them saying...

Left join not pulling all from left table

By jeffshelix

T has 57,000 distinct rows Z has over a million.  I did row over...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers