Forum Replies Created
Viewing 15 posts - 5,641 through 5,655 (of 7,499 total)
-
RE: Oracle Data to MS SQL Server 2005
- g8r65 provided the way to connect it.
- In case you want to migrate from oracle to 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: Can this query be optimized
there is also the matter of :
... AND A.teller_id not in (SELECT teller_id
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: !!! Confusion on security logins please assist !!!
- keep in mind sp_change_users_login should be executed with a connection to the troubled database !!
- if it returns no rows, all users are mapped ! So the
- 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: Can this query be optimized
maybe this solution is also worth comparing to the other plans and execution times
SELECT
-- distinct is not...
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: 40gig templog - What to do
Like Antares686 said, profiler is mostly used for troubleshooting, so you only add the overhead for a controled period of time. In 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: !!! Confusion on security logins please assist !!!
- exec sp_helpsrvrolemember @srvrolename = 'sysadmin'
(Is builtin\administrators not removed ?)
- use your_troubled_db
EXEC master..xp_logininfo @acctname = 'youruser',@option = 'all'
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: 40gig templog - What to do
- keep your profiler running ! so you can see growth is stopped.
- contact your coworker again to monitor his application in detail (profiler) and ask her/him if something has...
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: 40gig templog - What to do
- start a sqlprofiler trace to find out what's going on !
- to shrink tempdb, you'll have to stop/start sqlserver. It will cleanup the db and start with the original...
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 Server 2005 Build List
9.00.3186 Cumulative update package 3 for SQL Server 2005 Service Pack 2
http://support.microsoft.com/default.aspx/kb/939537 released 2007-08-20
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: Ten Reasons to Attend the PASS Summit
And it's a place where (by default) there exist no stupid questions.
(exceptions may occur
)You can...
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 AUTHORITY/ANAONYMOUS LOGIN'''' Error after Windows Update and Restart
- which OS are you using ? W2003, XP, ... ?
- did you have a look at :
- http://support.microsoft.com/kb/925001 ?
- http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=110&messageid=246883
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: Profiler - Logging Results to a Table
If you want to trace in batch, you need to trace to a file !
Afterward you can load the file to a given (empty) table using :
-- HOW TO: Programmatically...
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: large transaction logs
with simple recovery, a transcation is marked to be overwritable (in the transaction log file) once it is committed or rolled back.
You need to make log-backups to keep your transaction logs from...
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: large transaction logs
just open a new thread in sql2005
Which recovery model did you use before sql2005 ?
Keep in mind full recovery logs everything ! (also...
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: Error: 7105
please keep us informed regarding your tests with the sql2005 snapshot isolation level to solve this issue
Also keep in mind 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
Viewing 15 posts - 5,641 through 5,655 (of 7,499 total)