Viewing 15 posts - 7,351 through 7,365 (of 7,368 total)
trace flag 3605 (log tarcedata) should be combind with 1204 (explain deadlocks).
Do it at server level as startup parameters. Otherwise it latst only for the duration of that session.
November 18, 2002 at 12:00 am
This is a nice solution if you only want to followup the sql-server-stuff.
We use HP-openview-managex/HP-OperationsW to followup the nt-eventlogs of our servers. All our jobs report failings to the...
November 7, 2002 at 1:29 am
You'll have to apply the hotfix provided by MS (SQL Server 2000 Hotfix 8.00.603 for Sqlmap70.dll) Only Sqlmap70.dll needs to be replaced.
November 4, 2002 at 2:29 am
There's nothing stupid to it. Use correct datatypes or correct functions.
Correct Datatyping is "an effort", but has huge advantages in the long run.
Basic rule #1 : Tel your...
August 22, 2002 at 2:58 am
I've seen some "state of the art SQL" regarding crystal reports and strongly advice sql-tuning.
August 12, 2002 at 8:05 am
With this title I'd expect a comparison regarding DRI and non-DRI objects (even with the DRI-indexes on the non-DRI objects). The first restriction is that with your implementation you can...
July 29, 2002 at 2:56 am
It is a nice wizard, but keep in mind it DETACHes the original db for a litle while, and hereby generates unavailability of your originating db.
July 18, 2002 at 7:20 am
Just think about the fact that your sp will run dynamic sql ! (privileges)
July 8, 2002 at 2:16 am
Stop searching, the "problem" is solved. The application developer actualy defined a table-column to short for the data that would be placed into it.
Thanks anyway for all your efforts.
🙁 these...
May 23, 2002 at 6:48 am
This is described at "FIX Enterprise Manager Returns Unexpected Error on Table or View" (Q273472)
May 14, 2002 at 4:06 am
Check this query to get a view on what soundex is doing :
select 'bijnens', soundex('bijnens')
union all
select 'bainens', soundex('baainens')
union all
select 'beinens',soundex('beinens')
union all
select 'beijnens', soundex('beijnens')
union all
select 'bynens', soundex('bynens')
union all
select 'bijnans', soundex('bijnans')
union all
select...
April 10, 2002 at 7:55 am
Building on this I got it to work in VB6 with the folowing code :
'declaration STDERR-file
Dim FileSysSTDERR As FileSystemObject
...
April 2, 2002 at 6:59 am
There's an example-application on this issue shipped with sql-server.
check "C:\Program Files\Microsoft SQL Server\80\Tools\DevTools\Samples\sqldmo"
March 22, 2002 at 12:51 am
didn't you make a carthesian product in your first query (the join-predicate is missing) ?
March 22, 2002 at 12:48 am
Could you check the mdac version. My sql7-servers using mdac 2.6 have enormous VM-sizes which are nomore visible after instaling mdac 2.6 sp1.
March 21, 2002 at 4:22 am
Viewing 15 posts - 7,351 through 7,365 (of 7,368 total)