Viewing 15 posts - 45,016 through 45,030 (of 49,571 total)
Select name, index_id from sys.indexes where object_name(object_id) = < Table name >
August 15, 2008 at 10:41 am
Task manager is not necessarily accurate for SQL Server memory, especially if you have AWE enabled.
Use Perfmon and look at process(sqlservr): working set or SQL Server buffer manager:Total server memory
August 15, 2008 at 10:31 am
ALTER INDEX ... REBUILD
or
ALTER INDEX ... REORGANIZE
August 15, 2008 at 10:30 am
Mostly, just the logical scan fragmentation %
Above 30%, rebuild the index. Between around 15 and 30, reorganise.
August 15, 2008 at 10:22 am
Mangle the table names. We don't care if the tables are Table1, Table2, etc
The SQL optimiser is a cost-based optimiser. It generates plans and compares them on the basis of...
August 15, 2008 at 10:01 am
Patrick Womack (8/15/2008)
Can someone explain to me how the 'size' in the system view is determined? What does it mean or represent?
According to Books Online:
size: Current size of the...
August 15, 2008 at 9:25 am
Ok. Which one are you trying to shrink and what size are you trying to shrink it to?
August 15, 2008 at 9:23 am
A few things that may help you get started. Firstly, if you check Books Online, you will see that the syntax for a trigger is as follows:
CREATE TRIGGER < Trigger...
August 15, 2008 at 9:14 am
Chad Crawford (8/15/2008)
🙁 I was hoping to learn a new word today!
http://dictionary.reference.com/wordoftheday/
😀
August 15, 2008 at 9:09 am
That's for the master database. Please run the query in the database that you are trying to shrink.
August 15, 2008 at 9:06 am
gohsiauken (8/15/2008)
CREATE TRIGGER NewSaleItem
AFTER INSERT ON SALEITEM
REFERENCING NEW ROW AS newRow
FOR EACH ROW
AS
That's not SQL syntax. Looks like it might be Oracle. Not sure.
Is this a SQL Server database,...
August 15, 2008 at 8:29 am
fixfox8 (8/15/2008)
I can not run right now that query, becaus I am running something else. Thanks.
When you can please post the results. I have a suspicion I know what's...
August 15, 2008 at 8:15 am
Who ever said type completely by hand? Management studio can generate all sorts of stubs for queries that are decently formatted and are far faster than typing. (and are fully...
August 15, 2008 at 8:13 am
Crispin Proctor (8/15/2008)
I doubt (not sure though) that it is downwards compatible. i.e. attach a 2008 mdf to a 2005 box.
They're not, as expected. Trying to attach a 2008...
August 15, 2008 at 8:02 am
Look in the SQL server error log, see if there are any relevant messages in there. Look in the windows application event log for the same.
August 15, 2008 at 7:55 am
Viewing 15 posts - 45,016 through 45,030 (of 49,571 total)