Sean Lange (4/22/2013)

---

Lynn Pettis (4/22/2013)

---

You can also use this as a test harness:

set nocount on;

--===== Create the timer and bit-bucket variables and start the timer.

DECLARE @BitBucket sysname; --< change or...

You can also use this as a test harness:

set nocount on;

--===== Create the timer and bit-bucket variables and start the timer.

DECLARE @BitBucket sysname; --< change or add variables needed here...

Here's a tip, if you have typed a long post copy it before you post so you can paste it in a new post if your post time out. ...

Like this:

CREATE FUNCTION [dbo].[ifn_NumOccurrences]

(

@sourceString varchar(1000),

@searchString varchar(10)

)

RETURNS TABLE

AS

return

SELECT numTimes = (DATALENGTH(@sourceString) - DATALENGTH(REPLACE(@sourceString COLLATE Latin1_General_BIN2, @searchString, ''))) / DATALENGTH(@searchString);

GO

As I said, I was taking a SWAG at what it meant. I wasn't have much luck...

As I said, you may want to look at the process and the data. It looks like it thinks it needs 130000 GB of disk space to run a sort.

Chris Hewitt-261101 (4/19/2013)

---

Hi Lynn

17gb of disk space left, so don't surely space cannot be the issue then?

This is on a client old server - only 3.75 gb of ram. Could...

You may want to look at what it is your process is doing and with how much data. If my swag is correct you need 131,081+ GB of disk...

Chris Hewitt-261101 (4/19/2013)

---

Hi there

When running an SSIS package I get the following message:

SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB...

muthyala_51 (4/19/2013)

---

But increasing the response time might not give us the actual root cause why it happened.

I am looking more into I/O error what we received- looks to be DISK...

Sqlism (4/19/2013)

---

html,body{padding:0;margin:0;font-family:Verdana,Geneva,sans-serif;background:#fff;}html{font-size:100%}body{font-size:.75em;line-height:1.5;padding-top:1px;margin-top:-1px;}h1{font-size:2em;margin:.67em 0}h2{font-size:1.5em}h3{font-size:1.16em}h4{font-size:1em}h5{font-size:.83em}h6{font-size:.7em}p{margin:0 0 1em;padding:0 .2em}.t-marker{display:none;}.t-paste-container{position:absolute;left:-10000px;width:1px;height:1px;overflow:hidden}ul,ol{padding-left:2.5em}a{color:#00a}code, pre{font-size:1.23em}

Hi,

I did partitioning on a table on date column as

FILEGROUP= APPLE

.ndf FILES= APPLE_2010, APPLE_2011, APPLE_2012, APPLE_2013

now i am trying to implement sliding window partitioning...

try this:

DECLARE MY_CURSOR Cursor

FOR

SELECT [DB_NAME],[SCHEMA_NAME],[TABLE_NAME],[COLUMN_NAME] FROM dbo.Data_Profile_Stats

Open My_Cursor

DECLARE @DB_NAME nvarchar(500),@SCHEMA_NAME nvarchar(500),@TABLE_NAME nvarchar(500),@COLUMN_NAME nvarchar(500), @QUERY NVARCHAR(MAX)

DECLARE @MAX_NUMBER NVARCHAR(255),

@MIN_NUMBER INT,

...

Maybe the user just wanted to see if it could be done? Other than that, based on the structure and the data I see no reason for th FK.

The structure is only part of the picture, you need to look at the data as well.

Instead of giving us pieces, how about the whole pie.

Can you show us how these queries are being executed? Are they a part of a singe stored procedure, or...