Viewing 15 posts - 3,271 through 3,285 (of 7,499 total)
We script all objects of all user databases at least once a week (including all DDL and grant scripts) using SQLSMO.
These scrips a safeguarded in parallel with the visual source...
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
December 13, 2009 at 1:40 am
keep in mind SQLservers db diagram only shows the physical model !
Tools like Erwin, ... can support logical diagrams which will give your DA a good starting point on their...
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
December 13, 2009 at 1:29 am
As you have noticed, you need to "downgrade" your package to SSIS 2005 runtime level, if even possible (because of new features in SSIS2008).
How ?
IMO it is just better 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
December 13, 2009 at 1:23 am
That seem logical to me ...
You simply cannot kill your own sessions actual connection spid.
Questions:
- please provide @@version information
- Did you refresh your object explorer pane ?
- sp_who2 can provide...
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
December 9, 2009 at 11:50 pm
If RowId is an incremental value it may be used.
I hope it is a column of datatype BIGint because chances are that will last for a very long time (if...
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
December 9, 2009 at 12:22 am
James Tech (12/8/2009)
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
December 8, 2009 at 5:44 am
MDAC will not be touched.
XML core components will be affected !
So you may be prompted for a reboot after you apply the service pack.
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
December 8, 2009 at 5:23 am
Once again, Books online covers all of this:
SQL Server 2005 Books Online (November 2008) topic "Stopping Services"
http://msdn.microsoft.com/en-us/library/ms189095%28SQL.90%29.aspx
another ref:
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
December 8, 2009 at 5:20 am
Keep in mind there is no order in a set !
So you have to define "last" using some criteria !
Not having such criteria will cause "random" results, in many cases...
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
December 8, 2009 at 5:12 am
Gail provided you with the answer and good advise;
I just want to add this:
In many cases, if you have an open query panel, just highlight the keyword you are looking...
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
December 8, 2009 at 5:04 am
With these settings it is always interesting to see what happens
if you perform "set nocount on" before you create the udf ....
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
December 7, 2009 at 12:38 pm
This is the sproc we are using.
It also takes care of alerts bound to a job !
This proc is always installed when we install an instance !
Basically what we...
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
December 7, 2009 at 12:35 pm
Did you try this:
ALTER PROCEDURE [dbo].[myStoredProcedurel]
(
@StartDate AS DateTime = NULL
, @EndDate AS DateTime = NULL
)
AS
BEGIN
declare @refStartDate datetime
declare @refEndDate datetime
Set @refStartDate = isnull(@StartDate, dateadd(ms, -3, dateadd(mm, datediff(mm,...
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
November 30, 2009 at 4:50 am
you are using a windows domain account, right ?
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
November 26, 2009 at 1:23 pm
- You'll have to define the alert "with log", because if a user raises the error using "with log" (s)he must be member of sysadmin :ermm:
- you may have 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
November 25, 2009 at 7:25 am
Viewing 15 posts - 3,271 through 3,285 (of 7,499 total)