I think this is a common problem in the data world for sure.

It all comes down to self-awareness and communication. Knowing your strengths, weaknesses and limitations, then knowing how...

lawson2305 (5/3/2016)

---

Well it helps if it is accurate which I'm guessing it is. The two scheduled jobs that exist in the SQL agent job list for these maintenance plans...

This likely wont help but it's worth noting that, if it is scheduled as a SQL Agent Job the default job owner will be the person that created the maintenance...

1. Full Text Indexing isn't going to help you here

2. returning XML data in a SQL query is generally...

Luis Cazares (5/3/2016)

---

Alan.B (5/2/2016)

---

terry999 (5/2/2016)

---

Hi

I got this error on a scheduled integrity check. SQL 2005 sp2

Data row does not have a matching index row in the index '' (ID...

+1000

terry999 (5/2/2016)

---

Hi

I got this error on a scheduled integrity check. SQL 2005 sp2

Data row does not have a matching index row in the index '' (ID 2). Possible missing...

I can't answer this but would suggest moving the Access to SQL Server. Then joins get much easier.

TheComedian (5/2/2016)

---

I have an XML file that generates about 10 output tables when loaded into an XML source component. The natural solution would be either to:

i) store them into...

You can execute stored procedures from SSRS. Anything that you can do in a view you could also do in a subquery or temp table inside a stored procedure; a...

Broniz (5/1/2016)

---

Thanks a lot Alan.

I wanted to try using SQL Snapshots for the BI and Excel, but I'll try using replication.

I'm in middle of using Diskspd to get...

I would start by separating the transactional data from the reporting data if that hasn't already been done.

For example, take this:

- Excel connected to the live system doing queries...

What format is the XML in? Is it in a table? An external file?

If you can handle it as a variable this will do the trick.

-- your lookup...

Spam reported.

SSRS is part of the Microsoft "BI stack" and is part of SQL Server. When you install SQL Server you have the option to include different parts of the BI...