Remove '/PAE' from boot.ini
VISIO's strength is not in DB Model.
It can't compete with other tools, such as ERWin.
Spotlight / Central / Foglight are not good at application tunning.
I'll try SQL Impact later.
LECCO SQL Expert seems not good enough.
Does anybody use,
An Application Tunning Tool on SQL Server?!
There is a weakness until now.
It can't monitor the application's performance.
Does anybody purchase/use NETIQ DiagnosticManager?<br /><br />It seems nice.<br /><br />[}<img src='/community/emoticons/emotion-1.gif' alt=':)' />]
Check whether there any db's value of "category" is '1'(Publication)
Try to set it to '0'.
Does anybody has a script/stored-procedure to general a report/output about SQL 2000's Lock Owner Blocks in order to collect the real-time statics?...
Does anybody know:
How can I get SQL error message/lock-flag?
If a user try to update one table, if the table is locked by others....
There're a lot of difference between SQL 2000/SP3(65) and SQL7/SP3(65), including:
different system table name, different system table's column name,...
I want to run a store procedure after SQL server reboot.
Currently, I create a sql job call it and set job-schedule as 'Start automatically when SQL...
Thank you all.
The function is really as email@example.com mentioned
" Are you trying to do key generation with these stored procs? Use...
Sorry about misunderstanding.
The question is really about physical memory.
I wander about whether 2G is enough for 200-300 concurrent OLTP clients....
update table1 set A1=number+1 where....
select max(A1) from table1 where....
The same small table will be accessed by several highly-used SPs,
The contents of SPs are like,
I read some articles before.
It addressed about re-boot SQL will clear RAM
The problem is because of the some code-issue mess up the temp DB & RAM....
Could anybody tell,
How much RAM is enough per client?
Separate names with a comma.