Viewing 15 posts - 12,811 through 12,825 (of 39,963 total)
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
A couple things: AlwaysOn is Enterprise only. I forgot about that, so your read only replica is going to be core licensed if you go that route.
For replication, it doesn't...
February 5, 2013 at 10:43 am
This should help:
SELECT T1.Name AS DatabaseName,
Isnull(Max(T2.recovery_model), 'No Backup Taken') AS recovery_model,
'Log' AS BackupType,
Isnull(CONVERT(VARCHAR(23), CONVERT(DATETIME, Max(T2.backup_finish_date), 131)), '') AS LastBackUpTaken
FROM sys.sysdatabases T1
LEFT...
February 5, 2013 at 10:35 am
Miles Neale (2/5/2013)
February 5, 2013 at 10:29 am
Viewing 15 posts - 12,811 through 12,825 (of 39,963 total)