SQL* (11/16/2010)

---

Hi,

If i have a job that rebuild all the indexes, and it was in mirroring session.

Before doing the rebuild if "suspend" the mirroring, how the changes will be applied...

i would not install Sharepoint into a shared instance for one reason. the account that is used to install Sharepoint must be given elevated priveldges the the instance. You will...

john.arnott (11/15/2010)

---

How much more efficient is the proposed solution ORDER BY CAST(DATENAME(mm,SomeDateTime) + ' 1900' AS DATETIME)than adding a numerical representation of the month, whether by using MONTH() or DATEPART(),...

N.North (11/15/2010)

---

You could go for casting the month numbers to names in the select rather than in the ORDER BY clause, as it allows you to use MONTH in most...

Kristian Ask (11/15/2010)

---

hugo-939487 (11/15/2010)

---

Another variaton, using the MONTH function:

SELECT [Month] = DATENAME(mm,SomeDateTime),

Amount = SUM(SomeAmount)

FROM #MyHead

WHERE...

and under what account are you attempting to connect the mirrors with?

that is why i talked earlier about domain accounts that run the SQL server services being the same on...

mlabara (11/11/2010)

---

how do i start the replication on both sides? i though once you did it on the primary is automatically started on the mirror? also.. how do i...

oh my.... with "0" dba experience, telling you how to initiate a DB mirror may be a tall order.....

also, are we talking about replication OR database mirroring OR both?

maybe not the best for security but here is how I always set up my database mirrors;

I use a single domain user account to run all the SQL server services...

lmao.. +1 here 😛

great article. will make a future project i know i have coming up much easier...

thanks

you could also copy the whole thing to a USB disk, use unc pathing if available, copy it to a laptop, ftp, etc....

lol. a question that every DBA has asked a DEV at least once...

this is a bit confusing to me??

if you plan on using the existing VMware image, why would you do anything with the DB? are the database disks not a part...

so you can teach an old dog...