Viewing 15 posts - 5,371 through 5,385 (of 9,715 total)
Thank you for the response. I appreciate it.
August 11, 2011 at 9:07 am
Additional filegroups also comes in handy for partial backups and segregating read/write information from read only information.
So don't assume that because everything is on the same logical drive that prevents...
August 11, 2011 at 8:43 am
You're very welcome. Let us know the results once you have them (good or bad) as that will help others who stumble across this thread in the future.
August 11, 2011 at 8:41 am
I have a separate job that executes on a 15 minute reoccurring schedule to look for files on a certain day within a certain time frame (say, 4 hours). If,...
August 11, 2011 at 7:20 am
This almost sounds like an interview question.
Are you a dev dba / BI person that just moved into a production dba position?
Maybe I misunderstood your question, but not all...
August 11, 2011 at 5:40 am
archanab (8/11/2011)
I have to design a data base for a sales distribution system. The system has to maintain large number of parts ,customers and orders information etc.....
Fortunately for you, Microsoft...
August 11, 2011 at 5:35 am
Is it just me, are am I being particularly unhelpful this morning?
http://www.sqlservercentral.com/Forums/Topic1158208-391-1.aspx
http://www.sqlservercentral.com/Forums/Topic1158308-391-1.aspx
August 11, 2011 at 5:19 am
Gail rarely needs to do prep. She's so immersed in the internals that she already knows most of what's going to be on the exam. It helps that she rescues...
August 11, 2011 at 5:15 am
Aha. As much as I don't trust Wikipedia, this article looks interesting:
August 11, 2011 at 5:12 am
A quick google of the term gives me this article: http://support.microsoft.com/kb/944267. That tells me this is a Sharepoint service (possibly).
Do you have Sharepoint installed? I know SP does use SQL...
August 11, 2011 at 5:09 am
It sounds like you need to run a combination of Profiler (or a server side trace) and PerfMon while these jobs are running so you can get these numbers. PerfMon,...
August 11, 2011 at 5:07 am
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
Viewing 15 posts - 5,371 through 5,385 (of 9,715 total)