****IAM page (4:62991) for object ID 2073058421 is incorrect. The table ID on page is 413960551; should be 2073058421. The entry in sysindexes may be incorrect or the IAM page may contain an error. The above error suggests that the sysindexes is corrupt - normally if any of the system tables is corrupt, it is hard to […]
2005-05-26
Don't expect that to work unless you are prepared to move; even then, you'll probably have to. The common argument is cost-of-living. I am in the same boat but I like where I live too much to give it up right now.
2005-05-24
Really bad. It means that once everybody is out of the database it closes itself. Which doesn't seem really bad, but if you have 200 of those on the same server and you open the database list in EM, you won't even be able to enter one of them because they will constantly open/close. It […]
2005-05-20
How Can I Generate Sql Script with out using Enterprise Manager preferably using T-SQL
2005-05-13
Hi all,I am trying to use shared (or S lock) on this query.select * from job_type How can i do this with shared lock on on this query? Thanks
2005-02-21
1 reads
I am currently running some performance stats against our SQL server. I have been looking at CPU, Memory and Disk IO but am confused by the counter Memory - Page Faults/sec, what would an average be for this counter for reasonable performance. Whilst i'm on the topic aswell, what is a good figure for Memory […]
2005-01-25
1 reads
You have staff who are contracted (with date ranges) You have jobs (with date ranges) and you want see if any staff can fulfill any jobsQuestions Where is the relationship between staff and jobs? (or is that the contracted date range) How do you determine whether the member of staff is qualified to do the […]
2005-01-20
2005-01-05
I've had the same problem. We implemented Forms Authentication (from microsofts MSDN help on the subject). The existing reports work fine, but in Visual Studio we can no longer deploy reports so no reports can be updated.Any help would be greatly appreciated.Sameer
2004-11-24
The default value is in registry HKEY_LOCAL_MACHINE SOFTWARE Microsoft MSSQLServer SQLServerAgent JobHistoryMaxRowsA trace in Maintenance job indicates msdb.dbo.sysdbmaintplans is the table to change.
2004-11-14
By Steve Jones
I don’t do a lot of work with disabled index, but I learned how...
By Steve Jones
I’m leaving again tomorrow for a trip. This time I head back to Boston...
By Tim Mitchell
Most of us who work with data have, at least a few times, been...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers