Select Page

Getting friendly with MERGE

Here’s a simple example of how to use MERGE. I’ll do a follow up post on this later. SET NOCOUNT ON; /* TARGET TABLE */ DECLARE @Movies TABLE ( id INT IDENTITY(1,1) PRIMARY KEY CLUSTERED ,Title VARCHAR(20) ,Qty INT NOT NULL ,CreateDate DATETIME...

Get-WmiObject Performance

If you are new to PowerShell and have searched through the “google-verse” you’ll likely find millions of examples with most if not all filtering the results via “WHERE” cmdlet. One thing I noticed today while conducting research on...



SQL Server DBA.