Could You Live Like a DBA?

Question

Could You Live Like a DBA?

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

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

Seed Vicious SSC Veteran Points: 297 More actions · Answer 1

yeah! back ups and more back ups... that is the question!

srienstr SSCrazy Points: 2435 More actions · Answer 2

I could think of a few indexes that might be worth adding to the pantry. Though perhaps my wife would be happier if we continue with partitioning on the item_type flag rather than adding the overhead of index maintenance…

Also: Be sure to have all pantry searches be "Select top 1" without an order statement, especially if you leave it in a heap.

Puto me cogitare, ergo puto me esse.
I think that I think, therefore I think that I am.

gg 33882 SSCommitted Points: 1836 More actions · Answer 3

gg 33882

SSCommitted

Points: 1836

July 26, 2013 at 9:56 am

#1636220

Brilliant!! :laugh:

Chris Harshman SSC-Forever Points: 42192 More actions · Answer 4

jjeffryes (7/26/2013)
That was amusing. I expecially liked "Scans." Life is like that.

Of course you realize that it would be more efficient to build your pantry clustered index based on a categorization of items and have alphabetically as a secondary or tertiary sort item, so that you could more easily seek and possibly even do partition elimination. Otherwise you could end up looking for spaghetti sauce, which was actually entered by someone else as pasta sauce and be looking on the wrong shelf entirely.

As a side note, I remember way back when Altavista was a popular search engine it did have some rudimentary expressions it would recognize + and - as keywords to include and exclude from results, and you could put things in "double quotes" to force the search engine to recognize multiple words as one keyword. Most serach engines now seem to ignore those notations or even worse take the + and - as keywords instead of modifiers.

Andrew Coppock SSC Journeyman Points: 95 More actions · Answer 5

Andrew Coppock

SSC Journeyman

Points: 95

July 26, 2013 at 11:18 am

#1636252

This was a fun read! Thanks.

cksid SSC Veteran Points: 284 More actions · Answer 6

cksid

SSC Veteran

Points: 284

July 26, 2013 at 11:20 am

#1636253

Very nicely done.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 7

I really do think google would be easier if I could do this:

select * from closeby_restaurants where cuisine = 'chinese' and distance_from_home <= 2 miles and deliciousness = 'awesome' and service_time = 'quick'

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Revenant SSC-Forever Points: 42467 More actions · Answer 8

SQLRNNR (7/26/2013)
I really do think google would be easier if I could do this:
select * from closeby_restaurants where cuisine = 'chinese' and distance_from_home <= 2 miles and deliciousness = 'awesome' and service_time = 'quick'

I would add

AND MSG = 0

SQLRNNR SSC Guru Points: 281334 More actions · Answer 9

Revenant (7/26/2013)
SQLRNNR (7/26/2013)
I really do think google would be easier if I could do this:
select * from closeby_restaurants where cuisine = 'chinese' and distance_from_home <= 2 miles and deliciousness = 'awesome' and service_time = 'quick'
I would add
AND MSG = 0

Good idea

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

jay-h SSCoach Points: 18816 More actions · Answer 10

SQLRNNR (7/26/2013)
I really do think google would be easier if I could do this:
select * from closeby_restaurants where cuisine = 'chinese' and distance_from_home <= 2 miles and deliciousness = 'awesome' and service_time = 'quick'

open Google up to SQL injection... what could go wrong?

...

-- FORTRAN manual for Xerox Computers --

Miles Neale SSChampion Points: 13147 More actions · Answer 11

Absolute pure gold!

Appreciated every word.

🙂

Not all gray hairs are Dinosaurs!

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 12

SQLRNNR (7/26/2013)
Revenant (7/26/2013)
SQLRNNR (7/26/2013)
I really do think google would be easier if I could do this:
select * from closeby_restaurants where cuisine = 'chinese' and distance_from_home <= 2 miles and deliciousness = 'awesome' and service_time = 'quick'
I would add
AND MSG = 0
Good idea

Jason, shouldn't there be single quotes around the 2 miles? 😛

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Ken SSCoach Points: 17191 More actions · Answer 13

Alvin Ramard (7/26/2013)
SQLRNNR (7/26/2013)
Revenant (7/26/2013)
SQLRNNR (7/26/2013)
I really do think google would be easier if I could do this:
select * from closeby_restaurants where cuisine = 'chinese' and distance_from_home <= 2 miles and deliciousness = 'awesome' and service_time = 'quick'
I would add
AND MSG = 0
Good idea
Jason, shouldn't there be single quotes around the 2 miles? 😛

Maybe miles would be some sort of new keyword for Google SQL? Can't call it G-SQL since that apparently already exists for Gnome.

Excellent post Hakim, very entertaining!

Marcia J SSCertifiable Points: 5649 More actions · Answer 14

Marcia J

SSCertifiable

Points: 5649

July 27, 2013 at 4:52 pm

#1636428

Well done. Greatly enjoyed this article.

quackhandle1975 SSChampion Points: 11055 More actions · Answer 15

Great editorial.

Mind you a true DBA would to be too paranoid to go out at all. :ermm:

qh

[font="Tahoma"]Who looks outside, dreams; who looks inside, awakes. – Carl Jung.[/font]