Viewing 15 posts - 706 through 720 (of 2,387 total)
I have no problem to run your script in my test system. What is your SQL Server version and service pack?
January 8, 2004 at 2:12 pm
My understanding you have separate database files for indexes and data, which one is in Primary File group?
Does the 7GB table have clustered indexes? If it has, which file group...
January 8, 2004 at 2:06 pm
Which database did you try to create this sp? Startup procedures must be owned by the database owner in the master database. Try to create it in master database.
January 8, 2004 at 1:55 pm
January 8, 2004 at 12:49 pm
Please post your sp here.
January 8, 2004 at 11:56 am
MSDTC service should already be installed to each nodes of your cluster. What you have to do is to add MSDTC as a clustered resource to your cluster. The KB...
January 8, 2004 at 11:26 am
Access Violation could be SQL Server bugs mostly and you should contact Microsoft SQL Server Support. If it can be confirmed as a bug, They wouldn't charge you.
Did you see...
January 8, 2004 at 10:10 am
Can you recreate your backup device and retry to backup your database? What is your SQL Server version and service pack?
January 8, 2004 at 10:00 am
How large your log backup typically from 9PM to 9AM without performing database shrinking?
DBCC SHRINKDATABASE moves the data and index pages within the database files and such activites should be logged for recovery...
January 8, 2004 at 9:50 am
As more data be added into your tables and changing data in indexed columns everyday, the original query plans used to access its tables may not be effecient than before. At...
January 8, 2004 at 9:30 am
You can schedule a job to run sp_spacesued @updateusgae = true and save the result to your table with datetime. Because sp_spaceused returns two result sets, you need to create your...
January 8, 2004 at 9:01 am
Do you use NT authentication in your DSN setting? If not, try that.
December 30, 2003 at 2:41 pm
SQL Server jobs system works on virtual SQL Server name instead of physical server name. You don't have to modify jobs once SQL Server fails over, All jobs will be...
December 30, 2003 at 2:37 pm
You may add Collate to your statement like select country from customers order by country COLLATE SQL_Latin1_General_Cp1_CS_AS
December 30, 2003 at 1:10 pm
Could your TEMPDB be in the fast I/O RAID disks than your user databases?
December 30, 2003 at 9:44 am
Viewing 15 posts - 706 through 720 (of 2,387 total)