Viewing 15 posts - 3,271 through 3,285 (of 7,506 total)
In that case you may be able to do a side by side install of your web edition.
The prepare that instance by adding the needed logins, and restoring/attach the userdb...
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 15, 2009 at 4:07 am
parthi-1705 (12/15/2009)
Actually datas are populated yesterday only i am having the backup on weekly basis thats why i could not able to get the data.
How to find which user...
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 15, 2009 at 4:01 am
it's a petty the plan doesn't show all the batch SQL
Just for a starters ....
IMO the first query should have this alternative tested/compared with:
select submittal.recruiter_source as recr
...
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 15, 2009 at 3:35 am
parthi-1705 (12/15/2009)
.. which are all important... I am not having backup or Trans log ...
It's a petty you need to find this "missing link" the hard way :crying:
You need 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 15, 2009 at 3:06 am
Have a look at:
http://msdn.microsoft.com/en-us/library/ms143393.aspx
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 15, 2009 at 2:56 am
- Also keep in mind that calling a sproc without providing the correct parameters (DATATYPE !) can cause bad performing queries as well ! (caused by implicit conversions !!)
-...
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 15, 2009 at 2:53 am
I hope this little test script will provide some insight on the timestamp data type.
/****** 🙂 best regards ALZDBA ******/
set nocount on
go
/*
@@DBTS returns the last-used timestamp value of the current...
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:45 am
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
Viewing 15 posts - 3,271 through 3,285 (of 7,506 total)