Viewing 15 posts - 4,051 through 4,065 (of 6,679 total)
bret.quackenbush 86227 (3/9/2010)
One other note, if you a running SQL Server Std x64, in order to get the 'Lock Pages in Memory' feature to work you must be on SP3.
And...
March 9, 2010 at 1:40 pm
pshaship (3/8/2010)
I think you may need to do some investigation as to why your indexes are fragmenting so fast. Are you doing database shrinks?
I'm NOT doing any database shrinks and...
March 8, 2010 at 8:23 pm
Again - this is just one persons personal observations, but it is a person whose opinion I respect (a lot) 🙂
March 8, 2010 at 4:28 pm
Steve Jones - Editor (3/8/2010)
Do you have a 64 bit reference? I haven't seen this.
Even on 32-bit machines, with 2GB of RAM, I haven't seen SQL Server starve the OS....
March 8, 2010 at 3:58 pm
I am not familiar with Veritas clustering, but it sounds like this is an issue with how that is working. On Microsoft clusters, you would reference the VIP instead...
March 8, 2010 at 2:31 pm
Looks like you have a process that is running at the same time as this step in your maintenance plan that is dropping that table.
When the maintenance plan starts, it...
March 8, 2010 at 2:23 pm
sureshdeenu (3/8/2010)
Here I am actully looking to copy my .bak file to a network drive once the backup was done, I want use xp_cmdshell to copy the files
You really don't...
March 8, 2010 at 2:16 pm
Steve Jones - Editor (3/8/2010)
you might want to read...
March 8, 2010 at 2:09 pm
The two previous posts answered the question - if you need additional help, let us know.
March 8, 2010 at 1:48 pm
If the default trace was running when the object was deleted, you can look in the trace file and find when and who dropped the database.
March 6, 2010 at 9:28 pm
simflex-897410 (3/5/2010)
Thanks a lot Jeff.
Your queries beg one question.
So, the only reason you used this -> getdate()) +...
March 6, 2010 at 9:26 am
simflex-897410 (3/5/2010)
All I am trying clear up (for my current and fututre benefit) is that in a situation such as mine, where a fieldname is of DateTime...
March 5, 2010 at 7:15 pm
simflex-897410 (3/5/2010)
Are you saying that just being of dateTime datatype, that last code you wrote would work even though, there is no...
March 5, 2010 at 6:56 pm
There is this tool: http://sqlh2.codeplex.com/
On SQL Server 2008 - you can also implement and use the data collector to monitor multiple systems.
There are other free tools available at the above...
March 5, 2010 at 10:42 am
tluker (3/5/2010)
March 5, 2010 at 10:35 am
Viewing 15 posts - 4,051 through 4,065 (of 6,679 total)