Forum Replies Created
Viewing 15 posts - 6,721 through 6,735 (of 7,499 total)
-
RE: Automatic Statistics not being created
Check Autostats db-setting !
sql7 and sql2k pre sp3 exec sp_dboption N'yourdb', N'auto create statistics', N'true' --
sql2k sp3 : ALTER DATABASE yourdb SET AUTO_CREATE_STATISTICS ON...
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: PLEASE I NEED HELP, HOW CAN I DO TO RESTORE THE MSDB
msdb is a systemdb. I don't know if #-version restore is supported
Personaly I would script the sql7 jobs, alerts, .... and then implement...
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: MSDE listens on different port every time it starts
don't add these keys if your sqlserver works !
search for a "TcpPort"-key. It has to be there and then you know you'll adjust...
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: MSDE listens on different port every time it starts
IMO you should alter key :
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\instancename\MSSQLServer\SuperSocketNetLib\Tcp]
"TcpHideFlag"=dword:00000000
"TcpPort"="1433"
"TcpDynamicPorts"=""
or
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\SuperSocketNetLib\Tcp]
"TcpHideFlag"=dword:00000000
"TcpPort"="1433"
"TcpDynamicPorts"=""
I hope this helps
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: configuration for server
print 'Free Space'
print '----------'
exec master.dbo.xp_fixeddrives
print 'Memory'
print '------'
exec master.dbo.xp_msver
print 'Database Configuration'
print '----------------------'
exec master.dbo.sp_configure
print'DB Size'
print'-------'
exec master.dbo.sp_databases
print 'Linked Servers'
print '--------------'
exec master.dbo.sp_helplinkedsrvlogin
print 'Windows info'
print '------------'
exec master.dbo.sp_server_info
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: Record Counts differ in QA vs EM???
in addition to Steve's responce:
If you're running sql2k sp3 standard edition on a multi-proc-box, you might encounter this bug (fix available) : FIX: A Parallel Query with a COUNT Aggregate...
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: foriengn key constraints Sequence
check sp_pkeys and sp_fkeys in books online
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: please help
Keep in mind your restore-time will depend on your network speed / availability !
maybe this site can help you calculate the needed time :
http://www.homenethelp.com/web/explain/about-network-speeds.asp
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 change the physical path of tempdb data and logfiles?
use master
go
alter database tempdb modify file (name=tempdev,filename='E:\MSSQL\DATA\TEMPDB.MDF')
go
alter database tempdb modify file (name=templog,filename='E:\MSSQL\DATA\templog.ldf')
go
-- RESTART SQL SERVER !!!!!!!!
SHUTDOWN
Startup sqlserver with sqlserver service manager (don't forget sqlagent !)
Cleanup old files !
use tempdb
go
exec sp_helpfiles
go
check...
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: Row Count and Number of Records differ in Query Analyzer
is autostats enabled ?
run sp_updatestats / dbcc updateusage once in a while (even with autostats on)
Check again.
Still differences ?
Is your sql2k on sp3a and on a multi-proc box ? if...
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: NEED ANSWER FAST (about sa password now blank)
check your sqlserver logs. If sa-password has been altered, it records a line in the sqlserver errorlog.
Don't get confused with windows authentication !
If you login using windows authentication, there is...
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: please help
Restore database yourdb
from DISK = '\\UNCservername\path\backupfile.bak'
Check restore in books online
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: CASE in WHERE Clause?
for this you don't need "case" but correlated subquery
select * from dyna.dtaTenant t
where not exists
(
SELECT 1
FROM dyna.dtaTenant
INNER JOIN dyna.ctlLinks
ON dyna.dtaTenant.DyKey =...
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: "I renamed the file and it does not work"
One of our customers stated he didn't need backups copied to a safe place.
When he tested his backup-power-system there was this litle problem where in stead of 220V 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: "I renamed the file and it does not work"
only one client ?
The more stupidities they produce, the more they'll need people like us
Make 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
Viewing 15 posts - 6,721 through 6,735 (of 7,499 total)