Do happen to know what that image size limit is before it kicks in?

You might need to verify the SQL Server Performance counters are installed properly on the server itself. You can query sys.dm_os_performance_counters to more or less confirm if they are installed...

fliu2265 (1/16/2015)

---

Hello,

I have one following expression:

=count(IIF(Fields!degreeAttain.Value = "Yes", Fields!SSN.Value, nothing) )

The result is 0, but I checked the data and I saw "Yes" and "No" for degreeAttain.

I do not get...

I will tackle this one, think I can come up with 2 or 3 short examples.

There is...

arooj300 (1/12/2015)

---

I apologize Shawn, You are correct , this error is coming SQL SERVER agent error log in Version 2005 SP2. By mistake I have posted this issue in this...

ArminJS (1/11/2015)

---

The book is very good, but i dont have the time to read the whole book 😉

But i thought, maybe is her an admin, which knows the best config...

This is generally an error found in the SQL Server Agent error log, not the error log for SQL Server (database engine). This has something to do with SQL Server...

I need help to analyze the performance of our SQL Server 2000.

MDF size is 1.3TB already. It is a virtualized server running in windows server 2003 enterprise.

Memory already increased to...

mxy (1/2/2015)

---

is there a way to extract the execution that was last created/used for a stored procedure.

I try to extract from sys.dm_exec_cached_plans but for some reason it doesnt show for...

RedGate SQL Source Control is only an add-on for SSMS. You would need to find your own solution for source control itself such as Microsoft's Team Foundation or an open...

A standard set of checks that is commonly used in some private sector environments is the IASE STIGs.

They used to have version for SQL Server 2005 and 2008 on the...

Yeah, just caught that. They are not the same according to the code you added. Your file path is missing the "_log"...

SSIS expressions do not accept basic T-SQL queries to calculate things like this. You have to use full SSIS expressions.

Now why your code worked in some and not in others...

You might ensure the physical file has the correct ACL. I have at times had to do this to ensure the ACL matches up on each individual file. I generally...