Hot Standby Solutions
DBAs,Does anyone know of other hot standby solutions for SQL Server besides failover clustering? Are there any 3rd party tools available?Thanks.
2004-10-01
1 reads
ETL (Extract Transform and Load)
RE: Error: 823, Severity: 24, State: 2
Hi,This is the clear problem of I/O Hardware. I have the same problem with one of my production server from past few months. You could try to run the DBCC CHECKDB with physical_only option to confirm the scale of damage to your user database. Only way to come out to the situation is either restore the database […]
2004-09-14
long delay when waiting for trigger????
I am currently using the below trigger to send email notification on insert/update. For the transaction to complete it has to send the email. This is actually a secondary table so the trigger (email failure) doesn't effect the insert/update of the real table. I don't care if this trasaction ever really completes. Is there a way […]
2004-09-14
RE: Question of the Day for 27 Aug 2004
Exactly.Why would you ever roll back or restore because of a data entry mistake? Those kinds of problems should be fixed on the front end. Each of the first three answers would require any other data to be re-entered. So tell the guy that screwed up to do it over. I suppose it's possible that the […]
2004-08-27
Should I have Multiple data files for large DB (250GB)?
I have a DB that is around 250GB that is growing rapidly. It is running on a 4 proc clustered server with EMC SAN for storage. The entire database resides on a single data file within a RAID 5 partition, and as of right now it is performing very well. However, I am wondering if I should create […]
2004-08-13
8 reads
RE: Sp with Subquery/where statement
I do most heartily apologise, I missed out a + when I specified the where clause for you. It should be WHERE TplanCond=''' + @Tplan + '''' *most embarrassed*
2004-07-29
RE: Sargable condition slower than non-sargable...why?
AAron Run UPDATE STATISTICS with fullscan on your Production BOXRun the queries and let me know
2004-07-26
RE: Export to csv file crashes EM
Hi,I've just been having the same type of problem. I got around the problem by using the DTS Export Wizard, specifying the Destination = Text File (and the file name as the .csv file you want to create), and then you get to specify the csv file format you want, with the right delimiters etc). If you […]
2004-07-23
RE: Help with hitting a wall
Peter,Thanks for those suggestions. There isn't a clustered index on the GUID, though there is a secondary index on the table that is clustered. The Wall seems to have been a red herring as we're now up to 10GB and rising.Tempdb is set for unrestricted growth in 10% incrementsCheers,Paul
2004-07-15
RE: SQLMail Problem (maybe)...
Doesn't look like my last post went through...Derrick, you might have something there. I'll be checking with our Exchange Admin on that. Although, our Dev servers use the same config as our prod machines (albeit with a different domain account), and they seem OK. Thanks!!!!!! Josh
2004-07-06
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers