Viewing 15 posts - 1 through 15 (of 35 total)
I agree with the general sentiment, but there's one sentence that bothers me.
Perhaps I've misunderstood, so I quote the sentence slightly reworded to reflect my understanding of what was written:
If...
June 30, 2015 at 4:32 am
Thorough, well structured and objective.
Nicely done!
June 29, 2015 at 3:59 am
If the number of rows returned by each view is different, then they are not functionally equivalent.
And this renders discussion about relative performance largely moot.
I would be far more interested...
June 23, 2015 at 6:10 am
hr_sn (6/17/2015)
Wouldn't it be easier if just right click on SP and ask SSMS to create script for Alter or Create?
Not really, because you've missed a few steps...
- Expand Databases
-...
June 18, 2015 at 8:10 am
Personally I would rather perform my updates from a "master" script maintained in a source control system.
You can use a VS Database project, third party equivalent, or a custom solution.
Your...
June 18, 2015 at 2:09 am
andrew.ing (2/18/2015)
That is, COUNT(1) is the more reliable option because COUNT(*) will fail...
February 18, 2015 at 3:02 am
Brandie Tarvin (2/6/2015)[hr
I think the argument here isn't "why NOT to use COUNT(*)" or "why to use COUNT(1)". It's more along the lines of "use either, the result and the...
February 11, 2015 at 10:50 am
SQLBoar (1/10/2014)
January 30, 2015 at 5:09 am
A few answers have suggested first pivoting the data into a column per product, counting how many of each product were bought.
This makes it rather trivial to write a succint...
June 6, 2014 at 9:16 am
The Wizard Of Oz (6/6/2014)
ben.norris (6/6/2014)
No you misunderstand, I don't mean the ordering of values within the table. Check the code for example to find customers who bought 'A'...
June 6, 2014 at 8:57 am
valeryk2000 (6/6/2014)
June 6, 2014 at 8:53 am
valeryk2000 (6/6/2014)
select ...
June 6, 2014 at 8:35 am
john.moreno (12/9/2013)
RBAR is slow for the same reason a bubble sort is slow -- it does expoentially more work than is necessary.
PHYData DBA (12/9/2013)
December 13, 2013 at 3:42 am
John Hick-456673 (4/18/2013)
I have tested it against large tables (1 billion plus rows) and performance is much better than with dynamic SQL.
I'm going to be blunt here.
I find that extremely...
April 18, 2013 at 11:29 am
Cadavre (4/18/2013)
Excellent link.
And nice to...
April 18, 2013 at 3:59 am
Viewing 15 posts - 1 through 15 (of 35 total)