Forum Replies Created
Viewing 15 posts - 6,076 through 6,090 (of 7,499 total)
-
RE: local system account on SQL Server Agent
is the share granted public read/write ?
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: Database transfer
read this : http://support.microsoft.com/kb/224071/EN-US/
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: shrinking and Reindexing large database in clustered mode
just to add to Eddie Wuerch 's reply :
- also check if you still use the same recovery mode. Maybe even switch...
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: @@Trancount
I guess you're connected using implicit transactions.
(or use an oledb.begintran statement which switches your connection to "implicit transactions)
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: Enabling trace flag 1204
just to comfort you a bit :
- 1204 and 3605 are set as startup parameters at all our sqlserver instances
(24/7/ +-365)!
- We switch...
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: JumpStartTV - really sucks
I tried it, knowing our network is very outdated, and indeed, it chokes quit often.
It's a pitty, you cannot just download it and watch.
It's also a pitty, there isn't...
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: Msg 504 - Unable to connect to debugger. Ensure that client-side components, such as SQLDBREG.EXE, are installed and registered...
Did you check http://support.microsoft.com/kb/280101/
GRANT EXECUTE ON sp_sdidebug TO public
EXECUTE master..sp_sdidebug 'LEGACY_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: Rename Instance Name on Cluster Server
If I'm correct that cannot be done.
You'll be stuck with creating another instance and moving all the stuff.
or drop the instance (off course keep your datafiles (mdf,ndf,ldf !! and script...
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: space available issue
tempdb should return to its starting size when you restart 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: Event ID 17052
SQLServer version and sp / hotfix ?
this may be a documented bug.
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: Selecting Records in the same calendar week as a date.
maybe you can consider using this function :
use master
if exists (SELECT ROUTINE_NAME
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_TYPE=N'FUNCTION'
AND ROUTINE_SCHEMA=N'dbo'
AND ROUTINE_NAME = N'fn_ALZDBA_convert_date2WeekRange' )
drop function [dbo].[fn_ALZDBA_convert_date2WeekRange]
GO
CREATE FUNCTION dbo.fn_ALZDBA_convert_date2WeekRange...
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: Execution time Query analyser vs. asp page = 5 min vs. 2 hours! Help.
This query may help out .... If you are sysadmin for the sqlserver.
SELECT
ES
.session_id
, ISNULL(
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: Execution time Query analyser vs. asp page = 5 min vs. 2 hours! Help.
I forgot to mention ... What kind of trinsaction isolation level are you using for the connection / command ?
SSMS with uses read committed by default.
I guess your application 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: Execution time Query analyser vs. asp page = 5 min vs. 2 hours! Help.
because you use SQL2005 you can capture very nice execution plan information !
Don't get frightened because they are XML, have a look an you may be surprised how much 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: run scripts in one script
you can also use xp_cmdshell to run isql scripts :
declare @myISQLString varchar(5000)
set @myISQLString = 'isqlw -E -S yourserver -d yourdb -i "yourscriptpathandfile" -o "yourresultpathandfile"'
exec master.dbo.xp_cmdshell @myISQLString
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,076 through 6,090 (of 7,499 total)