MyDoggieJessie (12/21/2012)

---

John Mitchell-245523 (12/21/2012)

---

I would guess that you can't start a job remotely via a linked server. You could try using Powershell or SSIS instead. Or you could...

Sanity check before you change anything. You are trying to connect to MAINPC\SQLExpress through SSMS 2012, corrrect? Have you verified SQL Browser service is running?

For $ I would recommend an exact numeric data type with the scale you need to satisfy your accounting requirements.

well...2000 function calls x 13 months of data per report, while not the typical abuse-pattern, in some circles it...

What exactly does your .tbl file contain and by "execute" do you mean "import"?

No worries. You're doing fine with the use of Scalar UDFs. The way you are using them is actually the only way I support their use. I just do not...

Not unless you can deserialize the object using a SQLCLR object to review its properties, which I highly doubt. There is no native Java capability in SQL Server that would...

Comparing FLOAT and REAL to DECIMAL and NUMERIC is not really fair. The former are approximate numeric data types and the latter are exact numeric data types. I am leaving...

32-bit? Did you enable AWE?

The CTE syntax itself does not require a leading semi-colon. Rather the preceding statement must be terminated with a semi-colon.

Did you install Express Edition?

BenWard (12/17/2012)

---

Hello,

I have a database used for reports that has a bunch of scalar functions on it that generate assorted record counts etc. Scalar functions we know are inefficient but...

Regular views offer nothing from a performance standpoint. Views are simply replaced by their definition in the query submitted for execution and then optimized as if the query submittor had...

Locking pages in memory is definitely something to consider enabling if you are seeing Windows trim the working set from SQL Server. If this were happening you would see sudden...

Have you updated your statistics recently on both databases? If statistics are up to date on one and not the other SQL Server can generate or pick different execution plans...