Viewing 15 posts - 1,996 through 2,010 (of 7,499 total)
GilaMonster (6/9/2011)
Is this person irritating anyone else, or am I just in low-tolerance mode at the moment?
Are you in desperate need for coffee 😉
You provided the perfect answer for him...
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 9, 2011 at 4:04 am
It was my pleasure to get a first glimps of your article.
This is a lesser known topic, but definately has its place in SQL instance management topics.
Great 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 9, 2011 at 1:41 am
Please post the full ddl of your object tcsINVTB00026_AttribAsgn
(i.e. script its create statement including all indexes and constraints )
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 9, 2011 at 1:35 am
You need to check this constraint 'AK3tcsINVTB00026_AttribAsgn'
Figure out what it is ( obviously a unique key ) and for which column(s) it goes and figure out what is wrong 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
June 8, 2011 at 2:14 pm
If you mean adding the db name to the result rows ...
SELECT @@servername as ServerName, getdate() - S.login_time as SQLServer_UpDateTime_1900_01_01
, D.name as DbName
FROM sys.dm_exec_sessions S
cross apply sys.databases D
WHERE...
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 8, 2011 at 12:51 pm
if sqlserver is running and the database is open, you cannot delete the file on the operating system.
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 8, 2011 at 6:54 am
Yes
Keep in mind your Witness server doesn't need to be EntEdtn. fwiw it can be an express edtn.
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 7, 2011 at 2:52 pm
mister.magoo (6/7/2011)
ALZDBA (6/7/2011)
SQLRNNR (6/7/2011)
ALZDBA (6/7/2011)
What's with the watermark on our SSC ??Is it webmaster fun, or is SSC changing logo ?
Where do you see this watermark?
I get to see 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 7, 2011 at 2:50 pm
apparently you have declared a unique alternate key (i.e. a unique index)
Double check you are checking all your unique constraints (pk/ak) before qualifying a row for insert
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 7, 2011 at 2:45 pm
Digs (6/7/2011)
I have two large tables that get updated daily or (added to).
I want to run this TSQL daily.
ALTER INDEX ALL ON DIM_Data REORGANIZE
and
DBCC SHRINKDATABASE (MyDB,10);
Say I have...
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 7, 2011 at 1:41 pm
That will only work of the errorlog file hasn't been rolled over ( more than your number of kept files )
If your database has "autoclose off" - which I hope...
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 7, 2011 at 1:33 pm
SQLRNNR (6/7/2011)
ALZDBA (6/7/2011)
What's with the watermark on our SSC ??Is it webmaster fun, or is SSC changing logo ?
Where do you see this watermark?
I get to see it in the...
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 7, 2011 at 1:23 pm
GilaMonster (6/7/2011)
The client-from-hell is no more.
Congratulations !:w00t:
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 7, 2011 at 1:21 pm
What's with the watermark on our SSC ??
Is it webmaster fun, or is SSC changing logo ?
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 7, 2011 at 10:29 am
Lynn Pettis (6/4/2011)
I am going to be grandfather![/i]
Looks like I'll need...
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 6, 2011 at 5:51 am
Viewing 15 posts - 1,996 through 2,010 (of 7,499 total)