Viewing 15 posts - 1 through 15 (of 20 total)
Can speak for anyone else, but this place feels like a circus sometimes.
July 5, 2019 at 1:04 pm
I think I'm being silly here, I'm combining the column name with explicitly specified values, I didn't think that this was valid syntax. Surprisingly, to me anyway, it seems like...
July 5, 2019 at 7:57 am
Right you are.
Here's to you, Meet George Jetson / Chris Powell.
June 17, 2019 at 3:09 pm
So I come across this thread nine years and several iterations of SSMS after the event, totally fed up with having to restart SSMS repeatedly, often losing work along the...
June 17, 2019 at 1:24 pm
An oldie, but such a goodie.
This is exactly what I've been looking for, thank you.
March 22, 2018 at 9:20 am
Thanks, Steve. That's done the trick. You're right, it doesn't explain why the others are working but it will do for me.
March 16, 2018 at 7:39 am
Even stranger. This behaviour seems to be limited to my local 2014 instance, it isn't occurring on a 2016 Dev box. Must, presumably, be an environmental issue or a setting.
March 16, 2018 at 5:20 am
March 8, 2012 at 8:13 am
Buffer cache hit ratio is a counter that should be ignored mostly.
I read Jonathan's article with interest. But I found it telling that nobody has answered the following...
March 8, 2012 at 7:40 am
When I've had things like this happen to me in the past it's usually been caused by a dialogue box that has popped up behind the main window and is...
March 8, 2012 at 7:24 am
I guess sometimes you need to dance with the Devil 🙂
February 29, 2012 at 7:14 am
duplicate posting removed
February 29, 2012 at 3:49 am
Once again many thanks.
February 29, 2012 at 3:35 am
Does this mean I'm going to have to use a cursor for this operation, one way or another?
February 29, 2012 at 3:06 am
Perfect Andy. That's exactly what I need.
Thanks Jayeth too.
This really is the premier SQL site!
Just need to add a coalesce to handle tables that don't have an id column.
February 29, 2012 at 2:33 am