Viewing 15 posts - 6,061 through 6,075 (of 7,501 total)
thanks for the feedback.
October 16, 2006 at 5:25 am
Indeed the GUI stuff is very slow.
IMO the datapart is greath.
regading you filegroup-slowness ... I didn't encounter this.
Is it with the creation of the filegroup, or of the files within...
October 16, 2006 at 5:20 am
did you install MSDE ? use SQL2000.MSDE-KB884525-SP4-x86-ENU.EXE
or did you install a personal edition ? use SQL2000-KB884525-SP4-x86-ENU.EXE
or did you install only client components ? use SQL2000-KB884525-SP4-x86-ENU.EXE
and do you also have Analysis...
October 10, 2006 at 7:57 am
- I'd start with a stop/start of sqlserver (to clear the performancerelated dmv's)
- then I'd do the standard maintenance !
dbcc dbreindex / sp_updatestats / dbcc updateusage ('yourdb')
- Then I'd start...
October 9, 2006 at 11:55 pm
depending on the amount of data you'd expect ....
- you could setup replication to your needs and sync nightly
- you could use the tablediff.exe (check books online).
this ms-util generates...
October 5, 2006 at 7:57 am
If you use a dateandtime var and a datetime column, use a parameterized query in combination with a datetime parameterobject.
e.g. vbs:
' Handle commandobject
set CmdObj = CreateObject("ADODB.Command")
CmdObj.ActiveConnection = ConnObj
CmdObj.CommandText = "select...
October 4, 2006 at 1:00 am
you could set the "audit level" to ALL.
and then import the sql-errorlog at regular basis and filter the sysadm-logins.
you'll have to keep an eye at the sql-errorlog because it...
October 4, 2006 at 12:22 am
- A clustered index _contains_ the datapages (leaflevel) !
- if you create a table on a specific filegroup, if there is no clustering index, the data will reside on the...
October 3, 2006 at 3:18 am
capture the query-load and examine it !
You may need to add some indexes, expecialy to support group by, order by operations ! as well as joins !
This way you may...
October 1, 2006 at 1:04 am
get the creation of temporary tables out of the transaction if you can !
So if possible, create your #tmptbl(s) and then begin tran ... do your stuff ... commit/rollback and cleanup...
September 29, 2006 at 12:16 am
I didn't test this myself, but the doc seems good :
http://www.databasejournal.com/features/mssql/article.php/3467291
September 29, 2006 at 12:05 am
now this one is nice to read ![]()
imo switch your sql-agent service account to a windows account (grant the account the needed rights to the fileshares)
and...
September 28, 2006 at 8:54 am
definitely ![]()
And if you pull open the umbrella you can find a YOU !![]()
September 28, 2006 at 7:50 am
If you activate the job via EM, the job may run using your windows-auth (it is logged your useraccount started the job).
That would explain why it can reach the share.
September 28, 2006 at 7:46 am
- what was the timegap between the backup and the restore ?
- have these procs, .. been created/altered during your backup ? (open transaction will be rolledback during recover)
September 28, 2006 at 2:57 am
Viewing 15 posts - 6,061 through 6,075 (of 7,501 total)