Aaron Ingold


SQLServerCentral Article

Indexing in SQL Server 2005

How should you approach indexing your database? Do you have a good strategy for deciding which indicies to create and on which columns? Aaron Ingold brings us a great article discussing these very topics that is likely to become a must read for many DBAs.

4.89 (9)

You rated this post out of 5. Change rating

2007-12-24 (first published: )

21,680 reads

Blogs

The Community is YOU, Not Any Organization

By

As I type this, we’re leaving behind spring, and all the amazing events that...

Polyglot Persistence

By

I’ve seen the term polyglot persistence floating around Redgate a bit recently in the...

Six Months!

By

Oh good gosh. Six months without a single blog post. Most important information: I’m...

Read the latest Blogs

Forums

increase in database size

By vsamantha35

Hi All, We have a 2 TB disk to stored of the sql database...

indexes cleanup

By vsamantha35

Hi All, Recently we are having issues with disk space requirements. After monitoring db...

Dropping a Logon Trigger

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Dropping a Logon Trigger

Visit the forum

Question of the Day

Dropping a Logon Trigger

I created this trigger for testing on SQL Server 2022:

CREATE TRIGGER checksteve
ON ALL SERVER 
FOR LOGON  
AS  
BEGIN  
IF ORIGINAL_LOGIN()= N'ARISTOTLE\Steve'
 PRINT 'Steve logged in'
END;  
GO
Now I want to drop it. What do I run?

See possible answers