Forum Replies Created
Viewing 15 posts - 6,601 through 6,615 (of 7,499 total)
-
RE: Importing LogParser.exe data
Maybe this reply is a bit late
I'm using logparser to import print-event-logs to a sql-table.
Once imported, a transfer-script to the proper table 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: How to remove "case-sensitive" property in SQL Server 7.0 Instance?
AFAIK in SQL7 this calls for a reinstall / rebuildmaster at least.
_and_ recreate all userdb and import all data again
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: Another performace issue.
I cannot help with PB
This reply was meanth to be supportive for you to get approval for the app-maintenance-effort.
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: Another performace issue.
just my 2Ct
Rule no 1 in _any_ RDBMS : tell your system what you know ! If you know it's an integer, don't declare a decimal , if you know...
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: DMO for logins, roles and users
this should get you on track :
'script de database
Dim oDatabase As SQLDMO.Database2
Set...
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: Multiple-Instance cluster Q
What kind of diskdefinitions do you have ?
san / nas / other ?
did you take a look at
- http://www.sqlservercentral.com/columnists/bknight/stepbystepclustering.asp
- http://www.sqlservercentral.com/columnists/bknight/clustering_a_sql_server_machine_.asp
- http://www.sql-server-performance.com/clustering_2000.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: Alert not working
my 2ct
- did you stop and restart sqlagent _after_ you enabled the (first) alert ?
- also add traceflag 3605 for more deadlockinfo in the sqlservereventlog.
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: Several languages in the same server....
- you could go for N(var)char solutions and avoid collation issues.
- if you're using a database per collation, _all_ interdb stuff has to perform collation translation to be compatible. 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: Extended challenge for everyone - Answer
great way to proove there is always more than one way to skin a kat
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: update trigger allways gives deadlock in multi-user setup
"...create table link (
recno int identity not null,
recno1 int not null,
recno2 int not null,
objectno varchar(255),
:
:
:
modified_date datetime null constraint [df_link_modified_date] default...
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: Moving databases to new server
If they remain at the same path, there should be no issue if your sqlserver is at exactly the same version/sp/hf...
Just perform the rename-server procedure :
-- (http://www.databasejournal.com/scripts/article.php/1496451)
Create proc uspRenameServer...
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: Moving databases to new server
If you've installed with the same drivemappings/locations, there should be no problems, if you move all db-files to these locations (as they were at the "old" server).
Otherwize, you may have...
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: Evil new network manager
Aha, a new network-rooster a the barn
wanting to galvanize so (s)he is thé employee of the year !1) Don't panic (I know...
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: Advacing the system date, when a job is scheduled on daily basis.
- sqlserver needs some (?) time to check and correct it..
- Can you post an example script for a job where you encounter...
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: dropping table with indentity referenced by FKs
In that case, I hope this can help out
TEST_TEST_TEST
declare @ParentTbName sysname
declare @ParentTbOwner sysname
Select @ParentTbName = 'T_Server' -- = your table to be dropped
,...
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,601 through 6,615 (of 7,499 total)