You'd think I'd have learned...

Question

You'd think I'd have learned...

Viewing 15 posts - 16 through 30 (of 46 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323518 More actions · Answer 1

clicking "Debug" instead of "Execute" more times than I can count.

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!

Ray K SSC-Dedicated Points: 31163 More actions · Answer 2

Brandie Tarvin (10/18/2010)
Ray K (10/18/2010)
I don't make mistakes! I'm perfect! 😀
You've heard the old adage, right?
If you're not making mistakes, you're not actually working. @=)

Was wondering what kind of responses I'd get!

I was actually thinking about another adage: "Nobody's perfect, and since I'm nobody . . . "

:hehe:

+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/

grahamc SSCertifiable Points: 6762 More actions · Answer 3

Lowell (10/18/2010)
clicking "Debug" instead of "Execute" more times than I can count.

I do that a fair bit as well :hehe:

Brandie Tarvin SSC Guru Points: 173061 More actions · Answer 4

Adding an aggregate to previously-coded statements and forgetting to add a Group By.

DOH.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

jcrawf02 SSC-Insane Points: 24198 More actions · Answer 5

Used to be executing in the wrong database, but SQL prompt saves me from that because now I just fully name everything. Same with misspelling commands or column names (like group by, or "claim" ("calim", every frickin' time))

Other than that, does showing up every day to work count? 😉

---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]

"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

Johan Bijnens SSC Guru Points: 135369 More actions · Answer 6

jcrawf02 (10/19/2010)
...but SQL prompt saves me from that because now I just fully name everything. ....

That's very handy when you restore a db on the same server, using a different name .... :sick::sick::sick:

Which data will get selected, reported on, updated ??:crazy:

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me

jcrawf02 SSC-Insane Points: 24198 More actions · Answer 7

ALZDBA (10/19/2010)
jcrawf02 (10/19/2010)
...but SQL prompt saves me from that because now I just fully name everything. ....
That's very handy when you restore a db on the same server, using a different name .... :sick::sick::sick:
Which data will get selected, reported on, updated ??:crazy:

lol I don't have that kind of power, I just writes reports and analyze stuff, so I get to cheat 😉

---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]

"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

Ray K SSC-Dedicated Points: 31163 More actions · Answer 8

All joking about "perfection" aside . . .

Runinng an UPDATE without a WHERE (there's a reason why I always write the WHERE first!!!)
Running an UPDATE before checking to see which database I'm in!

+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/

Daniel Bowlin SSC-Dedicated Points: 34566 More actions · Answer 9

one lesson I have learned...Don't Change ANYTHING on Friday! Just answer easy questions on SQL Server Central

I've known some people that have tried to make this don't make any changes on Monday, Tuesday, Wednesday, Thursday, Friday, Saturday or Sunday.

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 10

Daniel Bowlin (10/19/2010)
one lesson I have learned...Don't Change ANYTHING on Friday! Just answer easy questions on SQL Server Central
I've known some people that have tried to make this don't make any changes on Monday, Tuesday, Wednesday, Thursday, Friday, Saturday or Sunday.

Been there... some client want you to deploy 15 times a week tested or not. I'm sick of working for them :w00t:.

mazzz SSCertifiable Points: 6139 More actions · Answer 11

Typing "waist" instead of "waits"

If only select * from sys.dm_os_waist_stats returned 24" like it used to...

------------------------------------------------------------------------
Bite-sized fiction (with added teeth) [/url]

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 12

SEELCT * FORM ....

CRATE TABEL ....

CRATE IDNEX ...

I love SQLPrompt.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Henrico Bekker One Orange Chip Points: 27652 More actions · Answer 13

Typing "Sel" or "Ins" etc...and pressing Tab, waiting for auto complete...like cmd.....

:pinch:

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 14

Henrico Bekker (10/20/2010)
Typing "Sel" or "Ins" etc...and pressing Tab, waiting for auto complete...like cmd.....
:pinch:

Get SQLPrompt

Type 'SE' *Ctrl-Space* *Enter* -> Select

Or type 'ssf' *Tab* -> SELECT * FROM

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Henrico Bekker One Orange Chip Points: 27652 More actions · Answer 15

GilaMonster (10/20/2010)
Henrico Bekker (10/20/2010)
Typing "Sel" or "Ins" etc...and pressing Tab, waiting for auto complete...like cmd.....
:pinch:
Get SQLPrompt
Type 'SE' *Ctrl-Space* *Enter* -> Select
Or type 'ssf' *Tab* -> SELECT * FROM

got it on my own laptop, but not all other machines used....

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle