Trouble Shooter (4/12/2010)

---

select * from tempdb.dbo.sysobjects where name=<Table Name>"

That statement will check the existance of temp table in temp database if it is exists in temp db it will not...

We can also do it with APPLY and TOP 😀

With ROWCOUNT, you'd need to use...

Kudos to Ron for creating sample data for you.

I have to say though, that this is usually a poor design idea - storing more than one attribute in a single...

Yep. No worries!

The name is Paul. And 'you' is spelt with three letters.

Your post:

"Use can...

If you mean me - and my name is Paul - then no. There was nothing to try.

The original post said:

"That is...

Latin1_General_CI_AI is a Windows collation - SQL Server just uses a copy of the rules used by Windows. Latin1_General_CI_AI corresponds to US English (en-us) LCID 1033. You...

Cool - thanks!

Have you read that White Paper already?! :w00t:

As an aside (not really too relevant to this thread), performance is vastly better using CONVERT too.

Using the 2-million row test rig from:

http://blogs.msdn.com/sqlprogrammability/archive/2008/10/31/sql-server-2008-new-binary-hex-string-conversion-functionality-can-dramatically-improve-related-query-performance-by-orders-of-magnitude.aspx

Time using sys.fn_varbintohexstr: 1m 47s

Time using CONVERT: 1s

:w00t:

This might help:

Database Mirroring Best Practices and Performance Considerations (MSDN Technical...

It might not even be possible. On a 32-bit server, ten worker threads are required per mirrored database -...

I feel I am missing something vital here...:unsure:

Is that a joke of some kind?

And what was that very good reason you mentioned?...

To be clear about my own personal position on this: most tables benefit from having a clustered index, though there are cases where a heap may be 'better'.

tony.turner (4/9/2010)

---

On the other hand a large heap (no clustered index) would INSERT very slowly (I have come across some prize examples of same). You may also want to check...