BCP out a table
This procedure will BCP out all data in a table. The format is designed to be used with the dbsp_bcp_in stored procedure to import the data back into a server.
2001-08-08
3,802 reads
Backup and restore
T-SQL Book and site for self study
Is it necessary to master t-sql fro 70029 exam ? If yes which is best book for T-Sql self study ? Can u recommend any site for detail information ?
2001-08-05
SQL SERVER CLUSTERING
If we have a stateful connection (RDS) and the database fails how will the application reconnect. I do not believe that our application was written using MSCS API. Therefore I don't believe that it caches the user logon and password to log back into the session. So, my question is can the application work with […]
2001-08-02
5 reads
How fast does SQL restore from disk?
How fast does SQL 7/2000 restore data from a dump file back into a database? I haven't seen any full numbers on this and was just wondering. Trying to strike a ballance between recovery time and megabytes backed up.
2001-08-02
7 reads
Create database from SQL script
I got this warning message while trying to create the database, "Warning: The table 'Zeuqram_Tools' has been created but its maximum row size (9757) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of a row in this table will fail if the resulting row length exceeds 8060 bytes." Is it true […]
2001-08-01
7 reads
Problem with linked server query
One of the developers at my company receives the following error when executing a stored procedure : Server: Msg 7399, Level 16, State 1, Procedure forex_Insert_Positions, Line 51 OLE DB provider 'SQLOLEDB' reported an error. [OLE/DB provider returned message: Syntax error or access violation] The error occurs when attempting to select data from a linked […]
2001-07-31
6 reads
sql server6.5 and xml file
hi, i am working with sql server6.5.Data gets updated continiously.For each updation i need to create xml file.could some one help me out. thanks in advance
2001-07-30
5 reads
Speedy Database Recovery with Differential Backups
Differential backups are a new feature in SQL 7 that can speed up your recovery times when restoring from database and transaction log backups.
2001-06-05
7,542 reads
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
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