ApexSQL Lockwood Tech ,Anybody's Using It ?
Jan 9, 2004I just got their demo but having problems with running ApexSQLDiff , any feedback how it works for others?
Maybe there are some other tools worth looking at ?
Thanks for any suggestions
ADVERTISEMENT
Lockwood Tech Audit Toll
Jan 23, 2004I am evaluating demo version of Lockwood Tech Audit Tool and having problems with "undo" module.
When I click "UNDO" it not only freezes application but entire PC, did any of you experienced same sort of problem ???
Thanks
Log Explorer Vs. ApexSQL Log Vs. SQL Log-Rescue
Jun 8, 2006Opinions?I've installed all three to try'em out and they all seem to be workingso far, more or less.Log Explorer has given me a couple of errors but I started over andcontinued OK.ApexSQL Log squawked about "redo for delete cannot be generated fortables lacking clustered index". Huh? What the...? We have lots oftables without a clustered index.I read some reports in Red-Gate's technical support forum about theirproduct actually bringing down SQL Server. That did not inspireconfidence.All three install some server-side components like extended storedproc's which I'm not crazy about and I think all three are server orinstance licensed (does anyone actually purchase more than one licensewhen it seems like you can easily move any tran log to be analyzed tothe server the product is installed on?). I don't think I'd want toinstall any of them on a Production server, at least one that I'mresponsible for!Thanks,Martin
View 1 Replies View RelatedTech's Are So Funny
Aug 16, 2004Ok a network tech put an executive assistants database on sql with the upsize wizard in access. Only problem is that she cant input anything into the database, my guess is that its due to no Primary key in the new sql table. I have had this problem before am I correct in my assumptions???
View 6 Replies View RelatedLecco Tech SQL Expert Pro
Jun 15, 2000Is anybody out there using SQL Expert Pro? Can you give me some feedback please?
I've been evaluating it for two weeks now and am very pleased with the results but I'm a bit hesitant to spend $5000.
Thanks!
Pete Karhatsu
Dba Interview Tech Question
Nov 1, 2005i need some help. im going back for second interview for dba job and l am been told that there's going to be a test. Not writing but just task to perform. what should i expect? i want to be ready?
thanks for hint
Tech-Ed 2004 - San Diego
Apr 20, 2004Something happened, they are sending me to this conf on May 23-28. This is the first conference since 1999 that I would be attending. Personally I consider this to be the best conference, and I can attend it every day. But it would be interesting to see some of you. Anybody else going?
View 2 Replies View RelatedNeed Tech Information About DTS On Data Warehousing
May 12, 2004Hello, everone:
Anybody can offer technical information about DTS appied in data warehousing? Website, tutorial, forum and books will be great. Thanks.
ZYT
BIG And Rapidly Growing Database, Inexperienced Tech Guy... Me!
Dec 3, 2007We're a very small company, I’m the “technical” director who has evolved enough skill in a wide variety of tasks (network setup, machine config, email systems, html, asp, database...) and then one day you notice that parts of the system are starting to get way more complex and troublesome than the layman knowledge you have can cope with... Well, I think I’ve got to that point and I need some outside help to get our system to the next level!
OK, some rough details to start with. We run a small but fast-growing vehicle tracking system that sends back a LOT of data via GPRS to our SQL 2000 Enterprise server hosted on a dedicated server in London. The physical machine is a P4 3.2Ghz Dual-core Dell rackmount with 2GB RAM and 2 x 76GB SCSI disks in a RAID 1 array. This is partitioned into a 15GB C: partition and a 51GB D: partition. The system paging file is set to be 1536MB and is on the C: partition. The server is used for everything we do... it runs Smartermail email server (only about 5 or 6 domains and a few users, hardly used at all), SQL server as mentioned, web server & the proxy software that receives incoming data from our tracking devices.
There are 9 or 10 active databases on the SQL server. 8 of them take up less than a gigabyte between them and are sparingly used. The main “active” database on the SQL server is the tracking system – and this is big... As our tracking devices send in data every 10 – 30 seconds, the database is hit with hundreds of thousands of events per day. On a weekday, some half a million rows of data are written to the main “events” table on the database. Over 7 days from 26th November to 2nd December, almost exactly 3 million rows of data were written to the events table. We undertake to hold 3 months or so of data “live” for our customers and I periodically archive data off. I’ve been too busy to archive recently and the database is holding data on the events table going back to July 1st. The physical .mdf file is just under 30GB on partition d: at present. The plan is to drop the active data stored to only 1 – 2 months, but this still leaves a 12GB .mdf file.
The worrying thing with this is that this is only 700 or so devices writing to us at present... we aim to have thousands out there soon! We are looking into how we can hugely improve system performance and look to the future. Our hosting company is recommending VMWare virtual servers and SAN storage, but I’m not entirely sure that is the best way forward.
Our non-tech MD thinks the way forward is to have one database per customer and can't understand when I tell him I think that's bad as it will create all the system tables and bits & pieces for EVERY customer if we do that, right? Also it would be a nightmare to add a new column to a table as I'd have to update every single version of the database too... I want to avoid this unless I'm missing something and this is actually the best way to go forward?
I've had someone mention horizontal partitioning to me? not sure what implications this has to coding and table naming? Or is it all one big database spread among separate servers?
Currently our server is drowning on disk access and it's only going to get worse... any suggestions or links to reading online that I can do would be great, thanks!
Carl
Need Tech Review Of MSSQL Backup Chapter For O'Reilly Book
May 28, 2006My name is W. Curtis Preston, and I'm the author of "Backup & Recovery"(formerly "Unix Backup & Recovery") from O'Reilly & Associates.(http://www.oreilly.com/catalog/unixbr/ )We're updating the book for 2006 and adding a chapter on SQL Serverbackup and recovery. Someone has already written what appears to be astrong chapter. The problem is that I'm not qualified to review it,since I'm not that familiar with SQL ServerCan anyone in this group step up to the plate and review the SQL Serverchapter? You would be mentioned in the acknowledgments of the book andreceive an autographed copy of the book.We're looking for two tech reviewers.
View 1 Replies View Related