SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


What is the result ? (SQLServer 2005)


What is the result ? (SQLServer 2005)

Author
Message
Ian Elliott
Ian Elliott
SSC Veteran
SSC Veteran (267 reputation)SSC Veteran (267 reputation)SSC Veteran (267 reputation)SSC Veteran (267 reputation)SSC Veteran (267 reputation)SSC Veteran (267 reputation)SSC Veteran (267 reputation)SSC Veteran (267 reputation)

Group: General Forum Members
Points: 267 Visits: 971
TyGas (9/10/2008)
Let me correct you... The version of SQL Server was mentioned.


Sorry I stand corrected but yes I think the wording could have been better e.g. specifically saying using SSMS would've been more accurate. I don't like questions that make assumptions for you.

One of my favourite film quotes of all time is "Assumption is the mother of all screwups!"

OK it's not screwups but another similar word beginning with f but I'm not going to post that BigGrin
skyline666
skyline666
SSC-Addicted
SSC-Addicted (406 reputation)SSC-Addicted (406 reputation)SSC-Addicted (406 reputation)SSC-Addicted (406 reputation)SSC-Addicted (406 reputation)SSC-Addicted (406 reputation)SSC-Addicted (406 reputation)SSC-Addicted (406 reputation)

Group: General Forum Members
Points: 406 Visits: 229
Ian Elliott (9/11/2008)
I think the wording could have been better e.g. specifically saying using SSMS would've been more accurate. I don't like questions that make assumptions for you.


I agree, you can't just make assumptions when making projects for clients, for example, as you could get it wrong.

Given the wording of the question, I think that the Incorrect syntax answer should be the correct answer as well.
Lynn Pettis
Lynn Pettis
SSC-Forever
SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)

Group: General Forum Members
Points: 40492 Visits: 38567
Unfortunately (or not), I disagree. By specifying SQL Server 2005 in the question, that should automatically eliminate SQL Server 2000 tools from the equation. In my environment, currently mixed 2000/2005, the only reason I even use SQL Server 2000 tools is to look at and modify (if necessary) SQL Server 2000 DTS packages. All other activities are done using the SQL Server 2005 tools.

Cool

Cool
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)
ALZDBA
ALZDBA
SSChampion
SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)

Group: General Forum Members
Points: 12534 Visits: 8930
Lynn Pettis (9/11/2008)
Unfortunately (or not), I disagree. By specifying SQL Server 2005 in the question, that should automatically eliminate SQL Server 2000 tools from the equation. In my environment, currently mixed 2000/2005, the only reason I even use SQL Server 2000 tools is to look at and modify (if necessary) SQL Server 2000 DTS packages. All other activities are done using the SQL Server 2005 tools.

Cool


Pffeeuuuuwww ... I'm no longer the only person in the galaxy making that assumption ( with SQL2005 only to use SSMS or SQLCMD) BigGrin

Altough, persons using e.g. .Net may still be a bit picky on this question Crying

Johan


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


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


press F1 for solution, press shift+F1 for urgent solution :-D


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me Alien but most of the time this is me Hehe
Ian Elliott
Ian Elliott
SSC Veteran
SSC Veteran (267 reputation)SSC Veteran (267 reputation)SSC Veteran (267 reputation)SSC Veteran (267 reputation)SSC Veteran (267 reputation)SSC Veteran (267 reputation)SSC Veteran (267 reputation)SSC Veteran (267 reputation)

Group: General Forum Members
Points: 267 Visits: 971
ALZDBA (9/11/2008)
Pffeeuuuuwww ... I'm no longer the only person in the galaxy making that assumption ( with SQL2005 only to use SSMS or SQLCMD) BigGrin

Altough, persons using e.g. .Net may still be a bit picky on this question Crying


Yep I agree, in a perfect world, but as this thread has now shown not everyone makes that assumption or even obeys it therefore at best the question should be noted as ambiguous.

Don't you just love being a DBA Laugh
Lynn Pettis
Lynn Pettis
SSC-Forever
SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)

Group: General Forum Members
Points: 40492 Visits: 38567
Again, we don't work in a perfect world. How many times do we have to make assumptions in our day to day work? Users don't tell us everything we need to get them what they need, so we have to make assumptions all the time.

To tell people who are willing to come up with QotD that they must provide completely unambiguous questions is simply , IMHO, unreasonable. They might as well just give us the answer instead of having us figure it out and get it right or wrong based on our assumtions and research.

Cool
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)
Lynn Pettis
Lynn Pettis
SSC-Forever
SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)

Group: General Forum Members
Points: 40492 Visits: 38567
ALZDBA (9/11/2008)
[quote
Pffeeuuuuwww ... I'm no longer the only person in the galaxy making that assumption ( with SQL2005 only to use SSMS or SQLCMD) BigGrin



Actually, I stopped using the SQL Server 2000 tools, except for working with DTS packages, as soon as I loaded SQL Server 2005 Developer Edition on my desktop systems. That was back in 2005.

Cool

Cool
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)
Ian Elliott
Ian Elliott
SSC Veteran
SSC Veteran (267 reputation)SSC Veteran (267 reputation)SSC Veteran (267 reputation)SSC Veteran (267 reputation)SSC Veteran (267 reputation)SSC Veteran (267 reputation)SSC Veteran (267 reputation)SSC Veteran (267 reputation)

Group: General Forum Members
Points: 267 Visits: 971
Lynn Pettis (9/11/2008)Again, we don't work in a perfect world. How many times do we have to make assumptions in our day to day work? Users don't tell us everything we need to get them what they need, so we have to make assumptions all the time.
Yes but that's why I ask them further questions and why I stipulate that I don't get the blame for assuming things when they have not provided me with the information I need and ask for.

Lynn Pettis (9/11/2008)To tell people who are willing to come up with QotD that they must provide completely unambiguous questions is simply , IMHO, unreasonable. They might as well just give us the answer instead of having us figure it out and get it right or wrong based on our assumptions and research.


While I mostly agree with you on making all questions completely unambiguous as this can sometimes be a mammoth task, how hard would it have been to say "In SQL Server 2005 (using 2005+ tools), what is the result of this query."

Honestly I'm really not trying to be picky I just think for query questions it's not totally unreasonable to ask someone to specify the sql version and tools/versions if it is going to make a difference to the answer as not everyone will be using the same configurations and tools.

Sorry maybe lots of people will disagree with my view and as I haven't been in this field for a long time (being a relative youngster) maybe they are correct but I'll certainly take this on board for future questions now I am aware of the std thinking.

Thanks. Smile
Lynn Pettis
Lynn Pettis
SSC-Forever
SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)

Group: General Forum Members
Points: 40492 Visits: 38567
I've been in this field for 30+ years (started in computer operations and worked up from there). Doesn't matter how many questions you ask, at some point you have to make some assumptions based on what you have at the time. Some users don't even know what they want until you give them what they ask for and realize that isn't what they wanted at all.

We never eliminate abiguity, just minimize it. As for the QotD, yes, they are a learning tool, but really will it matter tomorrow if you got the answer today right or wrong? What really matters is that you learned something from the question, and sometimes from the ensuing discussion.

Cool

Cool
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)
ALZDBA
ALZDBA
SSChampion
SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)

Group: General Forum Members
Points: 12534 Visits: 8930
Don't you just love the way a simple question - with some context - with the possibility of being ambiguous triggers a bunch of discussions.

"Make it fool proof and they will come up with a better fool" Wink


It just wasn't the case over here.

Johan


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


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


press F1 for solution, press shift+F1 for urgent solution :-D


Need a bit of Powershell? How about this

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


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search