Viewing 15 posts - 14,386 through 14,400 (of 39,936 total)
I agree with Nicholas, I don't see anything about centralization of data.
I am assuming this means db01 data moved to db02 for reporting. Is this real time? How much delay...
February 7, 2012 at 5:06 pm
george sibbald (2/7/2012)
February 7, 2012 at 3:15 pm
Lynn Pettis (2/7/2012)
Kassondra gave birth to a healthy baby boy yesterday in Germany. Grayson Matthew was born at 11:10 (German time), which is 3:10am mst.
congrats, Grandpa!
February 7, 2012 at 3:05 pm
Is this for DR? Or another purpose? There are P2V tools (physical to virtual) that can capture an image of a machine for migration purposes, but this can work well...
February 7, 2012 at 9:14 am
Koen Verbeeck (2/7/2012)
A bit back on-topic:http://www.sqlservercentral.com/Forums/Topic1247840-364-1.aspx
Not really a worse question, but a weird one. (read all the way to the bottom)
What would justify such a business scenario?
Added a note. I...
February 7, 2012 at 9:12 am
webrunner (2/7/2012)
February 7, 2012 at 9:10 am
What you are asking for, and I'm still not clear on this, is something that is completely custom. There's no way a component is going to be available for pulling...
February 7, 2012 at 9:08 am
You need to examine what is happening when the application is slow. SQL Trace is the best way to do this, along with something like WhoIsActive to find what is...
February 6, 2012 at 4:53 pm
Cadavre (2/6/2012)
Grant Fritchey (2/6/2012)
Go easy on him. He's trying. Gentle guidance, not all up in his grill.
Tried polite and unpolite impolite comments directed at him, neither received a reply so...
February 6, 2012 at 9:25 am
GilaMonster (2/6/2012)
February 6, 2012 at 9:22 am
OK, #5 seems to be fixed. Posting from IE8, and copy/paste to SSMS 2008R2 preserves line breaks for me.
In terms of #s 1 and 2, we have some ideas,...
February 6, 2012 at 8:17 am
Are the 5mm records all the records in the table or are there more than 5mm? If that's the whole table, use truncate. If not, you can batch the deletes...
February 6, 2012 at 8:11 am
David has some good advice. I would personally determine the database size, allow for 3-4 months data growth, and then make sure you can reindex your largest table. Then shrink...
February 6, 2012 at 8:03 am
Koen Verbeeck (2/6/2012)
http://www.sqlservercentral.com/Forums/Topic1246473-391-1.aspx?Update=1
Now he is just copy pasting MSDN articles into the topics. :rolleyes:
At least it had something to do...
February 6, 2012 at 8:00 am
HowardW (2/6/2012)
February 6, 2012 at 7:58 am
Viewing 15 posts - 14,386 through 14,400 (of 39,936 total)