Viewing 15 posts - 45,961 through 45,975 (of 49,571 total)
Have a look at this kb article, see if it solves your problem
July 4, 2008 at 3:02 am
I would sugget that you import into a staging table where the column is of type varchar, do any validation and correction that you need thre, then import into the...
July 4, 2008 at 2:51 am
karthikeyan (7/4/2008)
The suggestion of a comma-delimited list in a single column violates the first. It it often suggested as a 'solution', but tends to cause mor problems than it solves....
July 4, 2008 at 1:24 am
Not those. Those are OS-level counters. What about other SQL-related counters?
(SQL Server:Access Methods, SQL Serveer: General Statistics, ....)
July 4, 2008 at 12:43 am
Check some of the other SQL objects and counters.
I know there's a way to fix this, but I can't remember offhand.
July 4, 2008 at 12:36 am
Two of the rules of database design and normalisation that you need to consider here are:
- All columns should contain atomic entries
- You should not store redundant data...
July 4, 2008 at 12:32 am
Do you have a backup of the master database from before the deletions?
Deleting directly from sysxlogins is a little (no, actually it's very) extreme and there probably is another way....
July 4, 2008 at 12:14 am
Check some of the other SQL counters. I have seen cases before where all of the SQL-related perfmon counters read 0.
July 4, 2008 at 12:10 am
Hmmm.
Check the source database please, make sure that you have either torn page detection or checksum (open the database properties, go to options and scroll down to the...
July 4, 2008 at 12:03 am
Mani Singh (7/3/2008)
and the UPDATEUSAGE will help to rearrange the pages.
All update usage does is fix the metadata with regards to the size of tables. It doesn't rearrange anything....
July 4, 2008 at 12:01 am
When you run checkdb, run it with no_infomsgs, unless you need to see the count of rows and pages per table (usually not), and note that it is a very...
July 3, 2008 at 11:59 pm
Very strange...
Do you have space on the source server to restore one of the full backups that produces an error on the standby server? If so, please restore the backup...
July 3, 2008 at 3:25 pm
Have you done a checkDB on the source database?
While it's not unheard of for a backup to have an error, to have multiple backups producing the same error is 'unusual'...
July 3, 2008 at 3:11 pm
If you're running the queries you should be able to extract the plans from the cache. You can retrieve the text of the query from the cache also. Dunno it...
July 3, 2008 at 3:01 pm
Tom Brown (7/3/2008)
90. Thats all - and it seems to work, - but performance seems sluggish, would any of these DBCC commnands help?
Update statistics on all of...
July 3, 2008 at 2:34 pm
Viewing 15 posts - 45,961 through 45,975 (of 49,571 total)