Viewing 15 posts - 406 through 420 (of 7,187 total)
No, it would just tell you there's nothing to do.
John
October 18, 2019 at 2:56 pm
I need to do it in single query and no dynamic sql.
Arbitrary requirements such as those make me suspect that this is a homework question. Please show us what...
October 18, 2019 at 8:18 am
What about storing it in the ring_buffer and just pulling it out of there?
That would work, but data in the ring buffer doesn't live for ever, so if you...
October 18, 2019 at 8:06 am
What do you see for the server in the Object Explorer window of SSMS?
John
October 17, 2019 at 3:57 pm
You're welcome. Do you understand how they work? Make sure you don't put them into production until you do, because you'll be responsible for their operation and maintenance.
John
October 17, 2019 at 3:02 pm
Use the LAG or LEAD function. Try it yourself, and post back if there's anything in particular that you struggle with.
John
October 17, 2019 at 1:28 pm
There's a similar function that you can use to read from an XE file. Granted, you still have to save to disk and then query the file at regular...
October 17, 2019 at 1:19 pm
Just needed to add a single line to my previous solution in order to take account of the weight requirement. Again, I've checked that the query runs, but I haven't...
October 17, 2019 at 11:21 am
Sign up for your local user group, go to the next meeting, and talk to people. There'll be people there who are looking for people to work for them. ...
October 17, 2019 at 11:07 am
Try this. There may be a slightly more elegant solution, but this should work. I haven't checked that the results are correct, because I'm wary about opening spreadsheets posted online.
October 17, 2019 at 10:53 am
SELECTCASE
WHEN columnA <> 0 THEN 1
ELSE columnB
END AS columnB
FROM MyTable;
John
October 17, 2019 at 9:40 am
According to Buck Woody of Microsoft at a talk I went to earlier this year, deprecation is deprecated. What I think he meant is that they're not deprecating features any...
October 17, 2019 at 9:14 am
You've discovered the hard way why it's not a good idea to store dates in a char column. That's not a criticism of you - I'm sure it's not your...
October 14, 2019 at 3:48 pm
That suggests to me that the data isn't being retained in the cache. How does the amount of RAM and the max server memory setting compare between the two servers? ...
October 14, 2019 at 3:38 pm
Yes, of course. That's the intention, anyway!
John
October 14, 2019 at 2:23 pm
Viewing 15 posts - 406 through 420 (of 7,187 total)