Forum Replies Created
Viewing 15 posts - 5,986 through 6,000 (of 7,499 total)
-
RE: How do I Concatenate Data together in a "SQL View"
- Which version of sqlserver are you using ??
- With sql2000 you may want to take a look at user defined functions to accomplish this
- with sql2005 a pivot might...
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 have a REALLY easy question!
. means local computer.
.\mylogin is windows-userid mylogin at the local computer. It is not a domainaccount.
Likewize with SSMS you can connect to . meaning you want to connect to the local...
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: Index Searches rate too high
- Did you rebuild the indexes ?
- also manualy run dbcc updateusage and sp_updatestats on all your db or at least on the one where you encounter these alerts.
- try...
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: Way to efficiently make test data?
Check out Data Dude ! Visual Studio Team for DBAs ! Still in CTP, but very valuable for schema-maintenance AND test-data-generation !
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: general question on cluster
with sql2000 you can use
select serverproperty('IsClustered') as IsClustered
Books online document serverproperty !
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: if job is running... turn off step...
just as a litle example :
USE
[msdb]
GO
/****** Object: Job [FlipFlop] Script Date: 12/21/2006 09:44:50 ******/
BEGIN
TRANSACTION
DECLARE
@ReturnCode
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: if job is running... turn off step...
1) keep Mohammed Uddin's note in mind : you cannot influence the running job ! (except stopping it)
2) there is no then...
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: date format problems with xp_cmdshell
fwiw
login using your sqlserver service account and alter its local user settings. and hope nothing else breaks due to 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: date format problems with xp_cmdshell
as you can see, dateformat is a client-problem. What I mean is that the format is set using the client-settings for the logged in user !
That is why dateformatting 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: date format problems with xp_cmdshell
... So, I'm using a stored procedure which reads: xp_cmdshell
osql sp_reportSP blah blah ...within your sp...
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: general question on cluster
no. the available nodes for the sqlserver-instance is totaly managed by the cluster-administrator-software.
The sqlserverinstancename is something you cannot change. drop/create is the way for that.
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: Add a DTS to an existing SQL Server Agent Job
what you see is the encrypted hexadecimal text representing the packagename
you can add another jobstep cmdexec-type with
dtsrun.exe /N package_name
you can find more info in books online (search dtsrun)
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: MSSQLSERVER Service is killing my Domain Account
what happens if you start sqlserver with minimal config from the commandprompt ?
sqlservr.exe -f
look for startup procs and disable them
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: Column Name Variable
Alter PROCEDURE [dbo].[Get_TableValues]
@Value as varchar (100)
AS
begin
set nocount on
if @Value = 'Model_No'
Select Distinct Model_No FROM [IT].[dbo].[test]
if @Value = 'Proj_Engineer'
Select Distinct Proj_Engineer FROM [IT].[dbo].[test]
end
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 to run SQL Profiler from Batch Job
- you can you profiler to generate a trace-script to be executed trace-to-file.
Then schedule a sqljob to activate the trace.
You might even put the trace-part in a stored proc, 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
Viewing 15 posts - 5,986 through 6,000 (of 7,499 total)