sgmunson (7/8/2014)

---

Some of the runtime symptoms of the below suggested causes could be: 1.) sudden CPU usage spikes for however long this runs before it fails, or even 2.) a...

Grant Fritchey (7/8/2014)

---

So you're going to an underpowered machine (8gb is half the memory my laptop has) and you're running a very large aggregation query and returning 1.7 million rows....

GilaMonster (7/7/2014)

---

For anyone that gets frustrated with our posters here, here's a quote from a poster over on a gaming forum...

I was thinking about reactivating my bomber but it occurred...

You can use SQL*Net Easy Configurator:w00t:

ouch

😎

Luis Cazares (7/7/2014)

---

I'll start using Oracle :sick: at my job. As a SQL/BI Developer, it seems that most of the knowledge can be transferred easily between tools, but I'm just...

asiaindian (7/7/2014)

---

Thank you for the response. I am sorry for not giving out the SQL box specifications. It has 256 GB RAM, of which 200 GB is dedicated to SQL...

asiaindian (7/7/2014)

---

Hello,

Environment:

I have a remote server with SQL server 2014 instance on it. There is nothing else running on the SQL Server box(dedicated SQL box). There is only one instance...

KoldCoffee (7/6/2014)

---

The last task following all execute process tasks is a Send Mail task. So, back to matter I'm requesting assistance on (NOT the SSIS package).

Is there a...

Quick thought on this, set the Connection string property of the destination connection manager in an expression. Preferably store the entire string in a variable and only alter the database...

Jeff Moden (7/6/2014)

---

ykonline (7/5/2014)

---

Please find the details below

Date CAD CZK EUR

1/1/20101.052018.34750.6977

1/2/20101.053218.39850.6957

1/3/20101.051718.33600.6982

1/4/20101.037718.16240.6935

1/5/20101.037118.25410.6943

Sometimes we may receive additional(new)...

Not certain what is going on here, the attachment has a schema limitation of varbinary(max) and is consistently handled as such all the way through the process. You could try...

Quick question, what is the result of the following query in msdb?

😎

select *,

CAST(paramvalue AS FLOAT) / POWER(2.0,20) AS MX_IN_MB

FROM msdb.dbo.sysmail_configuration

where paramname = 'MaxFileSize'

A good place to start the white paper of Kimberly Tripp and her posts on partitioning[/url].

😎

Ah! now I get it, you mean the nice quiet days in the office:w00t:

😎

TheSQLGuru (7/5/2014)

---

Eirikur Eiriksson (7/5/2014)

---

I've come across this problem few times in the recent past and found that Implicit conversion from CHAR/VARCHAR to NCHAR/NVARCHAR and vice versa, will cause Index Scans...