I'm not too sure of the rules of American football however if you are prepared for a little foreign intervention try Rugby. If Rugby looks too sissy try Australian football. The Aussies don't like to waste drinking time so they seem to have integrated the best aspects of rugby and the post match punch-up into […]
2005-02-13
Don't make me feel < snip and switch to my online dictionary> embarrassed </snip>
2004-11-19
2004-11-18
You can definitely use a SQL task to create a table as the 1st step of the import, then another SQL task to drop the table at the end. The reason I say don't use a temp table is due to complications with using a DTT and a temp table. But if you're set on […]
2004-06-18
There is a DTS task in SQL2000 to transfer jobs. The source can be a SQL 7 server and you can select the specific jobs you want to transfer.
2004-03-03
cmore: great solution but I need something not in a sproc... noeld: that's what I did to generate the rank but I am having a hard time using this in an UPDATE statement. Here's what I did: UPDATE tblMyTable INNER JOIN ( SELECT i2.idsParent, i2.idsItem, ( SELECT COUNT(i1.idsItem) + 1 FROM tblMyTable i1 WHERE i1.idsItem […]
2003-12-03
Can you please tell me how this works in detail? I am thinking that if you have a full database backup and some log backups and your log drives goes down with every log entry after your last log backup, then it is not possible to recover the database to the last commited transaction and […]
2003-08-12
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2003-08-11
In that case can you post the table definition and some sample data in that format and is there a maximum number of 'Comp' values?
2003-08-07
Determine what account the SQL Server agent is attempting to run under. Add that user account to the System Administrators role (sysadmin) on the SQL Server itself. In Enterprise Manager >> Security | Server Roles. K. Brian Kelley http://www.truthsolutions.com/ Author: Start to Finish Guide to SQL Server Performance Monitoring http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
2003-06-30
1 reads
By Steve Jones
I don’t do a lot of work with disabled index, but I learned how...
By Steve Jones
I’m leaving again tomorrow for a trip. This time I head back to Boston...
By Tim Mitchell
Most of us who work with data have, at least a few times, been...
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