Viewing 15 posts - 12,781 through 12,795 (of 39,936 total)
Rather than just give us data and results, explain the problem. What should the query be doing to return the results? Are you saying you want one value? The "first"...
February 11, 2013 at 10:35 am
You shouldn't have to worry about a VM environment as a SQL Server admin, unless you have perf problems. Tracking those down can be challenging since you need to somehow...
February 7, 2013 at 12:33 pm
The log backup has nothing to do with the full backup. It's all activity since the last log backup.
What activity has taken place since the last log backup?
February 7, 2013 at 12:08 pm
The key prevents duplicates. As to what fails in the load, the transaction with the dup fails. If that's the entire load, the entire load fails. You can commit in...
February 7, 2013 at 12:07 pm
It depends what you mean by activate. Just turn it on, no. If you enable queues and something puts data in them, then it could affect performance if the queues...
February 7, 2013 at 12:06 pm
I think some of the idea here is to see if we can do, or the DeepQA stuff can do, what Eric suggests. I thought I'd read the the medical...
February 7, 2013 at 12:02 pm
Grant Fritchey (2/7/2013)
Now that's funny because I'd say exactly the opposite. Degrees really, really matter but MOST of them are probably useless (saying that with no degrees and still employed...
February 7, 2013 at 10:26 am
alex.d.garland (2/7/2013)
Hugo Kornelis (2/7/2013)
paul s-306273 (2/7/2013)
Steve - 0 points to you for creating a view using 'select *'...😛
So how should Steve have made a QotD about the dangers of select...
February 7, 2013 at 10:22 am
Brandie Tarvin (2/7/2013)
Discourse apparently does not like me. I can't seem to get it loaded.I'll try again later.
They reimage the system regularly, and I've had some flakiness. My guess is...
February 7, 2013 at 10:17 am
Miles Neale (2/7/2013)
February 7, 2013 at 10:17 am
I think they've moved to tags instead of categories, which I like. That's one thing I'd liket o have here.
February 6, 2013 at 1:37 pm
I sent this to a few people, but anyone with comments on this platform, please feel free to post them. I've set up a forum here for feedback, comments, discussion,...
February 6, 2013 at 1:20 pm
Miles Neale (2/6/2013)
February 6, 2013 at 10:00 am
AFAIK, every physical core/CPU in a server has to be licensed if SQL Server can use it, even potentially. The affinity mask doesn't count here. I assume that for VMs,...
February 6, 2013 at 9:11 am
SQLRNNR (2/5/2013)
Expanding on Steve's script a little, here is one that I did:
Show off
February 5, 2013 at 10:54 am
Viewing 15 posts - 12,781 through 12,795 (of 39,936 total)