Viewing 15 posts - 91 through 105 (of 392 total)
Thanks for the info/links. It definitely was an eye opener after listening to HP and their puppets.
March 8, 2012 at 6:18 am
the entire server rebooting when SQL Server service stops
What is your drive configuration to cause this?
March 7, 2012 at 1:01 pm
Now I understand. I thought that the line was one long string containing all of the fields.
February 23, 2012 at 5:46 am
In your FMT file, you need to set up for each field the field type, length. I believe (it's been awhile) that you can tell it which position the start...
February 22, 2012 at 6:27 pm
Create a format file for the file to load. You can set the field length for each field.
February 22, 2012 at 1:06 pm
What size is your distribution database? How many packages and subscribers do you have? How long do you keep your history?
I found that in larger replication systems that the clean-up...
February 21, 2012 at 11:49 am
sknox
I created a view with more than one index, and the query optimizer would use the second (nonclustered) index in Enterprise editions, or with the NOEXPAND hint
The point I was...
February 10, 2012 at 10:40 am
Hugo
And I have never seen a real-world case where there was more than a single index on a view
Does that mean that there couldn't be more than one? Does that...
February 10, 2012 at 9:42 am
This has been a subject of great debate and opinions, but I would suggest RAID 5 or RAID 50 for the data files in order to best obtain read performance.
February 7, 2012 at 9:17 am
SQLLPhil,
Hang in there. It will eventually get better.
January 24, 2012 at 5:33 am
Simha
Try to increase Virtual Memory
The problem with this is that paging would increase as items are swapped between RAM and Virtual wouldn't it?
January 23, 2012 at 6:59 am
SQLPhil,
Your first issue, as I see it is the very low memory on the box. The biggest issue is that with Replication, each of the agents running uses memory both...
January 23, 2012 at 6:22 am
How many subscribers are there on the box?
How many packages?
Is the distributor on the same box as the database?
How much memory is allocated to SQL Server?
January 20, 2012 at 7:23 am
I can forgive you since the Packers are an NFC team and not from NY. You need to be rooting for the Pats in the AFC though
Perfect game Pats/Packers -...
January 13, 2012 at 9:20 am
Paul White
Fair enough. I quite like Brandie's suggestion to lock it though
Let me show my ignorance, what is the difference?
If lock it means that it is visable but unable...
January 13, 2012 at 9:17 am
Viewing 15 posts - 91 through 105 (of 392 total)