Dwain Camps (@DwainCSQL) profile picture

Dwain Camps

@DwainCSQL

SQL Performance Evangelist, author on @Simple_Talk and @SQLServerCentrl, rabble rouser, slayer of sacred cows and occasional out-of-the-box thinker.

 Bangkok Thailand
Joined December 2013
  • Tweets303
  • Following128
  • Followers165
8Media
Photo by Dwain Camps (@DwainCSQL)Photo by Dwain Camps (@DwainCSQL)Photo by Dwain Camps (@DwainCSQL)Photo by Dwain Camps (@DwainCSQL)Photo by Dwain Camps (@DwainCSQL)
SQL Server Query Optimization: No Unknown Unknowns sqlmag.com/sql-server/sql-se…
9
7
Find out how to avoid conditional JOINs in T-SQL with @DwainCSQL. ow.ly/RWkdq
3
3
Dwain Camps retweeted
Picard Tips (@PicardTips) profile picture
Picard Tips
@PicardTips6 Apr 2015
Picard management tip: Be realistic about your project timelines. Romulus wasn't built in a day.
5
106
121
What ORMs have taught me: just learn SQL. — by @geoffwozniak wozniak.ca/what-orms-have-ta…
14
16
Some great comments showing up on @DwainCSQL's article on temporal tables. simple-talk.com/sql/t-sql-pr…
1
1
Our @DwainCSQL explains self-maintaining, contiguous effective dates in temporal tables simple-talk.com/sql/t-sql-pr…
2
Our @DwainCSQL is Bowled Over by SQL Functions simple-talk.com/sql/t-sql-pr…
1
It's Time To Get Over That Stored Procedure Aversion You Have > caution. Some swearing zite.to/1Lp1XLf
2
1
Dwain Camps retweeted
Jason Brimhall (@sqlrnnr) profile picture
Jason Brimhall
@sqlrnnr14 Feb 2015
SQLRNNR Daily is out! paper.li/sqlrnnr/1308943349 Stories via @TT_SQLServer @AlanWei1208 @SQLbimler_mack
1
Dwain Camps retweeted
Brent Ozar (@BrentO) profile picture
Brent Ozar@BrentO9 Feb 2015
Replying to @AskSQL
. @AskSQL Start with Erland Sommarskog’s excellent post, Slow in the App, Fast in SSMS: sommarskog.se/query-plan-mys… #sqlhelp – at Central Business District, Denver
3
1
6
#fridaytip - Try using MERGE in SQL rather than INSERT/UPDATE. Nice article from @DwainCSQL via @SQLServerCentrl - sqlservercentral.com/article…
2
1
Dwain Camps retweeted
Simple Talk (@Simple_Talk) profile picture
Simple Talk@Simple_Talk4 Dec 2014
Impressive number of comments on @DwainCSQL's article on his stored procedure solution. ow.ly/Flvye
1
2
When @DwainCSQL's team put most of their app’s business logic in SQL Server, here's what they did: simple-talk.com/sql/t-sql-pr…
1
Two beautiful solutions to the sequences puzzle by @SwePeso and @DwainCSQL: sqlmag.com/t-sql/identifying….
1
5
Dwain Camps retweeted
CommitDBA (@CommitDBA) profile picture
CommitDBA@CommitDBA11 Jul 2014
Calculating and Verifying Check Digits in T-SQL simple-talk.com/sql/t-sql-pr… via @DwainCSQL, @Simple_Talk
1
Another fabulous must-read article from @DwainCSQL: The Performance of Traversing a SQL Hierarchy simple-talk.com/content/arti… #mssql.
1
New from @DwainCSQL - The Performance of Traversing a SQL Hierarchy: ow.ly/wh4uC
2
Dwain Camps retweeted
Phil_Factor (@Phil_Factor) profile picture
Phil_Factor@Phil_Factor3 Apr 2014
Are Table Variables as Good as Temporary Tables in SQL 2014? zite.to/1fNFvMi
2
1
Dwain Camps retweeted
SentryOne (@SentryOne) profile picture
SentryOne@SentryOne26 Mar 2014
.@AaronBertrand does some testing on triggers, showing that INSTEAD OF triggers are worth a look goo.gl/W3v5BQ #sqlserver
2
1
Dwain Camps retweeted
Gail Shaw (@SQLintheWild) profile picture
Gail Shaw@SQLintheWild24 Mar 2014
Just replacing a multi-statement table-valued function with an equivalent in-line function trimmed 400ms and 350 000 reads off a query.
1
2
Load more