Forum Replies Created
Viewing 15 posts - 7,081 through 7,095 (of 7,502 total)
-
RE: DTS and/or job autorization, anyone?
does the sqlserver-service account or the sqlagent-service-account have network authorities to make the connection ?
When you run it using EM, it also uses the rights you - as a windows...
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: Best data type for storing "Hours"
as long as no one
will use your "hours"-column for timecalculations, all workarounds may be fine.If you want to perform timecalculations, be more strict...
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: Joining on and Grouping by CASE function column alias
or use a nested table expression :
SELECT T1.NewColumn, Table2.SelectCol2, count(*) as Counter
from ( select *
CASE WHEN Table1.Name LIKE '%FOO%' THEN 'FOO TOO'
else Table1.Name
END as NewColumn
FROM Table1) T1
inner JOIN...
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: To Default or not to Default
my Ying
says its basicaly the same, but with usage-constraintsmy Yang
says "use the defaults because some...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: Mutually Exclusive NULL
should work like this :
create table t_muteNULL (col1 int identity (1,1) not null, col2 varchar(128) , col3 varchar(128))
go
alter table t_muteNULL
add constraint chkMuteNULL check (case when col2 is null 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: Executed query with error in subquery? why?
it converts it into a correlated subquery
problem ? no problem
one just has to know 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: Create Index vs. Auto Create Statistics
based on system catalog info (designed for sql2k sp3)
select u.name as TbOwner, o.name as TbName , x.name as IxName, xc.name as IxColName, xk.keyno...
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: Declare Cursor performance
http://www.sql-server-performance.com/dp_no_cursors.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: Jobs Stopped working all of a sudden!
- did you see a popup window at serverside "user32.dll failed to initialise..." ? Check KB184802
In that case, sqlagent will wait for a "ok" reply to 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: Controlling Access / Excel from SQL Server
maybe http://www.sqldts.com has what you're looking for
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: Create Index vs. Auto Create Statistics
- _WA** are just statistics, that 's not the same as a regular index.
- However it does give you a hint on which columns are used for searchoperations.
- Use "create...
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: Attachdb will not work
1) - there is no need to perform detach/attach to make a backup !!
That way you'll waste backupspace and you'll have downtime.
-...
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: DB Relationship
Youre welcome, thats what this group is all about
Actualy, there's a little bug because a for delete trigger only has the deleted object...
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: DB Relationship
CREATE TRIGGER TrU_T_Server ON T_Server
FOR delete
AS
if exists (select * from userdb2.dbo.T_ServerDB B
inner join inserted I
on B.idnrserver = I.idnr )
begin
raiserror("There are still dependant rows" ,16,1)
end
go
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: stored procedure does not work overnight
I think there even are some articles regarding SET and ANSI at this site.
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,081 through 7,095 (of 7,502 total)