Forum Replies Created
Viewing 15 posts - 6,736 through 6,750 (of 7,499 total)
-
RE: cycles or multiple cascade error
trivial, but overlooked it 
Nice...
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" way to implement multi-user query
how about using transactions to get isolation ?
Offcourse everything has a price !
CREATE PROCEDURE GetColor
@OutRowID INT OUTPUT
AS
BEGIN
-- print statements added for debugging
SET NOCOUNT ON
declare @trancount int
set @trancount...
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: RESTORE DATABASE PROBLEM
firts : ALTER DATABASE yourDB Set [RESTRICTED_USER , ]
READ_only WITH ROLLBACK IMMEDIATE
then perform your restore.
After restore, the db will be in the same state as it was when...
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: cycles or multiple cascade error
where is your query or error-generation command ?
select ...
from employee E
inner join Rooms R
on E.EmpRoomNum = R.RoomNum
inner join Device D
on D.DeVRoomNum = R.RoomNum
and D.DevSignByEmp = E.EmpID
would be...
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 renamed the file and it does not work"
.Bak files should be restored
check restore database in books onlineI didn't check the forum-group
Now my responce...
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''''t see other Drives on Computer For Backup Location?
Is this a clustered server ?
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 UNIQUE INDEX terminated
EnterpriseManagers does not autorefresh.
If you don't trust its results, disconnect and connect again so it refreshes all catalog-data.
Hitting F5 at the tables-tree in the lefthand pain, also may help.
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 UNIQUE INDEX terminated
check this site's search : "remove duplicates".
Test it before going live !
Many of us use Query Analyzer to perform this kind of stuff.
(Enterprise...
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 UNIQUE INDEX terminated
Thanks for the addition, Frank.
I was to much in a hurry for my lunchbreak.
.... and lost...
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 UNIQUE INDEX terminated
select yourkeycolum(s) , count(*) as counter
from your_object
group by yourkeycolum(s)
having count(*) > 1
-- order by yourkeycolum(s)
I hope this helps
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: Frank''''s Addition to Family
I'ts always a nice year if you can look back on it
Be patient, be strong and shut off your nose
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: Is There a Query for this
also check this function :
http://www.sqlservercentral.com/scripts/contributions/1199.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: convert varchar to decimal
actualy I guess it is a rounded value (...6667)
You might also consider float-datatype
set nocount on
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: convert varchar to decimal
you might try this :
set nocount on
create table #t1 (col1 varchar(100) not null, col2 decimal(8,2) null)
insert into #t1 (col1) values ('.0366666666666666666666666666666666666667')
select * from #t1
update #t1
set col2 = convert(decimal(8,2),substring(col1,1,CHARINDEX (...
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 Performance Issue
Check dbcc spaceused, to find out the index-statistics for your table/index.
dbcc dbreindex yourtable will optimize spaceusage of your table when you'r using a clustered index.
sp_updatestats, dbcc updateusage may help to...
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,736 through 6,750 (of 7,499 total)