Sioban Krzywicki

Forum Replies Created

Viewing 15 posts - 2,131 through 2,145 (of 2,838 total)

RE: Are the posted questions getting worse?

Gianluca Sartori (2/18/2011)
I have to admit it was my fault.
If I didn't post on THE THREAD a "Lennie alert" nobody would have noticed, Lennie would have got his answer and...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams

February 18, 2011 at 6:59 am

#1288820
RE: Are the posted questions getting worse?

Craig Farrell (2/18/2011)
Koen Verbeeck (2/18/2011)
Gianluca Sartori (2/18/2011)
Do you remember Lennie, the guy with sock-puppets friends?
He's back again. Nothing worth worrying about, at the moment.
http://www.sqlservercentral.com/Forums/Topic1066085-9-1.aspx
I just read the thread you linked...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams

February 18, 2011 at 6:47 am

#1288806
RE: Are the posted questions getting worse?

Jack Corbett (2/17/2011)
george sibbald (2/17/2011)
Koen Verbeeck (2/16/2011)
Jeff Moden (2/16/2011)
CirquedeSQLeil (2/16/2011)
For the execution of Wayne:
--get spid of code requestor
sp_whorequestedcodeIntheThread 'Wayne'
--use returned spids to verify the request
dbcc inputbuffer(61)
--output
'Wayne definitely requested...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams

February 17, 2011 at 7:26 am

#1288224
RE: Are the posted questions getting worse?

GSquared (2/16/2011)
Fal (2/16/2011)
Koen Verbeeck (2/15/2011)
Fal (2/15/2011)
WayneS (2/15/2011)
Can anyone point me to a delimited split function that works on a varchar(max)? I know that Jeff's DelimitedSplit8K works on up to a...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams

February 16, 2011 at 7:31 am

#1287672
RE: Are the posted questions getting worse?

GilaMonster (2/14/2011)
Stefan Krzywicki (2/14/2011)
GilaMonster (2/14/2011)
Grant Fritchey (2/14/2011)
Now I feel much better. I lose my job to Gail or I lose my job to Gail. Isn't there a third option that...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams

February 14, 2011 at 1:32 pm

#1286723
RE: Are the posted questions getting worse?

GilaMonster (2/14/2011)
Grant Fritchey (2/14/2011)
Now I feel much better. I lose my job to Gail or I lose my job to Gail. Isn't there a third option that doesn't involve me...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams

February 14, 2011 at 1:08 pm

#1286709
RE: $PARTITION function wrong after switch?

ALZDBA (2/14/2011)
IMO you are fooling yourself by using the wrong PF with the correct table in your select query.
SELECT *
, $PARTITION.AnnualDateRange_PartitionFunction(OrderDate) AS...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams

February 14, 2011 at 10:49 am

#1286608
RE: $PARTITION function wrong after switch?

I haven't had a chance to run the code and won't until after work today at the earliest, but from reading through it it looks like your SWITCH statement violates...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams

February 14, 2011 at 10:15 am

#1286589
RE: $PARTITION function wrong after switch?

Have you done a query against the system tables to see if that's still the case?
SELECT T.name, P.* FROM sys.tables T
INNER JOIN sys.partitions P
ON T.object_id = P.object_id
This query will tell...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams

February 14, 2011 at 8:43 am

#1286532
RE: To get the Max value from one column with case statement without using any aggregate functions

nadabadan (2/13/2011)
Craig Farrell (2/13/2011)
EDIT: I was going to respond again but then I realized I was answering the exact same argument for the third time. You ignore half of...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams

February 13, 2011 at 8:27 pm

#1286243
RE: To get the Max value from one column with case statement without using any aggregate functions

nadabadan (2/13/2011)
Except that it isn't me "cherry-picking", it is you. You're the one that wants us to ignore everything else you said and only consider the cherry-picked statement you made.
No...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams

February 13, 2011 at 8:24 pm

#1286242
RE: Are the posted questions getting worse?

WayneS (2/13/2011)
Stefan Krzywicki (2/9/2011)
An interview isn't just the employer deciding on an employee. The employee is also judging the employer. I think many people fail to realize this even during...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams

February 13, 2011 at 6:55 pm

#1286233
RE: Are the posted questions getting worse?

WayneS (2/13/2011)
Dave Ballantyne (2/9/2011)
Handed my notice in today , i can already feel the freedom 🙂
Congratulations! Seems to be quite a few folks moving on... I myself just started a...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams

February 13, 2011 at 6:55 pm

#1286232
RE: To get the Max value from one column with case statement without using any aggregate functions

nadabadan (2/13/2011)
I did. Here I was answering the question "When did I claim it was a question about basic knowledge of "computer theory".
Are you now saying that everything you said...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams

February 13, 2011 at 6:11 pm

#1286224
RE: To get the Max value from one column with case statement without using any aggregate functions

nadabadan (2/13/2011)
Stefan Krzywicki (2/13/2011)
nadabadan (2/13/2011)
When did I claim it was a question about basic knowledge of "computer theory". What I SAID was it was a question to learn about someone's...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams

February 13, 2011 at 11:09 am

#1286170

Viewing 15 posts - 2,131 through 2,145 (of 2,838 total)