Viewing 15 posts - 3,376 through 3,390 (of 18,926 total)
GilaMonster (8/10/2011)
Ninja's_RGR'us (8/10/2011)
Ok, building a table... I just thought this would make a darn good point in the conversation for people reading this thread :Whistling:
It's 10pm here. Not doing...
August 10, 2011 at 1:46 pm
P.P.S. Told the dev As the DBA, decided to setup maintenance to always backup all dbs and make sure they are in full recovery and also backup the...
August 10, 2011 at 1:42 pm
dwh-1095413 (8/10/2011)
August 10, 2011 at 1:39 pm
Well if the diffs ran it means you took at least 1 full. Track that untill you hear it's deleted by x on y date and it's not anywhere...
August 10, 2011 at 1:38 pm
GilaMonster (8/10/2011)
Ninja's_RGR'us (8/10/2011)
...and which one does auto_update stats run?
None of them. All of those are manual stats updates
As for 'which behaviour does auto update have', well, is the SQL Server...
August 10, 2011 at 1:36 pm
Can't be read only if you got that error => http://sqlblog.com/blogs/andrew_kelly/archive/2009/04/10/how-dirty-are-your-reads.aspx
Bottom line is don't use nolock unless you don't care about the accuracy results and getting your connection killed...
August 10, 2011 at 1:34 pm
dwh-1095413 (8/10/2011)
So a few days after the database was created, some of the datafiles were accidentally deleted while trying to move them around on drives.
That's the exact reason why...
August 10, 2011 at 1:32 pm
...and which one does auto_update stats run?
August 10, 2011 at 1:30 pm
Linked server to text file could do it (never tried)
bcp out.
August 10, 2011 at 1:28 pm
For an amazing crash-course on recovery (75 minutes by the guy who wrote the code for microsoft) :
http://channel9.msdn.com/Events/TechEd/NorthAmerica/2008/DAT375
August 10, 2011 at 1:17 pm
Actually you need to see (and show us) the real values.
Run the select without the filters, run select @sincedate what you are filtering one, also select a new column =>...
August 10, 2011 at 1:15 pm
It makes a copy while sorting.
Once done it deletes the old one and swap the new one in.
You should see the datafile bigger, but with more free space (used you...
August 10, 2011 at 1:13 pm
use that to split.
http://www.sqlservercentral.com/articles/Tally+Table/72993/
Then use this technique to pivot (or just the native pivot in tsql).
Select columns, MAX(CASE WHEN RowId = 1 THEN Value ELSE NULL END) AS Email1, MAX(CASE...
August 10, 2011 at 1:12 pm
You're toasted.
anyway you have the corrupt datafiles? That's pretty much you're only shot of getting back online.
August 10, 2011 at 1:09 pm
Brandie Tarvin (8/10/2011)
george sibbald (8/10/2011)
@Remidarn them for closing it. worth another comment asking for it to be looked at again?
I just looked at it. It's open again.
Except for the part...
August 10, 2011 at 1:07 pm
Viewing 15 posts - 3,376 through 3,390 (of 18,926 total)