Hello Site Owners, quote: I agree with point 6. Event if you seem like an asshole, you have to come to a point where you say no. can someone of you please take care of the bad words filtering. I feel offended Cheers, Frank
2003-06-13
1 reads
We standardize on RAID 1 for OS, RAID 1 for logs, RAID 5 for data. Sometimes split that further. For one high end DSS system we went with RAID 10 for the data to speed reads, but it was $$$. Hard to justify the cost for other systems. Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones www.dkranch.net
2003-06-12
1 reads
Thanks MW. I'm using stored procedures and the logic looks simple enough. Maybe 24 hours is as good as it gets.
2003-06-12
You cannot specific the sql statement as a variable for the cursor. The easiest was around this is to include the whole cursor operation into your dynamic sql statement.
2003-06-12
1 reads
Have a look at http://directory.microsoft.com/ResourceDirectory/Training.aspx and http://www.microsoft.com/traincert/
2003-06-12
2003-06-11
1 reads
Performanced wise RAID 10 is best do to the number of read and writes, plus it provides redundancy. But you may see added performance gains by having the additional drive to placxe you TL on (again 10 is preferred becaues of the stripping). But consider cost first and for most. If you will need extra […]
2003-06-11
1 reads
yep..same server.so far everything is running fine. Wasn't sure if the recompile would be a good moved as maybe the excution plans would change with faster processing. Though i'm happy to let it run its course. Thanks for your time on this Scott
2003-06-11
quote: only one that running named instance is not working. Try isql.exe -Ststsql01\tst (Replace tstsql01 with your server name and tst with your named instance name) Edited by - Allen_Cui on 06/11/2003 12:08:49 PM
2003-06-11
2 reads
Are you sure SQL Server is started? Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones www.dkranch.net
2003-06-11
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