Jeff Moden (5/3/2011)

---

ALZDBA (5/3/2011)

---

It's a pity some obscure character caught the attention of CNN, Bloomberg, Al Jazera, ... the day your great article got published.

For sure it would have...

It's a pity some obscure character caught the attention of CNN, Bloomberg, Al Jazera, ... the day your great article got published.

For sure it would have been a headliner...

IMO this thread http://www.sqlservercentral.com/Forums/Topic1044430-391-1.aspx is a very good ref on DISK/SAN troubleshooting.

did you check these resources :

- http://sqlblog.com/blogs/adam_machanic/archive/2010/05/28/sql-university-parallelism-week-part-3-settings-and-options.aspx

- http://www.sqlservercentral.com/blogs/glennberry/archive/2011/2/25/some-suggested-sql-server-2008-r2-instance-configuration-settings.aspx

are you running the same edition ( standard + standard / ent + ent )

Can you find any in info in the errorlog files of both instances ?

How about capturing...

Aaarch i overlooked the fact this thread is in the ssis forum, hence my nonsense answer to your Q.

Sorry for that.:blush:

Some state this setting is only for 64-bit.

http://msdn2.microsoft.com/en-us/library/aa366720.aspx

states "?WOW64 on Intel Itanium-based systems does not support 32-bit applications that use this feature. The applications should be recompiled as native 64-bit...

niteshrajgopal (4/29/2011)

---

Hi ALZDBA,

This looks very promising:-D I realised now that I need to return the table from a Function. I tried pasting the code into a Table Valued Function but...

Is this what you are looking for ?

Declare @Address table (FullAddress varchar(500) , Address1 varchar(500), Address2 varchar(500))

insert into @Address ( FullAddress ) values ( 'c/o Joel Robuck')

insert into @Address (...

apparently your mirroring partner hasn't been reachable.

Once both partners can see each other again, the mirroring will start to pull over the "missed" transactions and get itself into a "mirrored/synchronized/restoring"...

Maybe this can get you started

DECLARE @Loggings TABLE

(

[DATE] DATETIME NOT NULL

,[NAME] VARCHAR(100) NOT NULL

,[QTY] INT NOT NULL

...

Is deprecated ancient syntax ! ( get rid of it ! )

from BOL SQL2000:

Transact-SQL Joins

In earlier versions of Microsoft® SQL Server™ 2000, left and right outer join conditions were specified...

Jeff Moden (4/28/2011)

---

Good golly, I missed it! I missed them both, in fact. Gail has recently gone over the 23K post mark and I passed the 25K...

Ninja's_RGR'us (4/28/2011)

---

Thanks Albaza.

I'll put in an official request for my toy DB and I'll go from there.

We have a test environement but I can't overwrite it at will...

http://msdn.microsoft.com/en-us/library/ms174901%28v=sql.90%29.aspx

AFAIK: 3ways:

- the bol profiler way: http://msdn.microsoft.com/en-us/library/ms189604%28v=SQL.90%29.aspx

- the dta way: database tuning advisor ( been a while since I used that tool so I don't know how far that will...