That really hits home for me too. I agree with Del (above). I have a short list of developers that I actually consider savvy enough to build solid code and an immense list of developers that I [know] from experience code horribly. The "good" coders are the ones that take pride in their work. It's […]
2005-05-23
I think that you are referring to Online vs. Offline operations (From Books Online):DBCC INDEXDEFRAG is an online operation. While this operation is running, the underlying table is available to users of the database. DBCC DBREINDEX is an offline operation. While this operation is running, the underlying table is unavailable to users of the database.AFAIK, […]
2005-05-20
Outsourcing should be used to free up staff, not replace them. That's a great mantra and one that's being espoused by the Gartner Group to its client. The logic is simple. Much of the IT budget it just "keeping the lights on", the tedious, mundane, everyday stuff that the Operations folks do. By outsourcing these […]
2005-05-04
2 reads
Noel,This option would work for independent of user. Am I right?In this case where the SQL Server Registation information would be stored?Can this information can be edited by anyone?
2005-04-29
Hi,you can run an Active X script prior to the execution of the data pump to change the table name.Example:'********************************************************************** ' Visual Basic ActiveX Script ' ' Replace the Placeholder ##Supplier## in the "WHERE" clause in the data pump task '************************************************************************Function Main() ' Get the root parent reference to the DTS package Set oPkg = […]
2005-04-20
Hi all,I like to insert a row from a table back into the same table. In another word I want to duplicate the same record in the table in the stored procedure but it is generating the error below. There is identity column in the table but I'm why I can't insert a row and […]
2005-03-17
2 reads
Nonetheless, such AV should be reported to MS tech support because it is a bug. Microsoft will most likely not charge you with it if you can prove it is a bug. SQL Server should error out nicely with "Constraints Violation". Unreported bugs will not be fixed and will propagate to the next version and […]
2005-02-02
1 reads
Really the quickest way?Detach the db, rename or delete the log, attach the DB or useBACKUP LOG WITH TRUNCATE_ONLYDBCC SHRINKFILEBtw, changing the recovery mode has not much to do with the growth of the log file. In doing so, you give up your ability to restore to the point of failure or a point in time.
2004-12-29
INSERT INTO tbl2 (fname) SELECT fname FROM tbl1 WHERE ref#='123'Btw, the # sign isn't really good to be used as a column name. I have seen several threads here, where this caused more or less severe problems.
2004-12-16
Dinesh,In your forward-engineer options, you need to check the option to use Quote Names. You can find it in the 'Other Options' group of options. -ldb
2004-11-09
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...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
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