Viewing 15 posts - 1,621 through 1,635 (of 7,502 total)
just start it from the commandline adding the -m parameter and you should be fine.
I haven't tried to add a fourth registry parameter with the -m .
(each entry can only...
October 27, 2011 at 6:37 am
I would think of a blocking situation causing many waits for your jobstep to proceed.
If you don't have a blocking sampler or monitoring app, this is hard to prove 100%.
October 26, 2011 at 9:12 am
change you db so it uses "auto_close"
( alter database xyz set auto_close ON )
This way your applications - if any - should be able to work, if their timeout survives...
October 24, 2011 at 10:02 am
You don't need to take your instance nor db offline to create valid sqlserver backups.
Have a look at "backup database" in books online.
Keep in mind you also need "backup log"...
October 24, 2011 at 9:57 am
Fal (10/23/2011)
Ah bugger. New Zealand won the Rugby Union World Cup. A certain someone is gonna be absolutely intolerable now. 😛Steve.
Options were cholera or plague. What did...
October 24, 2011 at 12:22 am
M_E_K (10/20/2011)
October 20, 2011 at 11:55 pm
I would NOT take a troublesome db offline !!!! ( unless pss tells me to )
I must have overread it, but anyway here's my primitive Q:
- Does your service account...
October 20, 2011 at 7:44 am
So, that's what do you get when suffering a SQLServer overdose at SQLpass ... Pantoriosis
😀
G'night y'all
October 18, 2011 at 3:41 pm
My second place to check would also be io/ram related.
Any hints in the windows evenlog files ?
Are there other startup processes on these boxes ? (that have the need for...
October 18, 2011 at 8:28 am
Roy Ernest (10/17/2011)
Jack Corbett (10/17/2011)
SQLRNNR (10/17/2011)
Evil Kraig F (10/17/2011)
October 18, 2011 at 12:59 am
best is to set a different value for min and max server memory.
SQLserver can have issues when these values are equal.
If this is a dedicated box, why would you enforce...
October 17, 2011 at 1:32 pm
Roy Ernest (10/17/2011)
October 17, 2011 at 8:22 am
Perry Whittle (10/17/2011)
ALZDBA (10/17/2011)
Perry Whittle (10/11/2011)
Dev @ +91 973 913 6683 (10/11/2011)
I believe ‘;’ is an ANSI SQL statement terminator which you can use with other RDBMS as well.
Oracle...
October 17, 2011 at 6:55 am
Perry Whittle (10/11/2011)
Dev @ +91 973 913 6683 (10/11/2011)
I believe ‘;’ is an ANSI SQL statement terminator which you can use with other RDBMS as well.Oracle uses it too
Since...
October 17, 2011 at 3:19 am
how about using the good old bcp way of doing things ?
October 10, 2011 at 8:48 pm
Viewing 15 posts - 1,621 through 1,635 (of 7,502 total)