Forum Replies Created
Viewing 15 posts - 7,066 through 7,080 (of 7,502 total)
-
RE: DBCC DBREINDEX Questions
- A rebuildindex will lock the object involved, so might interfere with your apps
- indexdefrag will not optimize as good as rebuildindex
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: non clustered index strategy?
afaik (my guideline)
if the keyvalue(-combination) of your clustered ix is unique, it is designed to be the same.
if not, sqlserver will add a uniquifier to the clustering-index-key(s).
But in this case,...
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: Equivalence of UNSIGNED in T-SQL
- you might use constraints to limit the numbers so only positive values are allowed.
- you could use a trigger so negative values are converted to positive values.
- but why...
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: Read only access to user tables
don't know if it helps...
strConn = strConn & " INTEGRATED SECURITY='sspi';"
quotes added
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: Constraint Questions
- use decimal[(p[, s])] check BOL in stead of float.
- check constaints can help to delimit values :
from BOL :
ALTER TABLE doc_exd
ADD CONSTRAINT exd_check CHECK (column_a between...
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: Read only access to user tables
no.
are the nt-users domain-users ? logged on to the right domain ? member of the correct nt-group ? within the correct dns ?
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: SQL Server SP3a issue
- did you run sp_statistics on all the db after the upgrade ?
- execute your maintenanceplan or rebuild your indexes
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: What is the Best Way for Comparing Datetime value in SQLSERVER 2000?
- I'd only use a udf if there 's a need to be able to use it as a column _in_ a select clause . all others should go 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: What is the Best Way for Comparing Datetime value in SQLSERVER 2000?
- I'd say this is not what I'd call a UDF. Transform it into a normal select.
- remember a UDF works at row-level
- "select isnull(sum(line.totalQty),0)
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: Select Query
Don't worry, must have been a top-secret question 
I see a blank message too.
have a nice day
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: difference between localhost and (local)
is tcp/ip enabled to be used for sqlserver ?
If I'm correct (local) uses namedpipes
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 Agent Question
IMO jobs are "posted" into the active sqlagent-memory. This is done at startuptime of sqlagent or at job-modification time when you use the propre sp's.
Allerts with joblaunch are intercepted by...
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
I don't know if your Grouping is realy needed (all selected columns are involved), but here's me shot :
-- @U_Untagged_T_Tagged_PctSign_All = '%' for ALL rows
-- 'U' for Untagged
-- 'T' for Tagged
Alter...
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: DTS and/or job autorization, anyone?
"However, when I schedule a job on SQL1 with the statement 'select * from SQL2.northwind.dbo.categories' the job runs fine; dito for SQL3. And when I execute the package directly, it...
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: DTS and/or job autorization, anyone?
No, when you open the dts-package and run it, it uses your client-stuff.
I didn't notify in your previous post that you ran it OK with...
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,066 through 7,080 (of 7,502 total)