This is why I'm not a fan of using Maintenance Plans. I much prefer to code all the jobs myself so I get detailed output. When I'm in DBA mode (I'm currently doing SQL development) I use ISQL to run my DBCCs and pipe the output to a text file. It's run as a batch […]
2005-04-15
Thanks, Scott, that's excellent information! I don't have a place to reproduce the problem now but I suspect that it was as you and Mike suggested. I've since installed MS-03-031.
2005-04-12
2005-03-31
Is there a sql command that would list all the relationships on a database or even just a table?uanita
2005-03-29
1 reads
I don't think you need to worry about this unless your other counters are giving rise to concern. It's not a counter i monitor.
2005-03-16
3 reads
Hi,I'm, trying to install 'sql2ksp3.exe' for SqlServer and thereafter 'sql2kasp3.exe' fro Analysis Services but...I get an error 'Dahotfix has encountered a problem and....'. It happens soon after the upgrade sql scripts have run (sql2ksp3.exe)I can't wait for too long. If there isn't any solutions I will continue with SP2 level. I don't know whether my […]
2005-03-14
7 reads
Look in Books OnLine for sp_add_jobstep where the specifaction for the @command can include one or more of the case-sensitive tokens which are replaced at run time. These token are not availalbe under query analyzer but only is a job that has been invoked by an alert !Be sure to wrap the tokens with double quotes […]
2005-03-03
<so the GUI is my crutch! >Yes, it gets quite complicated using T-SQL but being unable to reproduce your actions and being unable to produce an audit trail because you used EM will cause the auditor to raise an issue due to Sarabannes-Oxley (for publicly traded companies) and HIPAA (for the Health Care Industry). I worked for many […]
2005-03-02
Hi all,My client is looking to hire a skilled SQL Server DBA and give them the opportunity to learn PEOPLESOFT and be the DBA for that as well!!!!!Excellent opportunity to learn PS and show your SQL Server talent.Salary is 60-65K. This is a contract to hire position and you must be willing to relocate to […]
2005-02-15
1 reads
We have three in use at the house. Kids have one and two separate ones for work. Then there is the traveling laptop! No, the dog does not login! -Frank
2005-02-14
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