Viewing 15 posts - 2,626 through 2,640 (of 10,144 total)
rodjkidd (2/16/2015)
Hey Chris,How likely is the chance now of you turning up Thursday at SQL Bits?
Rodders...
I've booked the day off, mate - need 5 minutes to book the thursday at...
February 16, 2015 at 7:33 am
TomThomson (2/16/2015)
...
Stop digging, Tom! For goodness' sake, you're coming across as a cranky old fella with a short fuse. This is not what we are used to seeing from you.
February 16, 2015 at 7:18 am
Matt Miller (#4) (2/12/2015)
Jeff Moden (2/12/2015)
February 13, 2015 at 2:13 am
Jeff Moden (2/12/2015)
February 13, 2015 at 2:07 am
sgmunson (2/12/2015)
ChrisM@home (2/12/2015)
February 13, 2015 at 2:03 am
bpw (2/12/2015)
But there aren't two referenced columns, the modified query is only referencing the primary-key column - hence my question.
Point taken, sorry.
Ok try this: what two columns does the ordinary...
February 12, 2015 at 7:31 am
bpw (2/12/2015)
I understand clustered and non-clustered indexes.The Name column is not being referenced in the query, so why would SQL Server reference the non-clustered index on the Name column?
Imagine the...
February 12, 2015 at 7:14 am
In this particular case, which of the following statements is the more accurate:
"Write it properly"
"Tune it"
Sometimes it's a fine line, but in this case I think it's clear.
It seems...
February 12, 2015 at 6:47 am
Zohaib Anwar (2/12/2015)
ChrisM@Work (2/12/2015)
February 12, 2015 at 6:40 am
maria.pithia (2/12/2015)
i want to do this...
February 12, 2015 at 5:59 am
The stored procedure is written in a procedural Row-By-Agonizing_Row way indicating an inexperienced programmer. The upside is that you have plenty of scope for improvement by a professional. So why...
February 12, 2015 at 5:47 am
Zohaib Anwar (2/12/2015)
February 12, 2015 at 5:29 am
erwin.oosterhoorn (2/12/2015)
February 12, 2015 at 4:12 am
-- t11 partial rewrite. Can't go any further than this without ddl/dml for ClientMember / ClientRole / MemberOther
CROSS APPLY ( -- t11
SELECT TOP (1) [t10].[test]
FROM (SELECT NULL AS [EMPTY]) AS...
February 12, 2015 at 3:00 am
Dave Ballantyne (2/12/2015)...I have to agree with the others here, there is nothing wrong with this statement per se...
I have to disagree with you Dave:
-------------------------------------------------------
-- t4 rewrite
-------------------------------------------------------
-- [t3].[EndEffectiveDate] =...
February 12, 2015 at 2:28 am
Viewing 15 posts - 2,626 through 2,640 (of 10,144 total)