my *duh* moment of the day

• Lowell

  SSC Guru

  Points: 323518

  More actions

  June 6, 2011 at 1:33 pm

  #74359

  I was looking at the actual execution plans of a slow running view, no big deal.

  So I run a statement like this, and get freaked out because there's TWO rows of "rows affected" statements, pretty clear there must be a database trigger somewhere, right?

  i look in sys.triggers and in master.sys.triggers, and don't see any db/DDL triggers on the Dev server at all...

  So I start wondering if maybe some service broker thing or something fancy like extended events got added....

  at about that time i realize the second execution of (1 row(s) affected) is from the query getting the actual execution plan...

  [facepalm]

  SELECT *

  INTO MyNewTable

  FROM VW_ALL_DA_LOANS

  /*

  (43458 row(s) affected)

  (1 row(s) affected)

  */

  so fess up...what's your *duh* moment of the week?

  Lowell

  ---

  --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

• Grant Fritchey

  SSC Guru

  Points: 398882

  More actions

  June 7, 2011 at 7:13 am

  #1334980

  Haven't had one yet this week, but the week is young for me. Stay tuned, I'm sure to have 3-5 before Friday.

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning

• Stuart Davies

  SSCoach

  Points: 19505

  More actions

  June 7, 2011 at 7:23 am

  #1334992

  Worked on Monday from 7:30 til 17:00 then again from 20:00 til midnight. Back in Tuesday 7:30 till 17:00 have to back in again at 20:00 - don't know when I'll get back home.

  Will most likely post a duh moment on Wednesday - Thursday at the latest.

  -------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
  There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
  I would never join a club that would allow me as a member - Groucho Marx

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  June 7, 2011 at 7:46 am

  #1335015

  Here's one...

  INSERT EXEC failed because the stored procedure altered the schema of the target table.

  Damn copy / paste!

• mister.magoo

  SSC-Forever

  Points: 47174

  More actions

  June 7, 2011 at 8:13 am

  #1335035

  Not done one yet this week, but similar to Stuart, I have already done a double shift yesterday - finishing at 2.30am and doing another double shift today... bound to cock up later when I am due to update a customers system.

  MM
  

  ---

  
  select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

• Forum Etiquette: How to post Reporting Services problems
[/url]
• Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
[/url]
• How to Post Performance Problems - by Gail Shaw
[/url]