Forum Replies Created
Viewing 15 posts - 6,061 through 6,075 (of 7,499 total)
-
RE: SQL Server 2000 Service pack 4 ?
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...
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: New SQL Server 2005 instance, really slow compared to 2000
- 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...
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: Connecting two databases
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...
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: date comparison in sql 2000
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...
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: Audit SP for logins in sysadmin role
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...
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: How to move a table from one filegroup to another?
- 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...
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: LOCK:TIMEOUT in Tempdb, ObjectID=0
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...
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: LOCK:TIMEOUT in Tempdb, ObjectID=0
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...
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: SQL Cluster rebuild
I didn't test this myself, but the doc seems good :
http://www.databasejournal.com/features/mssql/article.php/3467291
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: SQL Connection
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...
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: NT Administrator vs SQL DBA
definitely
And if you pull open the umbrella you can find a YOU !
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: local system account on SQL Server Agent
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.
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: Restoring Database--Missing Proc,Tables& columns
- 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)
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: NT Administrator vs SQL DBA
hey, hey ... apparently I started a workaround section .....
As you all have seen, there's a remark in huge letters stating "... could cost you your job..."
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: NT Administrator vs SQL DBA
- They must have no confidence at all regarding their DBA's.
- If this is a political issue, have it placed back on the agenda ! In case of disaster, problems,...
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
Viewing 15 posts - 6,061 through 6,075 (of 7,499 total)