Viewing 15 posts - 3,526 through 3,540 (of 9,401 total)
This is something I've done (not on 2014 yet) but never feel like I have down to a science. Maybe because I do it so infrequently that I don't...
March 24, 2016 at 5:28 am
l.vignando (3/24/2016)
Nice question, but awarding points for and titling "Group by" is a big hint, so alternatives without group should be automatically excluded.Anyway nice question and nice count distinct trick.
Nice...
March 24, 2016 at 5:24 am
Lynn Pettis (3/23/2016)
Ed Wagner (3/23/2016)
Lynn Pettis (3/23/2016)
Ed Wagner (3/23/2016)
Alan.B (3/23/2016)
ChrisM@Work (3/23/2016)
March 23, 2016 at 9:40 pm
TomThomson (3/23/2016)
Ed Wagner (3/23/2016)
Claymore
Broadsword
Katana
March 23, 2016 at 9:39 pm
I noticed that you have a 4-column clustered index that consists entirely of user-defined data types. What are the underlying types of those? I'm just going to presume...
March 23, 2016 at 9:36 pm
Lynn Pettis (3/23/2016)
Ed Wagner (3/23/2016)
Alan.B (3/23/2016)
ChrisM@Work (3/23/2016)
March 23, 2016 at 6:03 pm
HappyGeek (3/23/2016)
Manic Star (3/23/2016)
Ed Wagner (3/23/2016)
eccentricDBA (3/23/2016)
Ed Wagner (3/23/2016)
Ray K (3/23/2016)
Manic Star (3/23/2016)
Grumpy DBA (3/23/2016)
Revenant (3/23/2016)
MoonBare
Arms
Legs
ZZ Top
Hot Rod
Rodney
Landmine
Petard
Claymore
March 23, 2016 at 5:55 pm
If this is a homework question, it's either a trick question or phrased very poorly.
March 23, 2016 at 3:06 pm
Alan.B (3/23/2016)
ChrisM@Work (3/23/2016)
The idea of...
March 23, 2016 at 3:03 pm
What parameter are you passing to the procedure?
Like Sean asked, it would be helpful if you provided the entire stored procedure. The bigger picture comes in with the calling...
March 23, 2016 at 3:00 pm
eccentricDBA (3/23/2016)
Ed Wagner (3/23/2016)
Ray K (3/23/2016)
Manic Star (3/23/2016)
Grumpy DBA (3/23/2016)
Revenant (3/23/2016)
MoonBare
Arms
Legs
ZZ Top
Hot Rod
Rodney
March 23, 2016 at 2:02 pm
Ray K (3/23/2016)
Manic Star (3/23/2016)
Grumpy DBA (3/23/2016)
Revenant (3/23/2016)
MoonBare
Arms
Legs
ZZ Top
March 23, 2016 at 1:13 pm
ChrisM@Work (3/23/2016)
Eirikur Eiriksson (3/23/2016)
ChrisM@Work (3/23/2016)
The...
March 23, 2016 at 1:12 pm
djj (3/23/2016)
Ed Wagner (3/23/2016)
Grumpy DBA (3/23/2016)
Ed Wagner (3/22/2016)
AltruismUnselfish
Humble
Pie
Apple
March 23, 2016 at 10:10 am
Grumpy DBA (3/23/2016)
Ed Wagner (3/22/2016)
AltruismUnselfish
Humble
March 23, 2016 at 9:35 am
Viewing 15 posts - 3,526 through 3,540 (of 9,401 total)