RedTram News Search Engine
Русский  English Українська  Français  Polski  Deutsch  Italiano  Español  中文   
8 November 2009 year (time zone GMT 00:00)  Number of sources in English: 4959
Navigating the themes
Navigating the regions
All Themes Technologies Hard & Soft Programming World
Programming (World) RSS 2.0

Using T-SQL CROSS APPLY and OUTER APPLY

08.11.2009 00:46    sqlservercentral.com
That said, even though my personal focus is pretty much OO, I still miss stuff. SQL Server 2005 came out with the CROSS APPLY and OUTER APPLY operators and I have just started learning how to use APPLY in the
Using T-SQL CROSS APPLY and OUTER APPLY


Troubleshooting Reporting Services Performance Issues

08.11.2009 00:46    sqlservercentral.com
The conclusion of our coverage of the Reporting Services component available in SQL Server 2005 Express Edition discusses systematizing the troubleshooting approach by focusing specifically on performance problems (as opposed to those impacting functionality).

Preventing usage of "SELECT *..."

08.11.2009 00:45    sqlservercentral.com
Is there a way to not allow users to use SELECT * in their queries? New author AJ Raghuram has an interesting solution that can prevent this in code.
Preventing usage of "SELECT *..."

The ADO.NET Managed Providers team wants to hear your opinion

08.11.2009 00:45    sqlservercentral.com
Take this survey and help out the Managed Provider team at Microsoft.
The ADO.NET Managed Providers team wants to hear your opinion


SQL Server Unique Constraints for Large Text Columns

08.11.2009 00:45    sqlservercentral.com
We are storing large text and URLs that are over 900 bytes in some of our tables and have a requirement to enforce uniqueness in those columns. But SQL Server has a limitation that index size can't be over 900
SQL Server Unique Constraints for Large Text Columns

Tuning SQL Server 2005 Integration Services for EBCDIC Data Conversion

08.11.2009 00:45    sqlservercentral.com
Loading EBCDIC data into SQL Server is not a well documented process - this article provides a very useful guide to optimizing the performance of this operation. Free "SQL Server Tacklebox" eBook for expert advice on tacklingSQL Server issues and
Tuning SQL Server 2005 Integration Services for EBCDIC Data Conversion

1