Our standard is RAID 1 (c:) - OS + SQL OS RAID 1 (f:) - SQL Logs RAID 5 (g:) - SQL Data + backups. If tempdb is heavily used (not most servers), we add a RAID 5 for the tempdb mdf. Since we run the backups when the db is not heavily used, we […]
2003-05-19
eholsinger My IIS is already the 5.0. Nevertheless, the solution of my problem came through the IISRESTART suggestion, by well0549! Dalton
2003-05-16
1 reads
Anbu, I am not to sure what you want to do with the dimension. Please explain
2003-05-14
Do you have any workstations configured with named pipe in client network utility to access SQL Serevr without going through your application servers? You can change the network access order by clicking the up and down arrow in client network library. Please make sure TCP/IP is set before the named pipe. Use following statement to […]
2003-05-12
Oh you're going the oppisite way. You need to write a program (C, JMS, VB ). Not complicated, but it takes knowing your environment. Too many options to go through here. As I mentioned I have consultants here that do that for a living. If you want I can put you in contact with them […]
2003-05-09
1 reads
quote: Since you are ignoring NULLS then this I think is what you are looking for is something like this. SELECT (CASE WHEN ProdA = 1 THEN 'A' ELSE '' END) + (CASE WHEN ProdB = 1 THEN 'B' ELSE '' END) + (CASE WHEN ProdC = 1 THEN 'C' ELSE '' END) AS Combination, […]
2003-05-07
rajeshpatavardhan: Thanks for the input. I just tried the query with the IN clause but the results are the same.
2003-05-05
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
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...
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