Dwain Camps

Dwain Camps is a seasoned project manager specializing in business solutions delivered through software development and implementation. Because performance often takes the forefront when it comes to customer satisfaction in software applications, his technical focus is in high-performance T-SQL.

Blogs

It’s 2021, so why are you reading this?

By

If you’re reading this, there’s a good chance you’re straight, white, male, and English-speaking....

Daily Coping 20 Jan 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

[Coping] Hidden Wounds

By

Through high school and college, I carried deep wounds due to what was going...

Read the latest Blogs

Forums

Execute As not reading system view

By pdanes

I have a stored procedure with the following: SELECT physical_name FROM sys.master_files Where physical_name...

Find unmatched between 2 tables using field as selection criteria

By McGoo2000

I have the following tables as a example. Table 1 EmpID, LastName, FirstName 1,Smith,John...

update using self-join - confirm it looks at old values

By ztoddw

I'm doing an update using a self-join, and just want to confirm something.  If...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers