Shall we make this easier for others?

http://www.sqlservercentral.com/articles/Integration+Services+%28SSIS%29/64585/

Can we ask why it has to be processed record by record?

I seem to recall a systems person at another employer talking about rogue switches/routers causing issues as well. Some individual(s) had brought in personal route/switch (linksys, for example) to...

Third party backup tools that can accomplish the compression/encryption for you.

Brandie Tarvin (9/13/2012)

---

SQLCrazyCertified (9/13/2012)

---

I am trying to shrink to see how much it will free up......if that does not help enough, what about creating a secondary file.....ndf...in another drive......we have...

Well, that's part of it. What about DNS servers, routers, switches, etc?

scogeb (9/13/2012)

---

Eugene Elutin (9/13/2012)

---

Can you try this:

SELECT column1,'99' [a],left(column2,2) , max(column3) [c], 'Yes' [d], 'Test' [e]

,ltrim(rtrim(column1))+ltrim(rtrim(left(column2,2))) as test

INTO #pre1 ...

When did the system start to freeze? Would need to go back and check to be sure, but iirc you say nothing has changed when it started happening? ...

Until you have a failover. When I setup database mirroring in SQL Server 2008 at a previous employer I had to have the maintenance routines setup on both the...

Is this server the only server running SQL Server?

m.henly (9/13/2012)

---

Hi Lynn,

Thanks for the post, off now till friday afternon (gmt) so will have a look and respond after i have abrorbed.

Cheers,

...

The timestamp can also be used to implement optimistic locking. When you read a row of data you also read this column. After the application makes updates, to...

I have to ask, is SQL Server the only component being monitored at this time? Just a gut feeling, but I am having a hard time believing this is...

Be interested in seeing your final query and the function. Pretty sure you are thinking scalar function, but keep in mind that will give you a hit performance wise....

If you have a test or development server where you can do some playing with the code, give the following a try:

drop function [dbo].[BoxedStock];

go

create function [dbo].[BoxedStock] ( @lModelId int)

RETURNS...