Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 47,956 through 47,970 (of 66,712 total)

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

Eirikur Eiriksson SSC Guru Points: 182912 More actions · Answer 1

Luis Cazares (3/27/2015)
In a different order of ideas, I want to share with you my happiness.
Starting on April 21st I'll be working in the US. I'll make a stop at Miami on the 20th to continue my trip on Tuesday. I'll spend some time at Detroit and possibly be changing my location after being assigned a project on-site with a client.
I just can't wait to start my new adventure.

Brilliant Luis!! Good for you!!

😎

Eirikur Eiriksson SSC Guru Points: 182912 More actions · Answer 2

SQLRNNR (3/27/2015)
Brandie Tarvin (3/27/2015)
Eirikur Eiriksson (3/27/2015)
My Friday fun version:rolleyes:
IF EXISTS (SELECT 1 FROM (VALUES(CAST(1 AS BIT))) d (n)) SELECT 1 FROM sys.all_columns X,sys.columns Y,sys.computed_columns Z
AWESOME!!!!!!!
Yes you can certainly get a red circle on them. Eirikur did a great job with those operator percentages as well. It's equally as fun producing a plan that has 19 quintillion rows coming from a 290 row table (with or without xml editing).

Just like any financial planning exercise:-D (read "Godzilla egg")

😎

Sean Lange SSC Guru Points: 286590 More actions · Answer 3

Luis Cazares (3/27/2015)
In a different order of ideas, I want to share with you my happiness.
Starting on April 21st I'll be working in the US. I'll make a stop at Miami on the 20th to continue my trip on Tuesday. I'll spend some time at Detroit and possibly be changing my location after being assigned a project on-site with a client.
I just can't wait to start my new adventure.

Congrats!!!

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

SQLRNNR SSC Guru Points: 281334 More actions · Answer 4

Luis Cazares (3/27/2015)
In a different order of ideas, I want to share with you my happiness.
Starting on April 21st I'll be working in the US. I'll make a stop at Miami on the 20th to continue my trip on Tuesday. I'll spend some time at Detroit and possibly be changing my location after being assigned a project on-site with a client.
I just can't wait to start my new adventure.

Congrats

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

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 5

Luis Cazares (3/27/2015)
In a different order of ideas, I want to share with you my happiness.
Starting on April 21st I'll be working in the US. I'll make a stop at Miami on the 20th to continue my trip on Tuesday. I'll spend some time at Detroit and possibly be changing my location after being assigned a project on-site with a client.
I just can't wait to start my new adventure.

Adventures! Have fun, Luis!

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

Ed Wagner SSC Guru Points: 287026 More actions · Answer 6

Sean Lange (3/27/2015)
Luis Cazares (3/27/2015)
In a different order of ideas, I want to share with you my happiness.
Starting on April 21st I'll be working in the US. I'll make a stop at Miami on the 20th to continue my trip on Tuesday. I'll spend some time at Detroit and possibly be changing my location after being assigned a project on-site with a client.
I just can't wait to start my new adventure.
Congrats!!!

Luis, Congratulations! Is this a permanent move or a temporary assignment? Also, when do you come to Detroit? I know a couple of people (I'm one of them) who would like to meet you for lunch.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Luis Cazares SSC Guru Points: 183706 More actions · Answer 7

Ed Wagner (3/27/2015)
Sean Lange (3/27/2015)
Luis Cazares (3/27/2015)
In a different order of ideas, I want to share with you my happiness.
Starting on April 21st I'll be working in the US. I'll make a stop at Miami on the 20th to continue my trip on Tuesday. I'll spend some time at Detroit and possibly be changing my location after being assigned a project on-site with a client.
I just can't wait to start my new adventure.
Congrats!!!
Luis, Congratulations! Is this a permanent move or a temporary assignment? Also, when do you come to Detroit? I know a couple of people (I'm one of them) who would like to meet you for lunch.

I'll get to Detroit on April 21st and I'll stay at least one month there. Well, technically, I'll be at Northville, MI. I'd love to meet as many people as I can. 🙂

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

jasona.work SSC Guru Points: 50117 More actions · Answer 8

Luis Cazares (3/27/2015)
Ed Wagner (3/27/2015)
Sean Lange (3/27/2015)
Luis Cazares (3/27/2015)
In a different order of ideas, I want to share with you my happiness.
Starting on April 21st I'll be working in the US. I'll make a stop at Miami on the 20th to continue my trip on Tuesday. I'll spend some time at Detroit and possibly be changing my location after being assigned a project on-site with a client.
I just can't wait to start my new adventure.
Congrats!!!
Luis, Congratulations! Is this a permanent move or a temporary assignment? Also, when do you come to Detroit? I know a couple of people (I'm one of them) who would like to meet you for lunch.
I'll get to Detroit on April 21st and I'll stay at least one month there. Well, technically, I'll be at Northville, MI. I'd love to meet as many people as I can. 🙂

Ah, west Detroit! (South Detroit is Windsor, Canada...)

😀

If you don't mind a drive, there's a restaraunt up in Clarkston, Union Woodshop (unionwoodshop.com) that is a *really* good eatery.

Brandie Tarvin SSC Guru Points: 173068 More actions · Answer 9

Luis Cazares (3/27/2015)
GilaMonster (3/27/2015)
Luis Cazares (3/26/2015)
By the way, about the article that Gail posted where they mention a comic book cover. I found that discussion out of place.
Yeah, that protest is stupid.
The reason that Person B's response to that was discussed (and I do know both the author and Person B) is that the reaction wasn't a specific one of 'that protest is stupid' but rather 'they're ruining *everything* for *everyone*' (paraphrased), another massive, useless generalisation that serves to end any conversation you could possibly have
Yes, I understood that the point of quoting him wasn't the protest, but the attitude that person takes on subjects he's against or not interested.
And I thank Brandie for the explanation of the cover being a trigger and should have been handled better.

Luis, I am so sorry. I realized after someone else responded to you what you really meant and I feel kinda silly over posting the whole "but..." reaction thread. My bad.

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.

Brandie Tarvin SSC Guru Points: 173068 More actions · Answer 10

Luis Cazares (3/27/2015)
In a different order of ideas, I want to share with you my happiness.
Starting on April 21st I'll be working in the US. I'll make a stop at Miami on the 20th to continue my trip on Tuesday. I'll spend some time at Detroit and possibly be changing my location after being assigned a project on-site with a client.
I just can't wait to start my new adventure.

WHOOO HOOOO! Welcome to Florida (when you get here). Try not to melt. @=)

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.

Jeff Moden SSC Guru Points: 1004362 More actions · Answer 11

Luis Cazares (3/27/2015)
Ed Wagner (3/27/2015)
Sean Lange (3/27/2015)
Luis Cazares (3/27/2015)
In a different order of ideas, I want to share with you my happiness.
Starting on April 21st I'll be working in the US. I'll make a stop at Miami on the 20th to continue my trip on Tuesday. I'll spend some time at Detroit and possibly be changing my location after being assigned a project on-site with a client.
I just can't wait to start my new adventure.
Congrats!!!
Luis, Congratulations! Is this a permanent move or a temporary assignment? Also, when do you come to Detroit? I know a couple of people (I'm one of them) who would like to meet you for lunch.
I'll get to Detroit on April 21st and I'll stay at least one month there. Well, technically, I'll be at Northville, MI. I'd love to meet as many people as I can. 🙂

Ed and I are definitely planning a meetup with you and we'll do the relatively short drive to Northville. I'll also find out when the local PASS Chapter meeting that we belong to is (it's usually the 2nd Thursday of the month so probably will happen on May 14th) and send you an invitation. If you can't make the drive yourself, one of us will come get you if you want to attend. We usually go out for 12 oz. curls afterwards which includes some good conversation with fellow database wireheads.

If anyone else in the area is interested in that night, send me an email through SSC and I'll be sure to send you the PASS Chapter meeting notice when they make it available and, if there are enough people and Luis is both interested and can make it, I'll reserve tables at Shield's (GREAT PIZZA and BEER as well as other good food) and we'll make an evening of it.

Both Ed and I are very much looking forward to meeting you.

--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.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

SQLRNNR SSC Guru Points: 281334 More actions · Answer 12

Did you guys hear about this awesome new feature in SQL Server called indexed views? It is so awesome that you can create 999 indexes on a view and have faster running queries while at the same time never having to worry about things like disk space (which you would with a table).

This is so freaking awesome!!!

Wait, why are we suddenly out of disk space?

</sarcasm>

Trying to get developers to understand that an indexed view is not the silver bullet they seek and that better tsql has the same perf benefits (as some of these indexed views they are creating) without the disk cost. sheeeeeeeeeeeeeeeeeesh

They just want to keep creating more and more indexed views. So much so they have already doubled the size of their 1TB+ database in the last month.

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

Jeff Moden SSC Guru Points: 1004362 More actions · Answer 13

SQLRNNR (3/27/2015)
Did you guys hear about this awesome new feature in SQL Server called indexed views? It is so awesome that you can create 999 indexes on a view and have faster running queries while at the same time never having to worry about things like disk space (which you would with a table).
This is so freaking awesome!!!
Wait, why are we suddenly out of disk space?
</sarcasm>
Trying to get developers to understand that an indexed view is not the silver bullet they seek and that better tsql has the same perf benefits (as some of these indexed views they are creating) without the disk cost. sheeeeeeeeeeeeeeeeeesh
They just want to keep creating more and more indexed views. So much so they have already doubled the size of their 1TB+ database in the last month.

Heh... LOOK!!!! There's a squirrel!!! 😛

--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.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Ed Wagner SSC Guru Points: 287026 More actions · Answer 14

Jeff Moden (3/27/2015)
SQLRNNR (3/27/2015)
Did you guys hear about this awesome new feature in SQL Server called indexed views? It is so awesome that you can create 999 indexes on a view and have faster running queries while at the same time never having to worry about things like disk space (which you would with a table).
This is so freaking awesome!!!
Wait, why are we suddenly out of disk space?
</sarcasm>
Trying to get developers to understand that an indexed view is not the silver bullet they seek and that better tsql has the same perf benefits (as some of these indexed views they are creating) without the disk cost. sheeeeeeeeeeeeeeeeeesh
They just want to keep creating more and more indexed views. So much so they have already doubled the size of their 1TB+ database in the last month.
Heh... LOOK!!!! There's a squirrel!!! 😛

Yeah, and the squirrel is holding something shiny. Let's all look at that. Wait, why did the database double in size while we were looking at the shiny thing? :w00t:

Everyone wants a magic bullet for everything and they don't accept that everything has a cost. It should all be free, already be done and have no consequences.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

TomThomson SSC Guru Points: 104773 More actions · Answer 15

Brandie Tarvin (3/27/2015)
ChrisM@Work (3/27/2015)
TomThomson (3/27/2015)
dwain.c (3/26/2015)
...
Edit: This query shows the same thing:
IF EXISTS (SELECT 1 FROM (VALUES(CAST(1 AS BIT))) d (n))
SELECT * FROM sys.all_columns;
Which means that it has something to do with the 100% cost calculated for the Constant Scan generated for the IF. The remainder of the query must be getting its costs rated against that.
Add this to the list of SQL Developer interviewee questions...
There are some amusing variants - for example try changing the condition:
😀
Nice one, Tom - it's the simplest yet and on this server I see 27 million % cost for one of the operators :w00t:
Color me confused. Tom's code looks the same as Dwain's.
???

Color me butter-fingered! I meant

IF EXISTS (SELECT 2 FROM (VALUES(CAST(1 AS BIT))) d (n))

SELECT * FROM sys.all_columns;

Numbers not quite so big! But look at the actual execution plan (not the estimated one, which doesn't differ from the SELECT 1 case). 95% of the work is in the branch which isn't needed. It's a nice illustration of why (apart from generating spurious run-time errors which can be a nightmare to get rid of) an eager mode of evaluation is unacceptable unless the optimiser takes the trouble to avoid the obvious problems. (I expect Paul will jump on me for that comment - maybe I shouldn't be technical in this thread :hehe:)

Tom