TRUNCATE TABLE master..sysdatabases

...and other neat SQL Server tricks
posts - 55, comments - 60, trackbacks - 14

August 2011 Blog Posts


I received an "ER diagram" from someone enrolled in a "database course" offered by a "professor" at a "university".  This person would like to remain anonymous for the time being, as they are in an important position and don't want certain people to know what information they're providing.  Let's call this person Hal Holbrook. You can find the ERD here.  Go ahead and open it, take a few minutes, really check it out.  I'll wait. Seriously, it's worth your time. There will be a quiz later, and you'd better not fail it. OK, done laughing are you?  I wish I could stop. Disclaimer: all the...

posted @ Tuesday, August 30, 2011 4:17 PM | Feedback (2) | Filed Under [ Stupidness ]

T-SQL Tuesday #21 - Crap!

Adam Machanic's (blog | twitter) ever popular T-SQL Tuesday series is being held on Wednesday this time, and the topic is… SHIT CRAP. No, not fecal material.  But crap code.  Crap SQL.  Crap ideas that you thought were good at the time, or were forced to do due (doo-doo?) to lack of time. The challenge for me is to look back on my SQL Server career and find something that WASN'T crap.  Well, there's a lot that wasn't, but for some reason I don't remember those that well.  So the additional challenge is to pick one particular turd that I really wish I...

posted @ Wednesday, August 10, 2011 6:11 PM | Feedback (0) | Filed Under [ Stupidness ]

Powered by:
Powered By Subtext Powered By ASP.NET