Viewing 15 posts - 5,371 through 5,385 (of 9,707 total)
Your description of the problem is confusing and unclear. It sounds like your business users have no idea what they want or that you don't understand what they want.
Before you...
August 11, 2011 at 5:03 am
Sounds like an account that was manually created in your Active Directory domain for the express purpose of running SQL Server and/or SQL Agent Service accounts. But you should ask...
August 11, 2011 at 4:56 am
Of a SQL Agent Job or some other job (Windows Task, etc.) that uses SQL Server?
SQL Agent has job duration (and step duration) counts in the job history log. But...
August 11, 2011 at 4:54 am
There are way too many of them to answer that question very easily. And each "best practice" has a caveat. It depends on what kind of database you're designing (OLTP,...
August 11, 2011 at 4:51 am
Depends on the packages. If they're small and they complete relatively quickly, then they will run in order.
But SQL Agent just starts the packages. It does not wait until...
August 11, 2011 at 4:49 am
Thanks for those who have voted so far and to those who are about to vote. @=)
The color scheme is flaky. I noticed that when I set it in the...
August 10, 2011 at 12:46 pm
george sibbald (8/10/2011)
@Remidarn them for closing it. worth another comment asking for it to be looked at again?
I just looked at it. It's open again.
August 10, 2011 at 12:42 pm
Thanks, Ninja. Appreciate the link.
August 10, 2011 at 7:22 am
Help me bug Microsoft about a minor issue that is driving me sane.
This one is giving me heartburn. I almost ran something in Production that was supposed to be run...
August 10, 2011 at 4:39 am
This is still bugging me, so I opened up a bug issue on MS Connect. If anyone is interested in voting for it, here it is:
August 10, 2011 at 4:35 am
chris.caines (8/6/2011)
August 9, 2011 at 5:46 am
Stats can be manually created on non-indexed columns, so far as I know, which is what the Create Statistics statement is for. The key info to know is that stats...
August 1, 2011 at 12:09 pm
chandan_jha18 (8/1/2011)
We are not adding any table to an existing one. Tables are different and the import will be creating new tables from scratch.
My bad. I thought you were merging...
August 1, 2011 at 11:54 am
chandan_jha18 (8/1/2011)
Is this the correct way and matches the answers in your mind while you replied here:-)
Yes. That is the correct way.
Something to be aware of, though. If two tables...
August 1, 2011 at 8:44 am
You have two options at this point. Call Microsoft (recommended) or create a work around.
The work around method is dirty and you will probably forget something (hence the reason I...
August 1, 2011 at 5:39 am
Viewing 15 posts - 5,371 through 5,385 (of 9,707 total)