Viewing 15 posts - 12,661 through 12,675 (of 39,810 total)
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
We've already reported, or at least a few people have. I missed the first practice, but I need to start throwing for sure.
February 5, 2013 at 10:29 am
I heard back that you can write powershell scripts to do this, which would make it repeatable, but require development on your part. I'll try to track down a sample...
February 5, 2013 at 8:43 am
I'm not sure it does, but it packages things up, so there might be a hack. I'll ask.
February 4, 2013 at 6:35 pm
Viewing 15 posts - 12,661 through 12,675 (of 39,810 total)