Browse by Tags
All Tags »
indexes (RSS)
When do you need data partitioning? The data you see in relational database may need such a strategy if the volume is huge, for instance the data to store event-log information having the schema such as: [Id] INT (make this primary key clustered), [Unit_Id]
Read More...
In order to keepup the database logical and physical integrity of all the objects, you must run the DBCC statement such as DBCC CHECKALLOC, DBCC CHECKTABLE and DBCC CHECKCATALOG. Overall you can do this with another statement DBCC CHECKDB that will avoid
Read More...
One of the best features you have in the SQL Server is to create database data file (additional) on fly without having a slow performance affect on existing connections. But think about how SQL Server manages to use server threads for the data file that
Read More...
May 25 2007- From the snippet of Tibor Karaszi , SQL Server MVP I have raised a feedback form on Connect.Microsoft website to get newer version (SQL Server 2005) about Index Defragmentation Best practices information. Vote your interest to get newer documentation
Read More...
By default SQL Server automatically creates the internal tables for Full-text search, XML indexes and Service broker. These are also created when a user query is written poorly that uses tempdb heavily. At they are called internal tables but do not contain
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...
When it comes to resolving table fragmentation, the basic checkout you perform is to run DBCC INDEXDEFRAG or even run DBCC DBREINDEX statements. As per the default configuraiton SQL Database Engine allocates a new extent to an allocation unit only when
Read More...
All of sudden the re-org of an index started failing and no error was displayed within that scheduled job we execute. After executing the code from Query Editior I was able to get the message as follows: Msg 2552, Level 16, State 1, Line 3 The index "<name>"
Read More...
I believe since Windows 2000 server days you can take advantage of Indexing Service that creates indexes of the contents and properties of all files on local and network drives in order to increase file searching speed. It's quite similar to "Find Fast"
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...