Viewing 15 posts - 526 through 540 (of 832 total)
Jeff Moden (4/10/2011)
How about spending more time and dollars on really cool stuff like designing a 350HP engine that gets 50MPG without batteries?
Because it's impossible? Petrol and diesel engines are...
April 11, 2011 at 1:23 am
Pity you can't split the results by nationality--I wonder how many British or European DBAs would get this one wrong? 🙂
April 6, 2011 at 1:38 am
Kind of defeats the point of an April fool if you tell us right in the article that it's a joke, although this was pretty blatant anyway. Mind you, SSC's...
April 1, 2011 at 4:27 am
What do you mean by every 3-6 hours anyway? If you're backing the logs up via a SQL Agent job then those should be happening at a much more precise...
March 30, 2011 at 2:33 am
I agree that the given answer could have made it obvious that the restriction only applies to the first index you create on the view, but interesting question nonetheless.
March 30, 2011 at 2:28 am
Question: are you performing regular transaction log backups, or are you only doing them when you get the "log full" problem?
March 29, 2011 at 4:30 am
richj-826679 (3/25/2011)
Steve, I'm livin' your nightmare. See my post on Oracle licensing. To make it more fun, the licensing is all "soft" -- usage is recorded but not...
March 28, 2011 at 1:32 am
I'm maybe looking at this from the somewhat selfish point of view that I only have small databases to look after, and it seems I'm paying a lot of money...
March 25, 2011 at 10:37 am
jasona.work (3/25/2011)
I think the biggest issue for doing this, would be for MS to write SQL to not use more than a set amount of RAM, or a set number...
March 25, 2011 at 8:27 am
If you have more than about 30 or 40 users (I forget the exact number) you'd probably be better off looking at processor licensing, which has no restrictions on number...
March 25, 2011 at 4:14 am
Paul Randal (3/23/2011)
It's your IO subsystem, without a shadow of a doubt.
Isn't it possible it could be a memory issue? I had a (non-SQL, admittedly) problem on a machine once...
March 25, 2011 at 3:42 am
I disagree here. Licensing per core is all well and good, but you might well end up paying to license a feature you don't want and never use! I'd rather...
March 25, 2011 at 2:30 am
Slight warning here: performing an index rebuild could result in a very large transaction log backup, which in turn could knock your log shipping temporarily out of sync (depending how...
March 22, 2011 at 2:06 am
And see mine was an Atari 800 with 800 BYTES of memory. And that was impressive for the time. And I was jealous of my friend who had...
March 17, 2011 at 2:12 am
I can remember bragging about 128K! 😛
Such is progress--my mobile phone has more RAM in it than the entire hard disk capacity of my first PC back in 1993 or...
March 11, 2011 at 6:42 am
Viewing 15 posts - 526 through 540 (of 832 total)