Further on Gianluca's question, all usable details are missing from the error dump you posted, obvious guess for a question would be why the job failed but then there is...

MadAdmin (4/19/2015)

---

exactly what I put into his request for code review of updating stats using nested cursors posted on 7april. To DBA01, Instead...

keshab.basnet (4/19/2015)

---

Thanks Sir.

I take full database and Transaction log backup once a day at night time when there is almost no transaction in database. Can i shrink log file to...

This looks like a typical situation for ELT, load everything as a text into the staging area and then do the conversion afterwards.

😎

Grant Fritchey (4/19/2015)

---

Eirikur Eiriksson (4/19/2015)

---

spaghettidba (4/19/2015)

---

Has anyone seen the last comments for Friday's featured article? I'm sorry for provoking such a bad reaction, I didn't mean to do that.

Did...

spaghettidba (4/19/2015)

---

Has anyone seen the last comments for Friday's featured article? I'm sorry for provoking such a bad reaction, I didn't mean to do that.

Did I say something wrong?...

Second solution, which is more efficient than the previous one as it doesn't use the XML concatenation. The code is somewhat self-explanatory.

😎

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @SAMPLE_STR ...

coool_sweet (4/16/2015)

---

hi

i am adding new field to my existing package which is char(10).

getting this error:

[Flat File Destination [139]] Error: Data conversion failed. The data conversion for column...

Quick question, why not use sys.sp_updatestats?

😎

super48 (4/18/2015)

---

hi

I have 2 packages in my project. I am using 2008 r2

I have made changes to one I dont want to deploy both .I want only one packaged...

Jason-299789 (4/17/2015)

---

Hi

We have Virtual SharePoint DB server with 16GB ram, 1 socket 4 virtual CPU's running at 2ghz.

Yesterday around 6:30am the CPU on this box started going haywire (90%),...

keshab.basnet (4/18/2015)

---

1. my Production log file is 59 GB. and My data file is 44 GB. It seems Log file is larger than Data file. I do regularly Full database...

hurricaneDBA (4/18/2015)

---

Just to clear the water

I am not referencing 2 sessions, i run a script daily and create/drop a local temporary table daily hence my original question was concerning...

Quick solution which uses dbo.DelimitedSplit8K[/url]

😎

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @SAMPLE_STR VARCHAR(500) = 'adventure,devotion,for children,happiness,imagination,love,world,lovely,confusion,introspection,on work and working,on writing and words,';

DECLARE @SEARCH_WORD ...

nicklarge1973 (4/17/2015)

---

Hi. A multi data transfer without ETL transforms, just a 1-1 column transfer finishes 940 tables within a 1 hour 30 minute window. The amount of data transferred is...