jasona.work (7/5/2013)

---

opc.three (7/5/2013)

---

It might. Or it might randomly skip databases. sp_MsForEachDb is fatally flawed and although Microsoft seems happy enough to employ it within their own Maintenance Plan...

It might. Or it might randomly skip databases. sp_MsForEachDb is fatally flawed and although Microsoft seems happy enough to employ it within their own Maintenance Plan code, it...

If you like sp_msforeachdb you should read this:

A more reliable and more flexible sp_MSforeachdb

Database Snapshots are per database. I would not rely on them for historical reporting mainly because of the recurring need to create and retain additional snapshots. For every snapshot in...

Denesh Naidoo (7/3/2013)

---

Hi All,

Running SQL Server 2008 R2 Enterprise Edition. The environment runs 24/7

Had a normal indexing job...but this was obviously being blocked by user processes.

Changed to Online Indexing...but...

D1rtyD0g (7/3/2013)

---

Hi,

I connect to SQL servers which are all hosted on a virtual environment.

This virtual environment is not our on local network so we have to connect via IP &...

chauhanparixit (7/3/2013)

---

Hi Friends,

I have migrated SQL JOB from SQL2005 to SQL2008, as below

THe step description as below

IF EXISTS (SELECT * FROM someTable)

BEGIN

Exec master..xp_cmdshell "'c:\mypath\someExecutable.exe'"

END

this someExecutable.exe shoule create 4 image files...

Readerless...Google Reader is no more :crying:

joker

OK, now we're getting somewhere. So three replacements after the conversion to XML, and in a specific order to unwind the original encoding. Thanks for clarifying Solomon.

I think you have added an abstraction layer that seems to work but at the end of the day you still have an entitization problem:

I think your approach has the...

This recent thread goes through it in pretty good detail.

http://www.sqlservercentral.com/Forums/Topic1438841-1526-1.aspx

Microsoft could do a better job exposing SQL Agent functionality to non-sysadmins by making some things possible while blocking others...

jasona.work (6/28/2013)

---

I recently ran the "Server Dashboard" report on a new server here. Imagine my reaction to seeing Adhoc Queries sucking up ~75% of the cumulative CPU Usage and...

Solomon Rutzky (7/1/2013)

---

1) XML datatype: This method requires doing 2 explicit REPLACE functions to translate less-than and ampersand characters into their XML-encoded values. The end result is an XML...

I am thinking this might be a PHP problem. From the EXEC() documentation:

Note:

If a program is started with this function, in order for it to continue running in the...