dakshinamurthy-655138 (3/3/2010)

---

i tried with the 14 days trial version on my local database and it has really helped me out. Thanks a lot i will be using the same on...

From Books Online topic for UPDATE (Transact-SQL):

SET @variable = column = expression sets the variable to the same value as the column. This differs from SET @variable = column, column...

I've whined about misleading questions in the past, but this one seemed perfectly clear. It asked what was the best option to allocate maximum available RAM to SQL Server...

I'll try this again. Intel processors (and probably most other computer hardware) use IEEE standard floating point representations. Single precision (REAL) uses four bytes and provides 24 bits...

The most obvious benefit of upgrading to 64-bit is that your server can make much better use of memory over 2-3GB. 32-bit systems with extra memory can use AWE...

The "rounding" differences are actually taking place when the numbers are stored as real and float approximate numbers. These are IEEE standard formats, they are in fact documented. ...

Admittedly, almost all of the effort to execute the above query will be spent retrieving the data pages from disk, and it would be difficult to measure the CPU time...

Being editor gives you the power to make up definitions on a whim, but it doesn't make you right.

For instance, in Books Online in the "Moving System Databases" topic, they...

Who's splitting hairs? Invoking a restart of a running server causes it to first shut down, but that's not the only way a restart occurs.

As I thought I made...

How can you claim that the temp table is dropped during a restart? It may or may not be dropped during an orderly shutdown, but on startup a fresh...

The LEN() function ignores trailing spaces, comparing the strings doesn't actually ignore trailing spaces but it pads the shorter string with spaces. The answer's the same either way.

The cursor-less query I posted does exactly that, it builds a query from the metadata. It may not be the exact query you need since I didn't have all...

The query I posted will build the SELECT statement for your views from as many tables as you like, without a cursor. If you don't want the "CREATE VIEW"...

Worrying about linked server performance without knowing what data volumes are involved is probably an example of premature optimization. They perform very well in many situations. My only...

If you can create a linked server to the MySQL source, you can skip SSIS altogether and just write INSERT/SELECT queries in T-SQL. Then you can put your whole...