Thanks Brian but that's not quite what I'm looking for. His directions are for moving them to another drive or drive partition. We are moving them to a whole new array which will have the same drive letters/partitions. I'm beginning to think that all I need to do is stop the services and the files […]
2003-06-20
The SQL Agent service runs under local system account. I also tried to assign the local administrator to it but the result is the same: it still can't be started. The SQL Server service also runs under local system account without any problem. Could it be a system error (missing dll, damaged registry, etc.)? Csaba […]
2003-06-20
1 reads
Will there be any duplication in table names from the 2 publishers? If not, you can set up two subscriptions at the publisher to subscribe to each publisher. Server c will subscribe to a & b both. -Dan
2003-06-19
Hi racosta, quote: jaja, don't worry guys, here in Argentina I earn 8k only. And it is considered a very good salary. Things are not goin right here, but we do what we can. I know. I've signed some Argentina bonds for my fixed income portfolio. and pray that there will be no default! Cheers, […]
2003-06-19
1 reads
ian - i don't see how what you describe can happen unless the query is more complex than the one shown. I assume you are not suggesting that the query plan adopted affects the records returned. However, if this is a problem, it's potentially a major one. Do you have the code of the two […]
2003-06-19
The results are in: quote: WTF is a SARG? That's a searchable argument I think... when you look at the execution plan at the bottom of the bubbles that pop up over each icon there is a section that says arguments. It first lists OBJECT indicating what index it used. Then if a SARG is […]
2003-06-19
1 reads
Another way to do it is: Convert(char(8),dteShipped,1) This will convert the date to a mm/dd/yy format.
2003-06-19
1 reads
You can perform non-logged operations in certains situations, but not for the scenario you've described I'm afraid.
2003-06-14
My personal preference is to break all of his fingers, but I know that probably won't be considered acceptable. There's an FAQ with some more details if you want to get really specific with permissions: http://qa.sqlservercentral.com/faq/viewfaqanswer.asp?categoryid=2&faqid=252 K. Brian Kelley http://www.truthsolutions.com/ Author: Start to Finish Guide to SQL Server Performance Monitoring http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
2003-06-13
We always use RI. I can't imagine not using it. We have a third-party application that doesn't use it. We have a lot of problems with it from performance to data integrity. I'm sure there are other reasons for these difficulties other than the lack of RI, but I think that's a big one. The […]
2003-06-13
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
I recently received a complaint that Query Store for a particular database was turned...
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