Luis,

you might be chasing Red Herrings here, does this happen just after the full backups?

😎

Eric M Russell (3/18/2016)

---

Eirikur Eiriksson (3/18/2016)

---

Easy enough, if differential backups are consistently 0 in content and no...

Easy enough, if differential backups are consistently 0 in content and no connections are made to the...

mburbea (3/18/2016)

---

Can you post your test script? I suspect that since delimited8k did so well and string_split did so poorly, this might be related to that optimization that can be...

Here is a more complete example with some error handling and listing of the tables with the date extracted from the name.

😎

USE tempdb;

GO

SET NOCOUNT ON;

--http://www.sqlservercentral.com/Forums/FindPost1770476.aspx

-------------------------------

-- DATE SATAMP THE TABLE

-------------------------------

DECLARE @TABLE_NAME...

pbo71465 (3/17/2016)

---

Hi Forum,

I'm creating a file each day that is created as follows;

[/Select a,b,c, INTO dbo.MyResults from Table1 quote]

I would like to keep each days file so I need a...

Just added the string_split function to Jeff's harness and Ouch :pinch:, what a mess! Not only is it slower than anything else in the harness, the Lead() version comes second...

Found this sample in my collection, probably posted it somewhere before, feel free to play around with it.

😎

USE TEEST;

GO

SET NOCOUNT ON;

/* DDL Audit table

--TRUNCATE TABLE dbo.TBL_TEST_DDL_AUDIT

*/

IF OBJECT_ID(N'dbo.TBL_TEST_DDL_AUDIT') IS NULL

BEGIN

CREATE...

Use DBCC PAGE to get the object I'd, then it is easy to find the table

😎

Eirikur Eiriksson (3/15/2016)

---

hoseam (3/15/2016)

---

I have this query

DECLARE @TheDate DATE

IF @TheDate IS NULL

SET @TheDate = GETDATE()

SET @FileName = 'DailyAgentSales' + CONVERT(CHAR(8) ,@TheDate -1 ,112) + '.csv'

SET @Subject = 'Agent Sales -...

hoseam (3/15/2016)

---

I have this query

DECLARE @TheDate DATE

IF @TheDate IS NULL

SET @TheDate = GETDATE()

SET @FileName = 'DailyAgentSales' + CONVERT(CHAR(8) ,@TheDate -1 ,112) + '.csv'

SET @Subject = 'Agent Sales - ' +...

Brandie Tarvin (3/14/2016)

---

😛

Still not sure if I like Data Tools...

I think you are missing the Calculated Table. If you go to the Data View, Modeling, New Table and enter

DIM_DATE = CALENDAR(DATE(2016,1,1),DATE(2016,12,31)) it will produce a date table for the...

Are you using it as a measure/calculate table?

😎

This should work, I have models using this so I wonder why it doesn't work in your case, your version certainly supports it.

😎

BTW: I normally use a similar function as...