SQL Server Execution Plans By Grant Fritchey

Buy it from Amazon too 😉

bothap (6/27/2012)

---

Good day,

I've been looking around on the internet and there are several articles around for high-availability, though not so much on easy maintainable load-balancing clusters.

Any ideas to the problem...

Many SQL experts I follow and respect (yourself included) caution against accessing large swaths of the proc cache on a live server. I like the idea of setting up a...

7 different OLE DB Data Sources

IIRC MySQL does not expose metadata in compliance with what the SSIS OLE DB destination requires. You could look into a third party OLE DB driver, or look into upgrading...

If it were me I would not take the advice of anyone on a forum for this one. If you have a dev environment, try it there first and find...

If the proc in the other schema is explicitly owned and it is not owned by the same owner as the dbo schema then the ownership chain is broken.

Similarly, if...

bmanning 59285 (6/27/2012)

---

Hi

I am a newbie, I need to give an access to all tables and stored procedures in the database with

select and view permissions only on SQL...

sudhakara (6/27/2012)

---

Standard Edition (64-bit)10.50.2817.0SP1

Getting the registry values (service account,authentication mode,etc)through system stored procedures using sql server integration services.

Not getting the error at the first attempt , its...

ditto

I make a distinction between a Catalog View and a System View where the documentation does not. Catalog Views are dependent on the Catalog/Database Context. System Views return the same...

I've seen similar errors surface. In other cases it pointed towards a bug in the DB engine code. What build are you running?

SELECT SERVERPROPERTY('Edition') AS Edition,

...

True, sys.master_files is not technically a DMV. The DMV acronym is pervasive however, so I use it in place of a lot of objects sometimes, even though that is incorrect....

Big brother must have been watching over me. All is well now 🙂

ScottPletcher (6/26/2012)

---

As I understand it having database files stored across two arrays (data on one array, logs on the other) gives us a better chance of recovering to the point...