Viewing 15 posts - 7,996 through 8,010 (of 14,953 total)
Since SQL will build a derived table (subquery) in tempdb anyway, if it's big enough to warrant that, I don't usually consider that a significant factor, either positive or negative.
Recompiles,...
October 26, 2009 at 7:51 am
Good points, Tom.
The problem isn't the people trying to learn "software engineering" or "software crafting". Not directly anyway. The problem is the same one I see in just...
October 26, 2009 at 7:29 am
A disaster is an emergency you haven't prepared for.
I like the linked blog post. Flat spare tire = untested backup (or similar) is a good metaphore.
October 26, 2009 at 7:22 am
The CPU includes a floating point processor. Used to be called a math-coprocessor back in the 286, 386 days, before Pentium and Core 2 and Core i7 and whatever's...
October 26, 2009 at 7:08 am
You'll need a numeric column for the month number and have the report sort on that.
October 23, 2009 at 2:29 pm
Some of it's cooked into the CPU. Some might also be Microsoft. I'd hit Google/Bing/whatever to look for details.
October 23, 2009 at 2:23 pm
halifaxdal (10/23/2009)
Good catch!However, I checked the owner of the job in the maintenance plan, it is me and it's dbo and it has access to the fn.
Change the line in...
October 23, 2009 at 1:39 pm
I'm not sure what you're asking for. What precisely do you mean by "masking"? (Sorry, it brings up images of paiting rooms for me.)
October 23, 2009 at 12:07 pm
I'm pretty used to having the data and log files on a SAN. The executables are usually installed locally, but that's pretty much it.
One thing to watch out for...
October 23, 2009 at 11:34 am
Then it's almost certainly something to do with the UDF dbo.fnUserAccess.
Guessing by the name, that function will return a 1 or a 0 based on user permissions. It's possible...
October 23, 2009 at 8:41 am
You don't have to have a unique index on an identity column. It's pretty normal to do so, but not required. Is that what you're asking?
To see this...
October 23, 2009 at 8:38 am
I'm not sure, but it seems like you're in an idea position to fire up some simple tests and find out for yourself.
October 23, 2009 at 8:35 am
If adding disk space is transparent to the OS, then it'll be transparent to SQL. Converse is also true.
October 23, 2009 at 8:33 am
MVJ: That's already been suggested. That's what the report pulls its data from.
October 23, 2009 at 8:32 am
What does the proc do if you run it outside the job?
October 23, 2009 at 8:30 am
Viewing 15 posts - 7,996 through 8,010 (of 14,953 total)