Mike Pearson


SQLServerCentral Article

Auto Close and Auto Shrink - Just Don't

New author! Mike Pearson discusses how auto close was at the root of a performance problem he was troubleshooting, how you can check your servers easily, and discusses why both auto close and auto shrink are bad ideas in a production environment.

β˜… β˜… β˜… β˜… β˜… β˜… β˜… β˜… β˜… β˜…

4.78 (9)

You rated this post out of 5. Change rating

2003-05-05

21,916 reads

Technical Article

Get table sizes and rowcounts in MB (for VLDB)

This simple script is based on sp_spacedused, but returns values for all user tables in the database, with information in MB instead of the usual KB - which is useful for large databases.Β  Simply run it in query analyser against the database concerned

β˜… β˜… β˜… β˜… β˜… β˜… β˜… β˜… β˜… β˜…

You rated this post out of 5. Change rating

2002-05-03

727 reads

Blogs

Refreshed in Tuscany

By

I returned last Sat, 15 Jun, from 9 weeks of crazy travel. It wasn’t...

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...

Read the latest Blogs

Forums

Case Statement Optimization

By ralahari

CASE WHEN ( Table1.Column IN (@Parameter1) OR b.cat3 = 1 OR (Table1.Column='XXXX' AND SV.Column...

JOIN with TVP ignoring Index

By planetmatt

I have a table with 35 million rows.Β  I am querying this table by...

increase in database size

By vsamantha35

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

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