Forum Replies Created
Viewing 15 posts - 7,186 through 7,200 (of 7,500 total)
-
RE: SQL7 to new server
If you are only moving to new hardware.
Install SQLServer exactly as your original server (drives, directorylocations, ..), bring it to the same servicepack as original.
Now comes the rocket-science:
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: Why cant my query update a linked table?
can you post the query ? and the ddl of the used object(s) in sqlserver.
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: left outer join...
noeld is probably right.
If you have a sql2k sp3a and a multiprocessor-box, you need a hotfix for the count(*). That could also be a reason.
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: Why does query run so long?
replace the distinct by a group by and you'll gain more !
SELECT Prcs_dte
INTO #A_Dates
FROM tbl_Tracking group by Prcs_dte
SELECT Prcs_dte
INTO #B_Dates
FROM Acct_Stats group by Prcs_dte
Still I'd suggest you'd profile it 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: Exporting Database Diagrams to Visio
sorry for visio
You can reverse-engineer it from within visio.
New DatabaseModelDiagram
database\reverse engineer
(you may have to create and odbc-dsn to get connected)
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: Why does query run so long?
use " NOT EXISTS " ... that's the way to do it !
speed it up by adding an index on table/view Acct_Stats column prcs_dte.
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: Two field DISTINCT combination
just m 2ct:
select book, count(distinct page) as pagecount
from tl10_land
group by book
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: Creating a new transaction log smaller than original
this can be don without unavailability :
check dbcc shrinkfile / shrinkdb in BOL
take special notice at Shrinking the Transaction Log.
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: Hung SQLAgent Jobs
You know SQLmail and clustering is not supported
.That's why I use smtp-mail on my clustered sqlservers.
SQLmail works, but only for a while, then 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: Gost process
If it stays in rollback-state to long according to your expectation, you may need to stop and start your sqlserver-instance.
(I've had to do this frequently because some of my users...
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: Jobs that missed their schedule
Maybe you can get on the road with this :
(its a script I use to gather backup-job-info)
-- alzdba dd 08/01/2004
-- request Backup-job info
set nocount on
-- check BOL
select substring(case server...
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: SQLserver2ksp3a on W2Ksp4 only loging warnings in Win-eventlog
I was thinking it should be something like that.
Did I overlook that documentation ?
Where/how did 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: Execute job question
I'm using alerts to perform these kind of task.
- Cmdshell stays closed.
- dba has control on jobs running on db-servers
- alertno-ranges support portability (DRP)
Test this...
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: ADO holding SQL Connection Open, WHY?
As always : it depends.
.Net will definitely go for disconnected data with closed connections. Because of connection pooling, the overhead for having a "new" connection is minimised.
Same goes for others....
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: why fully qualified table names for read-only access?
Also please do check : "Is the Schema Still Needed?" http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=32&messageid=11677 and the comments on 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 - 7,186 through 7,200 (of 7,500 total)