Viewing 15 posts - 5,536 through 5,550 (of 7,506 total)
for the SSCM (config manager) you'd have to connect to the physical box on which sqlsever is installed. (authority ?)
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
October 19, 2007 at 8:02 am
You could use :
- start\run Services.msc and start your sqlsever service overthere.
- Or use the SQL Server Configuration Manager, but I don't know it that accompanies SQLExpress. :blush:
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
October 19, 2007 at 7:20 am
check the MDAC level of the devices that are not able to connect to your named instance. It should be at least MDAC2.6 at client level.
btw you can download 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
October 19, 2007 at 7:09 am
you have to take care : SQLserver may want to try to overwrite the original files at the original locations if you work on the same box. !
I must say...
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
October 19, 2007 at 7:04 am
... One of the main differences, and actually a big advantage, is that a CTE can be referred to repeatedly within the following SQL statement unlike a derived table that...
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
October 19, 2007 at 6:42 am
Find out if your sqlserver service account has the needed privileges and the mapped drive for "T:\"
Try using UNC i.e. \\yourserver\yourshare\anotherpath\yourfile.ext
in stead of "t:\..."
With SQL2005 osql has been replaced...
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
October 19, 2007 at 6:34 am
Indeed, that's the first thing we did, specify a max server memory for each instance.
That, along with our implementation of Windows System Resource Manager, makes it all more manageble.
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
October 19, 2007 at 4:59 am
Marcus Farrugia (10/18/2007)
case when column1 =...
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
October 19, 2007 at 12:23 am
We have a 16Gb ram x64 server with a 24Gb pagefile. And we will change that to 4Gb pagefile asap because of this.
During a systems test, the sqlserver instance grabbed...
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
October 18, 2007 at 1:02 am
or in seconds
SELECT substring(convert(char(23),dateadd(ss,A.myavg,DATEADD(dd, DATEDIFF(dd,0,@x), 0)),121),11,8) as myavg
from (
SELECT avg(datediff(ss, DATEADD(dd, DATEDIFF(dd,0,@x), 0), @x)) as myavg
from whatever
)
A
for the moment I have no SSMS, so this tsql is...
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
October 17, 2007 at 1:14 pm
Maybe you'll be better off selecting timeparts from your datetime and averaging those numbers.
Have a look at http://www.sqlservercentral.com/articles/Advanced+Querying/workingwithdatetime/1634/
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
October 17, 2007 at 1:03 pm
maybe just a thought :
Maybe you may want to take a look at log-shipping or another kind of replication ?
Check SSC and BOL 😎
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
October 16, 2007 at 8:08 am
indeed.
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
October 16, 2007 at 8:07 am
yep, a cte may be what you're looking for.
maybe even the (free) "Microsoft SQL Server Migration Assistant for Oracle" may help you out :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
October 16, 2007 at 7:46 am
and if you have doubts, just put it between brackets.
SELECT @myvariable,@myvariable *(-1)
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
October 16, 2007 at 7:39 am
Viewing 15 posts - 5,536 through 5,550 (of 7,506 total)