Zeal-DBA (1/22/2013)

---

hello experts,

just want to know, if backup is happening for a database and one scheduled job also triggered for the backup of same database at same path with same...

Replication, in all its flavors and in its entirety, might be the most complex HA topic with the most configuration and topology options in SQL Server. It is most certainly...

Joy Smith San (1/21/2013)

---

Hello,

Does anyone have complete PDF/DOC on SQL Server replication ? Which includes configuration, scripts, monitoring etc; ? Of course I get everything from Microsoft web site, it's...

The list will be pretty much the same. As far as I can tell Microsoft is getting out of the business of producing new Extended Stored Procedures (XSPs) and moving...

vuser (1/21/2013)

---

I am installing a product which needs a database - it can use any database as long as there is a jdbc connector available for it. However, the installation...

I checked to be sure and DDL triggers FOR CREATE_TABLE do not fire when a global temp table is created. I do not know of way to accomplish what you're...

You're welcome.

It is, so you probably do not want to key off it unless that is only one of two applications that ever connect to the instance.

You may want to...

OTF (1/21/2013)

---

Nevertheless, it's a term I've seen used by some authors to explain the concepts of Indexes.

I guess only the OP...

Koen Verbeeck (1/21/2013)

---

I do know there were a few performance issues when used in SSIS, but most of them have been solved by CU updates (and SP1 as well I...

I got that part. I am...

sqlserverdba1316 (1/20/2013)

---

Thanks again for the reply...

We don't have 3rd Party backup software as we are using Maintenance Plans for our backup. As with extended stored procedures also. ...

I recently saw Brian Knight do a demo of DQS to cleanse name and address data and it looked useful and robust enough to try it out for real but...

-- all traces

SELECT *...

Nothing is really standing out as holding onto a large amount of virtual memory at the moment. You can also have this issue if the VAS becomes fragmented and there...