Viewing 15 posts - 7,336 through 7,350 (of 7,361 total)
Maybe I'm looking at a small scale, but any chance DTS could help out ?
December 9, 2002 at 12:37 am
When scripting remember to script the user/role-autorities as well !
As for the warm feeling : Enjoy it as much as possible!
December 9, 2002 at 12:30 am
what are (index and )datapagestatistics stating ? (imho Shrink is only freeing empty pages)
December 9, 2002 at 12:15 am
what are (index and )datapagestatistics stating ? (imho Shrink is only freeing empty pages)
December 9, 2002 at 12:15 am
The only way to be sure about the sort order of the resultset is to put an ORDER BY clause in your query. Group by might give a correct result,...
November 29, 2002 at 2:11 am
Sorry I wasn't that specific. Antras686 completed the missing link in this case 😉
November 28, 2002 at 12:01 am
if you're using EM , just design the view and add a space somewhere and push the apply-button.
November 27, 2002 at 12:33 am
search for killpwd.exe
from MS :
Microsoft has created the KillPwd.exe command utility to search Microsoft® SQL Server™
setup files for the System administrator (sa) login password. If the KillPwd.exe command
utility...
November 25, 2002 at 5:32 am
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
Viewing 15 posts - 7,336 through 7,350 (of 7,361 total)