Viewing 15 posts - 121 through 135 (of 360 total)
Thanks for the reply andy. Each table has more than 11 Million records and daily I will delete almost 2 million from each table except for last night since it...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
May 29, 2012 at 8:38 am
OK..Thanks
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
May 6, 2012 at 10:29 am
Thanks Paul. We dont have any applications on the Production Database Server except for SQL server. What was happening was some of the backup files were being moved to an...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
May 6, 2012 at 6:57 am
Its a maintenance plan with full scan....I am running this on all the user databases and the biggest of them are
250GB and 80GB rest of them are like less...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
May 3, 2012 at 3:28 pm
No it was not blocked... it took around 3.5 hours to complete.
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
May 3, 2012 at 9:37 am
Thanks george...I will apply the patch on the my test, dev and staging before moving to production.
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
May 2, 2012 at 9:34 am
I have applied SP1:
Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) Apr 2 2010 15:48:46 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
May 2, 2012 at 8:57 am
Thanks George. The version of sql is SS 2008 R2 SE.
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
May 2, 2012 at 8:46 am
Thanks Peter, in my case the text qualifier was empty. But as I mentioned the strings got appended to the column names before and after in the advanced properties window...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
May 2, 2012 at 8:30 am
Thanks for your reply. Right now SQL Server max memory setting is set to 25600MB and I want to change it to 29000 as I have ensured that there are...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
April 30, 2012 at 7:48 pm
Thanks
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
April 24, 2012 at 1:04 pm
Lowell (4/20/2012)
Sapen (4/20/2012)
Lowell (4/20/2012)
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
April 20, 2012 at 9:59 am
Lowell (4/20/2012)
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
April 20, 2012 at 9:08 am
Lowell (4/20/2012)
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
April 20, 2012 at 9:02 am
Sean Lange (4/20/2012)
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
April 20, 2012 at 8:38 am
Viewing 15 posts - 121 through 135 (of 360 total)