Viewing 15 posts - 46,156 through 46,170 (of 49,571 total)
mithun gite (6/20/2008)
would it this immidiate change will benefit me a bit or not ?
No. They're still on the same physical drive. c, d and e are just logical...
June 20, 2008 at 7:28 am
Are you sure they're from IIS?
If you check the slow running queries in sysprocesses, what is the wait type that's listed for them?
June 20, 2008 at 7:23 am
As was pointed out to me the other day (after I said the same thing in the same situation), data types are checked before the instead of trigger fires, in...
June 20, 2008 at 5:48 am
I wouldn't suggest putting the log on the OS drive. If you do that it's compeating with the swap file. Bad idea.
Can you buy a 3rd drive?
Where's TempDB?
June 20, 2008 at 5:45 am
Ok, let's see if I have this straight.
You have 3 disks in a raid 5 config. The one resultant raid array is then divided into 3 partitions, c:, d: and...
June 20, 2008 at 5:37 am
pduplessis (6/20/2008)
June 20, 2008 at 3:08 am
pduplessis (6/20/2008)
Sometimes you are restricted by some things that you really take for granted.
I've learnt never to take anything for granted.
Obviously in some countries like mine, the level of...
June 20, 2008 at 2:35 am
mithun gite (6/20/2008)
should i need to put switch of 3gb to increase the memory?
Your memory is not the issue. Your drives are the issue right now. First thing is to...
June 20, 2008 at 2:33 am
pduplessis (6/20/2008)
Interestingly enough, they still aint backing up, no matter how much squeeze my boss is putting on them.~PD
Um..... <speechless>
They are planning on implementing backups once it becomes production. Right?
Restoring...
June 20, 2008 at 1:59 am
cgchavero (6/19/2008)
I need to copy some databases from SQL 2000 to SQL 2005 and set Compatibility Level to SQL 2005 automatically.Tanks!
Why not just restore a backup? It'sll probably be faster...
June 20, 2008 at 1:45 am
sram24_mca (6/20/2008)
SELECT@ServiceID = I.ServiceID, @Name = I.[Name],@LocationID = I.LocationID, @ModifiedBy = I.CreatedBy,
@Deleted = I.Deleted
FROM INSERTED I
One problem with your trigger straight off, ignoring performance problems...
It only caters for single...
June 20, 2008 at 1:20 am
TheSQLGuru (6/19/2008)
This mechanism does opens up the possibility of a dictionary attack to retrieve the value.
Suggestion I've seen to avoid that is to have a salt in a...
June 20, 2008 at 1:13 am
Could you post an example of one of those triggers please? It's hard to talk about increasing performance without some code.
June 20, 2008 at 1:05 am
OK. wanna check something first. Those values are for the sec/read, not the read/sec?
If so, You have major IO problems! The memory doesn't look bad, the cache hit ratio is...
June 20, 2008 at 12:45 am
Viewing 15 posts - 46,156 through 46,170 (of 49,571 total)