I have learned one more thing today, for small queries when we need to run it for all the databses of instance then we are mostly using MSFOREACHDB and WHILE loop or CURSOR to get the data. But with COALESCE i can it do with very small code here, which...

I have learned one more thing today, for small queries when we need to run it for all the databses of instance then we are mostly using MSFOREACHDB and WHILE loop or CURSOR to get the data. But with COALESCE i can it do with very small code here, which...

Read this in MSDN - 16-bit applications are not supported on 64-bit Windows as there is no 16-bit WOW(Windows On Windows) subsystem. Therefore 16-bit applications will need to be replaced with 32-bit or preferably 64-bit compatible versions. 64-bit W...

Its true that native Win64 does not support 16 bits apps, and that started with Windows xp64. But at leat under Windows 7 you can use the "Virtual XP mode" to run your 16bit apps. However, this is not supported on server systems and the smaller edition...

I learned about this from Pinal Dave's blog(You can see the original article in references.) In SQL Server, while creating a table, we can give maximum length of 128 characters. However, while creating temp tables, maximum length can be of 116 chara...

I learned about this from Pinal Dave's blog(You can see the original article in references.) In SQL Server, while creating a table, we can give maximum length of 128 characters. However, while creating temp tables, maximum length can be of 116 chara...

@jlmurphy: I have seen this comment in the web, but it did not work for me. The point is that as soon as you consume the result of the TVF in a SQL statement, things start to mess up. As there's no way to get the results of a TVF than through a surro...

Thanks for calling me a newbie (>5yrs of database development). ![alt text][1] The mismatch was not about "a table" but about ordering in TVFs - maybe that's a newbie thing, too, but alas I learned it - and some others too. [1]: http://www.ren...

I just stumbled across a weird misconception that I'd like to help you to avoid: If you consume the results of a (non-inline) table valued function, the results are not in the same order as if you take the content óf the TVF in your query. So, if you h...

I just stumbled across a weird misconception that I'd like to help you to avoid: If you consume the results of a (non-inline) table valued function, the results are not in the same order as if you take the content óf the TVF in your query. So, if yo...