Viewing 15 posts - 1,111 through 1,125 (of 1,518 total)
Jack Corbett (6/6/2008)
Are you using SQL 2000 or 2005? I know you are in a 2005 forum so I assumed 2005, but I found this MS link...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
June 6, 2008 at 1:54 pm
noeld (6/6/2008)
Ahhhh....You have set NOT FOR REPLICATION. With that setting ON SQL Server considers the constraint as UNTRUSTED.
Thank you! But that is bad isn't it?
This is a 3rd party db,...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
June 6, 2008 at 1:12 pm
noeld (6/6/2008)
Can you check if the constraints are DISABLED ?OBJECTPROPERTY ( id , 'CnstIsDisabled')
This returns no rows, ie. all constraints are enabled.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
June 6, 2008 at 12:23 pm
GSquared (6/6/2008)
What does it give you if you run this query:
SELECT OBJECT_NAME(parent_object_id) AS table_name, name
FROM sys.check_constraints
WHERE is_not_trusted = 1
You caught me, I'm on 2000... :blush:
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
June 6, 2008 at 12:00 pm
ok, this does not make any sense to me... :unsure:
I drop the constraint:
IF EXISTS (SELECT * FROM dbo.sysforeignkeys WHERE constid = OBJECT_ID(N'[dbo].[R_100]')
AND fkeyid = OBJECT_ID(N'[dbo].[tblName]'))
ALTER TABLE [dbo].[tblName]...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
June 6, 2008 at 9:47 am
GSquared (6/6/2008)
Have you tried dropping and re-creating them? (With Check, of course.)
Good idea! It's a 3rd party db so I will restore it on my local server and test...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
June 6, 2008 at 8:48 am
TheSQLGuru (6/5/2008)
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
June 5, 2008 at 4:33 pm
GSquared (6/5/2008)
I haven't run into that one. My first guess would be a rights issue.
Thank you, it was a "rights" issue! My NT login - the one I was...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
June 5, 2008 at 1:42 pm
K. Brian Kelley (6/5/2008)
One catch is that any shared components, like Workstation components, SSIS, etc., will be upgraded to SP2.
Thank you, good to know.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
June 5, 2008 at 8:15 am
Deepak (6/4/2008)
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
June 5, 2008 at 7:42 am
Here are a few:
Uncover Hidden Data to Optimize Application Performance
http://msdn.microsoft.com/en-us/magazine/cc135978.aspx
Troubleshooting Performance Problems in SQL Server 2005: http://www.microsoft.com/technet/prodtechnol/sql/2005/tsprfprb.mspx#EUVAE
SQL Server 2005 Performance Tuning using Waits and Queues:
http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/performance_tuning_waits_queues.mspx
Making Sense of your...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
June 4, 2008 at 8:10 pm
David Kranes (6/4/2008)
>>UPDATE STATISTICS tableName WITH FULL SCAN;FULL SCAN should be one word like:
UPDATE STATISTICS tableName WITH FULLSCAN;
Oops, correct, thank you.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
June 4, 2008 at 3:24 pm
Thank you for the feedback.
However, to get the fantastic performance gain associated with unnamed constraints, the temp table needs to be inside another object, such as a stored procedure. Otherwise,...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
June 4, 2008 at 3:19 pm
george sibbald (6/4/2008)
MArios, hot add memory proviso useful to know, thanks.thats the trouble, the playing field keeps changing........
So true, trying to catch up myself... 🙂
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
June 4, 2008 at 1:11 pm
george sibbald (6/4/2008)
the /3GB switch is to access more than 2Gb in the first 4GB of memory. AWE (along with /PAE in the boot.ini) is to access memory above the...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
June 4, 2008 at 10:28 am
Viewing 15 posts - 1,111 through 1,125 (of 1,518 total)