Viewing 15 posts - 46 through 60 (of 168 total)
Statistics will be updated automatically after index rebuild. There is no requirement to separately configure this task.
May 26, 2009 at 9:37 pm
Statistics will be updated automatically after index rebuild. There is no requirement to separately configure this task.
May 26, 2009 at 9:37 pm
Statistics will be updated automatically after index rebuild. There is no requirement to separately configure this task.
May 26, 2009 at 9:37 pm
Statistics will be updated automatically after index rebuild. There is no requirement to separately configure this task.
May 26, 2009 at 9:36 pm
Statistics will be updated automatically after index rebuild. There is no requirement to separately configure this task.
May 26, 2009 at 9:35 pm
As said by glen. Rebuilding indexes usually will not benefit much in terms of space. Rebuilding will help to retrieve more data in less pages thus will improve performance. So...
May 19, 2009 at 11:12 pm
If you are planning to migrate all databases or there is only one database in your sql server 2000, then upgrade will be a more better option.
May 12, 2009 at 11:20 pm
The last column media type is small int. It is mapped to different media types as
1 for Floppy
2 for Hard Disk
8 for CD-ROM
4 for Tape ...
April 29, 2009 at 3:21 am
While i am able to take the backup using Backup database command in Query Analyzer....
You mean that you can take backup through Query Analyzer at drives other than J,S?...
April 29, 2009 at 3:08 am
If you are not calling stored procedure with schema prefix, then it is possible that it will not be picked by plan cache every time. So to use SQL profiler...
April 29, 2009 at 3:03 am
Atif if you dont mind do you know any article or place where i can find step-by-step setup of data encryption in SQL Server 2005 (Asymetric key/Symetric key) please?
Recently while...
April 24, 2009 at 9:28 pm
The 7373 error code may refer to any errors in the ole db provider itself. Also you may check that ports for your server (1434 and 2383) are listening...
April 23, 2009 at 9:52 pm
Have you tried to create database through script with same parameter values? If you successfully create through script then there is some specific problem with SSMS environment else you may...
April 23, 2009 at 9:45 pm
Seconding the Gila, i will suggest the covering indexes. Also you may analyze the SQL Server recommendations about missing indexes http://blog.dbdigger.com/2009/04/get-information-about-missing-indexes.html
April 21, 2009 at 4:44 am
Even then indexes on all columns will not be a better approach. Columns mostly used in where clause may be choose as index clients.
April 21, 2009 at 4:21 am
Viewing 15 posts - 46 through 60 (of 168 total)