:blink: :blink: Where's my donckey 😀

I've been reading a bit on the cloud topic ..... already forgot the obvious :blush:

At my plant, we only have CI databases.

I have...

FWIW: concering the "dangers" of CLR modules ....

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

- http://www.sqlservercentral.com/Forums/Topic483423-386-1.aspx

Are you refering to SQL in the Cloud ?

I don't know :unsure:

We're not into cloud surfing .... at least not yet 😀

Hopping in way to late for this thread, but as I was confronted with application roles nolonger working in SQL2005 for a restored SQL2000 database....

BOL states:

The encrypt option is not...

I think you should alter one db to primary

Check "Pausing and Resuming Database Mirroring " in BOL !

Check "Database Mirroring How-to Topics " in BOL !

from BOL topic "How to:...

As Gail stated, CLR is not a replacement for TSQL procedures, it is just an addition to help where TSQL isn't performing well or just cannot do it.

Regarding content visibility:

-...

just to add a little bit :

- Keep in mind Connection pooling also keeps connections open ! By default it will retain at least one distinct connection for 60 seconds...

Ron (8/31/2009)

---

ALZDBA (8/31/2009)

---

That's because you have the condition on the SAP_Cust in the where clause, so are excluding NULLs (which are the non matching)

Alter your where clause to

WHERE dbo_SAP_CUST.KUNNR <...

Never use 'sa' !

Consider it only to be in SQLServer to get started and to perform some very basic SQLServer service tasks !

Create your own set of accounts.

Prefer windows...

That's because you have the condition on the SAP_Cust in the where clause, so are excluding NULLs (which are the non matching)

Alter your where clause to

WHERE dbo_SAP_CUST.KUNNR < '0000900000'

or...

can this be your Select query ... a little bit rewritten to avoid the row level count/sum selects ?

SELECT T.SectionID

, T.SectionOrder

...

another guess:

Wat's the relation for ScheduleUserID to the actual user and the actual test (s)he is conducting ?

Can a person take the same test more than once ?

You update query...

just my 2ct:

- your rows indeed aren't that wide, so this number of rows should be manageble.

- does your table have a clustering index (I guess it does, if you...

when removing a CLIX, the data will get rewritten to an 0 index (=heap).

Check out the structural changes of a heap vs a clustering index, and the effect this has...

- any chance on using SSIS to migrate your data from SQL to Oracle or the other way around ?

- if not, maybe a SQLCLR proc can help out. Also...