Apex domains cannot have CNAME records.
Question and response
Question
dig sgvps.net. NS
Answer
sgvps.net. 2 NS ns2.sgvps.net.
sgvps.net. 2 NS ns1.sgvps.net.
Authority
The response has no authority records.
Additional
. 0 OPT ; payload 1232, xrcode 0, version 0, flags 0