RE: Date Conversion
I run the sql statement through the DTS package--It is the "Execute SQL Task" icon within DTS.
2005-04-19
Row Count
RE: Too big amount of unused space after shrink of image field contents
If the table is clustered (has a non-clustered index, then you can try a DBCC DBREINDEX (tablename,'',100). The '' specifies to reindex all indexes on the table, and the 100 specifies to completely fill the data pages when done. If not, then create a clustered index on any column, specify a fill factor of 100. […]
2004-06-10
RE: SELECT INTO with stored procedure result set?
I have a couple more questions on this topic. Essentially I'd like to be able to use existing stored procedures on the fly, joined to other data. I already use the technique of building a temp table and then using INSERT...EXEC. I would like to do it without pre-building a temp table or table variable...1) If […]
2004-03-29
RE: Connection From OUTSIDE Problem
Mark:Thanks for your advice, and let me tell you that we do have a firewall, but due to this "tests" i have it off. I also have tryied pinging the remote pc and i reach it, but when i try telenet things doesn't work. I really don't know/understand what is happening. Please if you have […]
2004-03-16
RE: Differnetial Backups applied to different server getting errors
You CANNOT apply a differential without applying a FULL backup.If I understand you correctly, you made a full backup and restored it to a 'backup' server. Now time has gone by and you want to update the information on the backup server; so you made a differential backup and want to apply it to the […]
2004-03-12
RE: Windows 2000 SP4 and SQL Server 2000
I am quite curious about this as well due to the vulnerabilities that are supposed to be addressed by SP4 (see thread under Security). Anyone else care to share their expriences, good or bad, with loading Win2K SP4?
2003-07-14
RE: Nested transactions in nested sprocs- possible?
Thanks stanx68.......in none of the examples of transactions that I've seen is that apparent...... I guess I need to see some better material regarding trans....
2003-06-23
1 reads
RE: Network libraries TCP/IP Named Pipes
This KB should answer your question. http://support.microsoft.com/default.aspx?scid=kb;en-us;328383
2003-05-14
1 reads
Blogs
Simple Talks Episode 7
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
A New Word: the McFly effect
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
Key mappings in Visual Studio Code
At a recent conference I was asked how I executed code during my presentation....
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