Viewing 15 posts - 46 through 60 (of 282 total)
ALZDBA (3/7/2012)
can you post SQL2008 version information (sp/cu/@@version + "max server memory" setting for that instance) ?
Version: 10.0.2573.0 (2008 Enterprise)
Memory: 32 gb's
CPU: 4
DB size: 120 gb's
Drive configuration: 8 database...
March 7, 2012 at 2:38 pm
SQLRNNR (3/7/2012)
Will you update the old style join from this:To the new style where Inner Join blah on something = something?
Absolutely, this is the first time seeing this statement which...
March 7, 2012 at 2:31 pm
Sorry about that...I hadn't posted a maintenance plan previously...that works much better 🙂
March 7, 2012 at 1:15 pm
I had found an article by Paul Randal in the past that helped distinguish what events cause changes to the NC indexes, relates to SQL 2005...
January 27, 2012 at 8:05 am
Is this issue resolved?
If it isn't, in the past I have configured the server OS setting that you are making the call to in the following area.
Start --> administrative tools...
January 26, 2012 at 9:14 am
The BIGGEST risk you are going to run into is invalidating that single file with any sort of glitch that may occur during the backup...
At the company I work for...
January 17, 2012 at 10:33 am
Later this week is a large kick off meeting so I will hopefully find out if there are other details or if I am going to be involved...
Thanks for the...
January 4, 2012 at 2:06 pm
I had pondered on that thought...
My only fear is that you go ahead and get all these different databases set up...and then how they are used isn't decided until x...
January 4, 2012 at 1:53 pm
All very good points indeed...
The scope of this 'HUB' has a very large reach...or that is my initial impression...
I hadn't thought about an 'export / import' type process, I guess...
January 4, 2012 at 1:25 pm
I am told the direction / benefit of a 'hub' would that it would allow for a 'plug and play' environment where you can add another system or change out...
January 4, 2012 at 12:59 pm
GilaMonster (10/19/2011)
One thing you must do is fix your autogrow increments so that if the log grows you're not back in this situation soon after.
There you go being pro-active again...
October 19, 2011 at 12:56 pm
Jeff Moden (10/16/2011)
noyb 30173 (10/16/2011)
Next...
October 19, 2011 at 12:27 pm
Sapen (10/12/2011)
October 12, 2011 at 8:08 am
unless you plan on trying to read that 35 gb file I see no reason to use it...
you MIGHT be able to use something like textpad to open it...I would...
October 11, 2011 at 1:03 pm
Is this the sql 'ERROR' log or the sql 'TRANSACTION' log?
SQL Error log
you can cycle the error log so it will create a new one with the following command
Exec Sp_Cycle_Errorlog
I...
October 11, 2011 at 12:00 pm
Viewing 15 posts - 46 through 60 (of 282 total)