vCenter Server fails to start, Purge and Shrink Vcenter SQL Database
In this article, you will learn how to troubleshoot If your vCenter Server fails to start and and manually purge the Vcenter database if required.
2017-02-16
8,236 reads
vCenter
Blogs
The Book of Redgate: What’s Great about Redgate?
By Steve Jones
“I’m sick of hearing about Red Gate.” The first article in the book has...
SQL Server Performance – What IT Leaders Need to Know
By Kevin3NF
IT leaders have a lot on their plates! Budgets, staffing, security, uptime, and keeping...
FREE Window Functions Course (This Month Only!)
Want to really level up your SQL game? I mean, go from good to great? This March...
Forums
Dynamic T-SQL Script Parameterization Using Python
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
Multiple Sequences
Comments posted to this topic are about the item Multiple Sequences
Using SQL Server Stored Procedures with the Django ORM
Comments posted to this topic are about the item Using SQL Server Stored Procedures...
Question of the Day
Multiple Sequences
In SQL Server 2022, I run this code:
CREATE SEQUENCE myseqtest START WITH 1 INCREMENT BY 1; GO CREATE TABLE NewMonthSales (SaleID INT , SecondID int , saleyear INT , salemonth TINYINT , currSales NUMERIC(10, 2)); GO INSERT dbo.NewMonthSales (SaleID, SecondID, saleyear, salemonth, currSales) SELECT NEXT VALUE FOR myseqtest , NEXT VALUE FOR myseqtest , ms.saleyear , ms.salemonth , ms.currMonthSales FROM dbo.MonthSales AS ms; GO SELECT * FROM dbo.NewMonthSales AS nmsAssume the dbo.MonthSales table exists. If I run this, what happens? See possible answers