Hello David,Yeah! checked those.Only one clustered index on an ID column.This problem has only started to happen recently. Also, the table has transactional replication...could this be affecting it..shouldn't affect anything I know.At the moment everything is running ok.But...at 2 in the morning, I don't wish to be woken up to fix.Thanks for the suggestions ....I shall […]
2005-02-17
2005-02-07
And after you read tell us about it. Maybe a 1 page article. Is it free? What does it do? Is it for Windows or Unix? Does it have good features? Any Software Compatibility issues?Y.V.
2004-12-28
Ganesh,In your case it sounds like a separate sp for each case and one wrapper sp would do the trick. On the Wrapper one make sure to put them in the order you would expect the maximum usage like:Create proc usp1 (@mode int, @value int)beginendCreate proc usp2 (@mode int, @value int)beginendCreate proc usp3 (@mode int, […]
2004-12-27
AFAIK has nocache something to do with generating sequences. So my best bet would be, there is no direct equivalent. However, something like the IDENTITY function might prove useful at times. Here's is maybe also interesting link about migrating Oracle to SQL Server:http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part2/c0761.mspx
2004-10-28
We have a Win2K03 system with Active Directory. The domain controller event log shows the folowing error message for only 2 of our many sql servers. Any idea what it means?"There are multiple accounts with name MSSQLSvc/SqlServerName.ou.com:1433 of type DS_SERVICE_PRINCIPAL_NAME. " TIA, Bill
2004-10-15
6 reads
Great article...I'm going to have to set this up. Analysis services can be a bit of a drag to optimize, and this sounds like a great tool to help in this.Good job; wish more articles were like this...cl
2004-10-06
1 reads
Hi,How can i retrun two resultsets from a stored procedure. Regards, Hatim Ali.
2004-07-31
1 reads
I have program in visual basic and my database is SQL 2000 and its work in network.I have two table one called bill to record geberal information of invoice and another tablke called BillData to record items of invoice.The problem i face now that with time there is some records from begining deleted from tables without […]
2004-07-26
1 reads
JP, the HAVING clause has no effect in this query, because the estimateddate is part of the GROUP BY clause (and the MIN function is evaluated for each group and, of course, each group has only one date). I think the query should be written like this:SELECT r.roofid, c1.estimatedcost as CapCost, c1.estimateddate FROM tblcapitalexpenditures c1 INNER JOIN […]
2004-07-25
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
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