SQL Kiwi (1/11/2012)

---

None of them for the reasons already stated, plus option 2 also contains a race condition.

DECLARE @MYCODE int = NULL

DECLARE @ID int = NULL

DECLARE @OUTPUT TABLE (ID int)

MERGE...

Something else is eating all the memory, apparently.

What else is running on this box?

Also, are you sure you're having memory issues? What's the PLE for this instance?

I can't make your sample data for dbo.account fit into the table defintion you posted.

I get "string or binary data would be truncated".

Sachin 80451 (1/11/2012) - via Private Message

---

does this help:

CREATE TABLE dbo.account

( ID INT IDENTITY(1,1) PRIMARY KEY CLUSTERED,

accountid Varchar(50),

name varchar(50),

Tpl_Traderred INT,

ownerid uniqueidentifier

)

CREATE TABLE dbo.contact

( ownerid uniqueidentifier,

Owneridname nvarchar(160)

)

CREATE...

Brandie Tarvin (1/11/2012)

---

Gianluca Sartori (1/11/2012)

---

It is. I spent two hours with PhotoShop to put Roy's hat in Don's head. Don stole it from...

You could use Ola Hallengren's[/url] maintenance solution for this particular point.

It's a great script.

May be an issue with the column name.

Have you tried enclosing the name in square brackets?

SELECT [Column Name]

FROM SomeTable

I did a quick Google search and I found a fix for your issue.

Here you go:

http://support.microsoft.com/kb/972828/en-us

Well, maybe the backup media got currupted in the network copy. Wouldn't be the first time.

I don't know if you should blame RDP or not.

Is the behaviour consistent?

Is there any...

It is. I spent two hours with PhotoShop to put Roy's hat in Don's head. 😛

Interesting.

Care to link documentation for this bug?

Really?

Do you understand what each step of that procedure does?

If so, would you still recommend it?

Roy Ernest (1/11/2012)

---

WayneS (1/10/2012)

---

Roy Ernest (1/9/2012)

---

I see lots of comments regarding post counts... Does everybody have a target? I have never thought about it at all.

When I get time...

Maybe, indented properly it's less confusing: 😉

WITH MeaningfulCTEName AS (

SELECT c.owneridname as BSC,

z.Tpl_TotalGWP as Total2012,

...

Well, first of all you have to decide what to do with your orphaned users. Fix? Delete?

For windows logins, you probably want to fix.

For SQL logins, you have to decide....