responsibilities

Technical Article

RE: Descending Clustered Index

  • Reply

Grr.. I did a big reply and just lost it.Yes SQL Server organises the rows inside the data pages in physical order, and with no BOL info to the contrary can assume that the data pages are not in physical order. In that case it would not matter if the clustered index was ASC or […]

You rated this post out of 5. Change rating

2004-06-09

Technical Article

log shipping role change not working!

  • Topic

Hello,In a test environment I am trying to change the roles of the database and I am able to run sp_change_primary, sp_change_secondary, and the sp_resolve_logins, but when I go to run the sp_change_monitor it keeps failing with the error:Server: Msg 14442, Level 16, State 1, Procedure sp_change_monitor_role, Line 18 Role change failed. If anyone know why […]

You rated this post out of 5. Change rating

2004-04-01

3 reads

Blogs

Small Data SF 2024

By

I can’t remember how I heard about Small Data SF 2024, but it caught...

A New Word: Moledro

By

moledro – n. a feeling of resonant connection with an author or artist you’ll...

Snowflake + Azure blob

By

Let’s go back to data platforms today and I want to talk about a...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers