Viewing 15 posts - 1,951 through 1,965 (of 7,502 total)
A child table should only refer to the full PK of its parent table. (or another AK is allowed in sqlserver)
as you state you PK of tblSurvey is composed of...
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
June 20, 2011 at 2:21 pm
Just read at Bob Beauchemin'd blog:http://www.sqlskills.com/blogs/bobb/post/Performance-features-in-SQL-Server-2008-RC0-Optimize-for-Adhoc-Workloads.aspx
"stub for the non-parameterized version, plan for the parameterized version"
Could you check/confirm that ?
edited: copied wrong ref.
This was RC0. should have been optimized by now...
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
June 20, 2011 at 1:48 pm
please post the sqlserver errorlog file !
You need to elaborate a bit more regarding your move operation :
- did you shutdown the instance ?
- did you copy the folder structures...
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
June 20, 2011 at 10:24 am
I second GSquared and Gianluca suggestion too.
If your constraint cannot refer to a primary key or another unique constraint, replace the counting to existance check because your check = 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
June 20, 2011 at 10:18 am
Darn, Steve, what happened to the horse ?
How did it get that kind of wound ?
I hope your vet can fix 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
June 18, 2011 at 11:57 am
check the sqlagent log file (sqlagent.out) if it holds some info regarding your troublesome job.
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
June 18, 2011 at 7:33 am
Keep in mind your hashes may produce duplicates as well !
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
June 18, 2011 at 7:31 am
Roy Ernest (6/17/2011)
GilaMonster (6/17/2011)
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
June 18, 2011 at 7:23 am
why aren't you just making that column an identity column.
alter table x
alter column seqnr bigint identity( yourstartvalue, yourincrementvalue ) ;
Keep in mind, you should no longer insert that column !...
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
June 18, 2011 at 2:04 am
Have a look at http://www.sqlservercentral.com/Forums/Topic1126580-146-1.aspx#bm1127227
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
June 17, 2011 at 10:12 am
WayneS (6/16/2011)
Roy Ernest (6/16/2011)
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
June 17, 2011 at 6:43 am
RedGate also has a nice free ebook on statistics.
http://www.red-gate.com/products/dba/sql-monitor/entrypage/statistics-ebook
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
June 17, 2011 at 4:59 am
How about this:
Select ITEMNMBR
, ROW_NUMBER() over (order by (select 1)) * 16384 as SeqNumbr
from IV00101
where ITEMNMBR not in...
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
June 16, 2011 at 11:49 pm
Nice overview !
I always keep in mind this very to the point article by Brent Ozar (@BrentO) regarding our job and virtualization:
http://www.theinfoboom.com/articles/virtualizing-databases-too-big-to-fail/
Pay special attention on the real question !
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
June 16, 2011 at 6:36 am
opc.three (6/15/2011)
How does one get the engine to store -0.00 ?
I tried:
USE test
GO
IF EXISTS ( SELECT *
...
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
June 15, 2011 at 2:10 pm
Viewing 15 posts - 1,951 through 1,965 (of 7,502 total)