Browse by Tags
All Tags »
tempdb (RSS)
Configuration of server such as disk and memory is an important factor for SQL Server Performance, there is all about questions within newsgroups and forums that how do I setup the disk layout for a SQL Server database (say, 2005 version). Not only this
Read More...
How can you calculate size of an index in a database whenever a capacity planning exercise if performed? By default the size allocated for each user objects depends on the user application and on the amount of space that is created by the application
Read More...
A new Developer within our testing environment asked me this question to see whether they can use DETACH/ATTACH method than using ALTER database method. For the user databases it is available such method of DETACH/ATTACH method when moving the databases,
Read More...
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...
YOu may be aware that when you deploy the Reporting Services it uses two SQL Server relational databases for internal storage. By default, the databases are named ReportServer and ReportServerTempdb. They are classed as system databases for Reporting
Read More...
Using SSMS tool you can get information on tables, indexes and filegroup information for a database, how about using a TSQL statement: select 'table_name'=object_name(i.id) ,i.indid ,'index_name'=i.name ,i.groupid ,'filegroup'=f.name ,'file_name'=d.physical_name
Read More...
My TEMPDB is full what to do? This is a very common question in the forums and newsgroup, the first and foremost thing to check is to ensure TEMPDB drive has got enough free space to accomodate the calculations that are involved with the queries. This
Read More...