Viewing 15 posts - 91 through 105 (of 449 total)
Why not use an SSIS package to generate the file?
March 3, 2011 at 6:05 am
Nodes don't move, groups do.
A node is a physical server.
Steve
February 22, 2011 at 5:32 am
It really does depend:
1. On the resources of the server. Do you have enough CPU, MEMORY, drive space, etc...
2. It's a matter of preference and how you...
February 16, 2011 at 5:36 am
Thanks. I don't know what I'm talking about. I thought I experienced this but after looking through my notes, I cannot find anything; so just disregard me.
February 15, 2011 at 7:48 am
You should also look at disk contention (waits mentioned above). Disk contention will cause high cpu as processes are waiting for the disk and queuing up. SQL Server...
February 15, 2011 at 5:53 am
I would also set the max server memory for each instance ensuring that in the event that both instances are running on the same node. You could have the...
February 15, 2011 at 5:38 am
Depending on the storage requirements and actual disk size he might be able to get away with
8 disks RAID 1+0 (data)
4 disks RAID 1+0 (log)
2 disk RAID 1 (tempdb)
I've had...
February 10, 2011 at 7:24 am
Agreed, it would be nice to see the post during the reply.
Yes, RAID 1 for 2 disks, I was mistaken.
I would still keep the physical disks separate.
10 disks RAID 1+0...
February 10, 2011 at 7:00 am
Ideally you should separate the data, log and tempDB on different disks.
Depending on the size of the disks, I would do something like this
R: drive (data) = 10 drives (disks)...
February 10, 2011 at 6:10 am
Brandie, yes, I see what you are saying. I was just supporting Fergusen in that he could maintain his requirement of "Must Have" and not necessarily eliminate those who...
February 8, 2011 at 8:30 am
Brandie, no disrespect but people in the military get degrees; especially highly motivated servicemen/woman. There are opportunities.
If you're choosing someone who recently retired from the military they must have...
February 8, 2011 at 5:52 am
I would go with your 2nd choice.
Additionally, if possible I would only want to give access to the tables via stored procedures in lieu of ad hoc queries by the...
February 8, 2011 at 5:38 am
try adding the sql port to your linked server connection.
January 26, 2011 at 5:46 am
Why not use the built in msdb stored proc. to send the sms text messages? Use the phone number (text msg and proper extension (ie. 2225557777@vtext.com for Verizon)...
January 21, 2011 at 5:57 am
thanks.
Yikes, if we were blocking the UK, I'm not sure what country we wouldn't block!
January 20, 2011 at 5:29 am
Viewing 15 posts - 91 through 105 (of 449 total)