Viewing 15 posts - 496 through 510 (of 984 total)
Grumpy DBA (9/27/2016)
Ray K (9/26/2016)
Manic Star (9/26/2016)
SaulTigh
Colonel
Mustard
Thomas Rushton
blog: https://thelonedba.wordpress.com
September 27, 2016 at 5:33 am
TomThomson (9/23/2016)
Stuart Davies (9/23/2016)
Jeff Moden (9/22/2016)
DeliveryVan
Front
Line
Thomas Rushton
blog: https://thelonedba.wordpress.com
September 23, 2016 at 3:57 am
Steve Jones - SSC Editor (1/30/2015)
The other options are writing some...
Thomas Rushton
blog: https://thelonedba.wordpress.com
September 22, 2016 at 2:57 am
BrainDonor (9/22/2016)
jasona.work (9/21/2016)
Thomas Rushton
blog: https://thelonedba.wordpress.com
September 22, 2016 at 2:39 am
jasona.work (9/19/2016)
Jeff Moden (9/19/2016)
Thomas Rushton
blog: https://thelonedba.wordpress.com
September 20, 2016 at 4:28 am
Well, yes. And it's things like a box file, an assortment of stationery such as stapler, hole punch, two large boxes of staples, sellotape etc.
What's more bizarre is that...
Thomas Rushton
blog: https://thelonedba.wordpress.com
September 20, 2016 at 4:17 am
rodjkidd (9/19/2016)
Brandie Tarvin (9/19/2016)
Someone at work gave me permission to start opening up software ticket requests (as in "we have this project" or "we need a bug...
Thomas Rushton
blog: https://thelonedba.wordpress.com
September 19, 2016 at 9:25 am
djj (9/19/2016)
ThomasRushton (9/19/2016)
djj (9/19/2016)
Ed Wagner (9/19/2016)
HappyGeek (9/17/2016)
Revenant (9/16/2016)
whereisSQL? (9/16/2016)
[LandRover
Jeep
Renegade
Styx
River
Boat
Face
Thomas Rushton
blog: https://thelonedba.wordpress.com
September 19, 2016 at 5:22 am
Have you applied the latest CU for SQL2016? Available here: https://support.microsoft.com/en-us/kb/3164674 Among other things it addresses an assertion problem that may match your experience https://support.microsoft.com/en-us/kb/3172973
Also, have you tried...
Thomas Rushton
blog: https://thelonedba.wordpress.com
September 19, 2016 at 5:21 am
djj (9/19/2016)
Ed Wagner (9/19/2016)
HappyGeek (9/17/2016)
Revenant (9/16/2016)
whereisSQL? (9/16/2016)
[LandRover
Jeep
Renegade
Styx
River
Thomas Rushton
blog: https://thelonedba.wordpress.com
September 19, 2016 at 5:17 am
Thom A (9/16/2016)
ThomasRushton (9/16/2016)
Sean Lange (9/16/2016)
BWFC (9/16/2016)
jasona.work (9/16/2016)
Thom A (9/16/2016)
ThomasRushton (9/16/2016)
Thomas Rushton
blog: https://thelonedba.wordpress.com
September 16, 2016 at 7:58 am
Why not using a CTE such as:
WITH cte AS (SELECTVisitID,
InstanceID,
ROW_NUMBER() OVER (PARTITION BY VisitID ORDER BY InstanceID) as ApgarOrder,
ValueInfo
FROM #Test
)
SELECT visitid, instanceid, apgarorder, valueinfo FROM cte
WHERE apgarorder <=...
Thomas Rushton
blog: https://thelonedba.wordpress.com
September 16, 2016 at 7:53 am
Sean Lange (9/16/2016)
BWFC (9/16/2016)
jasona.work (9/16/2016)
Thom A (9/16/2016)
ThomasRushton (9/16/2016)
Thomas Rushton
blog: https://thelonedba.wordpress.com
September 16, 2016 at 7:27 am
These posts offering ways to get rid of weight loss? What? Eat more SPAM. Eat more pies. Icecream. Cakes.
All works for me... 😉
Thomas Rushton
blog: https://thelonedba.wordpress.com
September 16, 2016 at 6:01 am
I've been hit by this before, to the extend that I created a Uservoice suggestion for SQLPrompt to give warnings about exceeding this limit... https://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/15205332-warning-when-insert-statement-exceeds-limit-of-row
Thomas Rushton
blog: https://thelonedba.wordpress.com
September 16, 2016 at 2:28 am
Viewing 15 posts - 496 through 510 (of 984 total)