MVDBA (Mike Vessey)


Technical Article

move all indexes to a secondary file group

Move all (or chosen) standard indexes from your primary file group to a secondary file group (hopefully located on a seperate array)excludes clustered indexes, statistics and indexes associated with a primary keywhen you run it - set the debug to 1 to identify what the script will move, set it to 0 to actually perform […]

(3)

You rated this post out of 5. Change rating

2006-06-19 (first published: )

5,463 reads

Technical Article

2005 readiness

A script to test your database for 2005 readiness.these features are as described by the SQL 2000 BPA, however this script will run on SL 6.5,7,2000Please note that this is not a guarantee of readiness, however it is an indication that there are issues you may have to resolve to run your databases in 2005

You rated this post out of 5. Change rating

2006-06-02 (first published: )

848 reads

Blogs

Stupid Things I Did With AI: ASCII Art

By

I ran across this article recently (https://www.gatesnotes.com/meet-bill/source-code/reader/microsoft-original-source-code) and it has a great opening piece...

Simple Talks Podcasting in 2026

By

I’m in the UK today, having arrived this morning in London. Hopefully, by this...

SSMS 22 still inserting tabs instead of spaces

By

I’m not trying to start up a debate whether you should use tabs or...

Read the latest Blogs

Forums

Cumulative Update 23 - KB5074819 - Database Mail - No longer working.

By ChrisRNZ

Hi there, Has anyone else had any trouble with Database Mail in Cumulative Update...

Script Task execution error with HTTP request

By Bhagat

I have a script task that tries to execute a HTTP request, which seems...

SQL Server 2025 Standard Developer Edition

By Johan Bijnens

Comments posted to this topic are about the item SQL Server 2025 Standard Developer...

Visit the forum

Question of the Day

URL Safe or Not?

If I use BASE4_ENCODE() in SQL Server 2025, is the output URL Safe by default?

See possible answers