Viewing 15 posts - 5,641 through 5,655 (of 6,678 total)
To only affect those indexes that have more than 1000 pages:
Selectobject_id As ObjectId
,index_id As IndexId
,partition_number As PartitionNumber
,avg_fragmentation_in_percent As AvgFrag
,page_count As PageCount
,index_type_desc As IndexType
Into #work_to_do
...
February 6, 2009 at 4:31 pm
If you are running Enterprise Edition - you have the option of rebuilding indexes ONLINE. As it is currently written, those indexes being rebuilt will not be available -...
February 6, 2009 at 3:39 pm
This is a simple OUTER JOIN query - look it up in Books Online for further information.
SELECT ...
FROM dbo.TableA a
LEFT OUTER JOIN dbo.TableB b...
February 6, 2009 at 3:19 pm
What have you tried so far? And, what version of SQL Server 2005? Check the version for both the database and the client tools you are using.
February 6, 2009 at 3:06 pm
I wouldn't think so, because that is only needed to enable the full checks on a database that was upgraded from 2000.
If the database has already had that done (e.g....
February 6, 2009 at 1:46 pm
Tom.Thomson (2/3/2009)
It seems expensive to me, re-ednabling the clustered index implies rebuilding every index on the table.
With SQL Server 2005 and greater, rebuilding the clustered index does not force a...
February 4, 2009 at 2:43 pm
Neither - fill factor is defined for each index. If you are looking at the fill factor for the clustered index, then you are looking at the table.
To find...
February 3, 2009 at 1:28 pm
Also realize that once you break the log chain (truncating the log this way will break it) - trying to backup the log later will fail. Since you are...
January 30, 2009 at 4:30 pm
You really cannot depend upon Task Manager. You can use perfmon to determine the exact usage of memory.
January 29, 2009 at 9:40 am
BTW - setting max memory to 26GB may be too high for Standard edition. You'll want to monitor the system and lower the max memory if you start to...
January 28, 2009 at 4:36 pm
Select 27262976 / 1024 / 1024;
Why do you think the system is not using 26GB of memory?
January 28, 2009 at 4:32 pm
Just so you know, /PAE and /3GB have no affect on 64bit systems. You do not have to turn on AWE in SQL Server either. SQL Server on...
January 28, 2009 at 4:26 pm
It is perfectly valid to create an updatable view on two separate tables. There are certain rules that need to be followed, but you can definitely create a veiw...
January 28, 2009 at 4:20 pm
To expand a little on what Gail started - in a parameterized query where the objects are not schema qualified, even if it is exactly the same it will generate...
January 28, 2009 at 3:48 pm
Really couldn't say for sure - but, I would think you would run into performance problems with this new setup. Basically, you are going from using 12 (3 systems...
January 27, 2009 at 4:12 pm
Viewing 15 posts - 5,641 through 5,655 (of 6,678 total)