Welcome to

SqlServer-QA.net

Sign in | Join | Help

SQL Server Storage Engine & Tools (SSQA.net)

SQL Server Tools includes storage engine that includes a complete set of graphical tools and command prompt utilities that allow users, programmers, and administrators. SSMS, SSRS, SSIS & SSAS are most commonly used tools.

Thursday, July 12, 2007 - Posts

Linked server import problem- Convert FLOAT to Varchar or char or even to INT data type?
I have received a question via email asking for a solution, though solution is simple thought I can blog it. We have a simple linked server connection to import data from a provider.When querying a comma delimited file, why does sql server try to interpret Read More...
Is it possible to estimate the space requirement for TEMPDB or factors that are affecting space?
No straight answer to say yes you need so and so value to set on TEMPDB for such space requriement. By default i t is difficult to estimate the tempdb space requirement for an application. In general and one of the best practice is to allow 20% more space Read More...