Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««4,2244,2254,2264,2274,228»»»

Are the posted questions getting worse? Expand / Collapse
Author
Message
Posted Thursday, November 28, 2013 7:38 PM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Yesterday @ 1:54 PM
Points: 675, Visits: 6,815
Turkey and Nap go together very well.
Sad that some stores are starting Black Friday early.
Hope everyone had a great day, both here and abroad.
Post #1518430
Posted Friday, November 29, 2013 4:09 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 8:49 PM
Points: 17,967, Visits: 15,979
Happy Holidays to all



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1518605
Posted Saturday, November 30, 2013 5:56 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 4:16 PM
Points: 31,284, Visits: 15,748
Thanks and a good holiday here. Quiet, with family.

Personally I have no issue with stores opening on Thanksgiving. The first time I worked on the holiday was when I was 12. Spent the next 10-15 years working on that day before I was senior enough to avoid it.

Some people want to work, some need the money, and some work because they're needed.








Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1518669
Posted Saturday, November 30, 2013 6:55 PM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Friday, October 24, 2014 12:43 PM
Points: 4,126, Visits: 3,428
Steve Jones - SSC Editor (11/30/2013)
Thanks and a good holiday here. Quiet, with family.

Personally I have no issue with stores opening on Thanksgiving. The first time I worked on the holiday was when I was 12. Spent the next 10-15 years working on that day before I was senior enough to avoid it.

Some people want to work, some need the money, and some work because they're needed.

... and some people just have to check the daily ingestion because no one else will do it.
Post #1518673
Posted Sunday, December 1, 2013 2:59 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 11:56 PM
Points: 20,806, Visits: 32,739
Revenant (11/30/2013)
Steve Jones - SSC Editor (11/30/2013)
Thanks and a good holiday here. Quiet, with family.

Personally I have no issue with stores opening on Thanksgiving. The first time I worked on the holiday was when I was 12. Spent the next 10-15 years working on that day before I was senior enough to avoid it.

Some people want to work, some need the money, and some work because they're needed.

... and some people just have to check the daily ingestion because no one else will do it.


And some of us work because there is nothing else to do but work.

Actually, Thanksgiving Day was spent in-transit from ISAF HQ to Bagram. We had a non-traditional Thanksgiving Dinner which consisted of Thai food (I had the Crying Tiger).

We are now all working at Bagram after being evicted from ISAF so units moving from Eggers (which was shutting down) had a place to go.

I will say that the food at the DFAC here is SO much better than that served at ISAF.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1518688
Posted Sunday, December 1, 2013 5:35 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, November 24, 2014 4:53 AM
Points: 3,422, Visits: 5,368
Lynn Pettis (12/1/2013)
Revenant (11/30/2013)
Steve Jones - SSC Editor (11/30/2013)
Thanks and a good holiday here. Quiet, with family.

Personally I have no issue with stores opening on Thanksgiving. The first time I worked on the holiday was when I was 12. Spent the next 10-15 years working on that day before I was senior enough to avoid it.

Some people want to work, some need the money, and some work because they're needed.

... and some people just have to check the daily ingestion because no one else will do it.


And some of us work because there is nothing else to do but work.

Actually, Thanksgiving Day was spent in-transit from ISAF HQ to Bagram. We had a non-traditional Thanksgiving Dinner which consisted of Thai food (I had the Crying Tiger).

We are now all working at Bagram after being evicted from ISAF so units moving from Eggers (which was shutting down) had a place to go.

I will say that the food at the DFAC here is SO much better than that served at ISAF.


I've lived in Thailand more than 10 years and I can honestly say I've never seen "Crying Tiger" on the menu. But if it made your Thanksgiving a yummy one Lynn, who am I to quibble.

Happy belated-Turkey day to all!



My mantra: No loops! No CURSORs! No RBAR! Hoo-uh!

My thought question: Have you ever been told that your query runs too fast?

My advice:
INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.


Need to UNPIVOT? Why not CROSS APPLY VALUES instead?
Since random numbers are too important to be left to chance, let's generate some!
Learn to understand recursive CTEs by example.
Splitting strings based on patterns can be fast!
Post #1518722
Posted Sunday, December 1, 2013 5:44 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 11:56 PM
Points: 20,806, Visits: 32,739
dwain.c (12/1/2013)
Lynn Pettis (12/1/2013)
Revenant (11/30/2013)
Steve Jones - SSC Editor (11/30/2013)
Thanks and a good holiday here. Quiet, with family.

Personally I have no issue with stores opening on Thanksgiving. The first time I worked on the holiday was when I was 12. Spent the next 10-15 years working on that day before I was senior enough to avoid it.

Some people want to work, some need the money, and some work because they're needed.

... and some people just have to check the daily ingestion because no one else will do it.


And some of us work because there is nothing else to do but work.

Actually, Thanksgiving Day was spent in-transit from ISAF HQ to Bagram. We had a non-traditional Thanksgiving Dinner which consisted of Thai food (I had the Crying Tiger).

We are now all working at Bagram after being evicted from ISAF so units moving from Eggers (which was shutting down) had a place to go.

I will say that the food at the DFAC here is SO much better than that served at ISAF.


I've lived in Thailand more than 10 years and I can honestly say I've never seen "Crying Tiger" on the menu. But if it made your Thanksgiving a yummy one Lynn, who am I to quibble.

Happy belated-Turkey day to all!


Could just be what this Thai Restaurant calls this particular dish. A very spicy marinated flank steak dish. Not as spicy as the Dances with the Devil dish they also have on the menu.




Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1518724
Posted Sunday, December 1, 2013 5:54 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, November 24, 2014 4:53 AM
Points: 3,422, Visits: 5,368
Lynn Pettis (12/1/2013)
dwain.c (12/1/2013)
Lynn Pettis (12/1/2013)
Revenant (11/30/2013)
Steve Jones - SSC Editor (11/30/2013)
Thanks and a good holiday here. Quiet, with family.

Personally I have no issue with stores opening on Thanksgiving. The first time I worked on the holiday was when I was 12. Spent the next 10-15 years working on that day before I was senior enough to avoid it.

Some people want to work, some need the money, and some work because they're needed.

... and some people just have to check the daily ingestion because no one else will do it.


And some of us work because there is nothing else to do but work.

Actually, Thanksgiving Day was spent in-transit from ISAF HQ to Bagram. We had a non-traditional Thanksgiving Dinner which consisted of Thai food (I had the Crying Tiger).

We are now all working at Bagram after being evicted from ISAF so units moving from Eggers (which was shutting down) had a place to go.

I will say that the food at the DFAC here is SO much better than that served at ISAF.


I've lived in Thailand more than 10 years and I can honestly say I've never seen "Crying Tiger" on the menu. But if it made your Thanksgiving a yummy one Lynn, who am I to quibble.

Happy belated-Turkey day to all!


Could just be what this Thai Restaurant calls this particular dish. A very spicy marinated flank steak dish. Not as spicy as the Dances with the Devil dish they also have on the menu.



You can't get a good steak here either.

Back in the states I used to frequent a Thai restaurant that featured "Chicken Volcano" which was quite popular with my clique. Again, never heard of such a thing here.

I chalk it up to slick marketing.

Essentials of Thai cuisine, at least in Thailand:
- Rice or noodles? khao reu senn
- Chicken, pork, shrimp, crab or fish? Beef available but usually poor quality. gai, moo, kung, poo reu pla (beef=nua which is just plain "meat," probably indicative of the lack of quality, while a cow is referred to as wua - don't ask me why)[/i][/b]
- Spicy or not? phet reu mai phet

Answering those 3 questions usually gets you a decent meal.

Edit: Added Thai transliterations in case anyone's in town without me in tow as an escort. Duck is also phet but with a different tone and also available.



My mantra: No loops! No CURSORs! No RBAR! Hoo-uh!

My thought question: Have you ever been told that your query runs too fast?

My advice:
INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.


Need to UNPIVOT? Why not CROSS APPLY VALUES instead?
Since random numbers are too important to be left to chance, let's generate some!
Learn to understand recursive CTEs by example.
Splitting strings based on patterns can be fast!
Post #1518728
Posted Sunday, December 1, 2013 7:09 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 8:51 PM
Points: 35,606, Visits: 32,190
dwain.c (12/1/2013)
I've lived in Thailand more than 10 years and I can honestly say I've never seen "Crying Tiger" on the menu. But if it made your Thanksgiving a yummy one Lynn, who am I to quibble.


Heh... it's MUCH better than the "Crapping Hamster" dish.


--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1518740
Posted Sunday, December 1, 2013 7:18 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 8:51 PM
Points: 35,606, Visits: 32,190
dwain.c (12/1/2013)
cow is referred to as wua - don't ask me why)[/i][/b]


FINALLY!!! AFTER NEARLY 40 YEARS, AN EXPLANATION!!!! When I was in the service, I had a young lady walk up to me and damn near kill me with a totally unexpected slap that could have knocked a freight train off its tracks. Still seeing stars, my buddies picked me up and asked what I had said to her so I told them...

"Wuuuaaaa! She's cute!".


--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1518741
« Prev Topic | Next Topic »

Add to briefcase «««4,2244,2254,2264,2274,228»»»

Permissions Expand / Collapse