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.
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
March 8, 2012 at 6:18 am
the entire server rebooting when SQL Server service stops
What is your drive configuration to cause this?
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
March 7, 2012 at 1:01 pm
Now I understand. I thought that the line was one long string containing all of the fields.
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
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...
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
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.
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
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...
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
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...
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
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...
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
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.
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
February 7, 2012 at 9:17 am
SQLLPhil,
Hang in there. It will eventually get better.
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
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?
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
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...
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
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?
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
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 -...
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
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...
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
January 13, 2012 at 9:17 am
Viewing 15 posts - 91 through 105 (of 392 total)