I am using SQL7SP2 on NT4SP5. I have a database where one of the tables should be strictly read only as the data in it is static except for a monthly load. There are over 80 million rows currently in this table. The table and it's indexes are in their own filegroup - say called […]
2001-10-24
1 reads
Anybody having experience with SQL servers running while time resets from daylight saving time to ordinary time, I'm particularly interested in the possible affects on recovery based on the transaction log.
2001-10-24
1 reads
Comments posted to this topic are about the content posted at http://www.sql-server-performance.com/best_sql_server_performance_tips.asp
2001-10-24
1 reads
How do we remove an identity, from a sql table column which already has identity and data , without loosing the data and without having the need to copy data to new table
2001-10-23
1 reads
How can I use VBScript (and DMO) to stop the SQL Service service on a remote SQL 7 machine, copy trans logs from that machine, and then restart the SQL service?
2001-10-22
3 reads
How can I make a linked server connection to mysql via ODBC? The ODBC-connection works well with DTS or ACCESS. But SQL2000 refuses with following error: "Error 7399. OLEDB-provider MSDASQL reported an error. Drivers SQLSetConnectAttr failed.Can't connect on server MYSERVERNAME (10060)". I tried all security contexts.
2001-10-22
3 reads
This article looks at some of the undocumented DBCC commands that exist in SQL Server 7.0
2001-10-22
7,159 reads
Comments posted to this topic are about the content posted at http://qa.sqlservercentral.com/columnists/awarren/worstpracticesnotusingprimarykeysandclusteredindex.asp
2001-10-20
66 reads
I would like to bcp any table to a text file so that every row become a string without space inside. So I tried the following command with the table northwind territories but in the destination file, the two last field are separated by a large space on every line: declare @str varchar(255) select @str […]
2001-10-18
2 reads
Comments posted to this topic are about the content posted at http://www.msdn.microsoft.com/code/default.asp?url=/code/sample.asp?url=/msdn-files/026/002/458/msdncompositedoc.xml
2001-10-18
3 reads
In the modern data-centric landscape, SQL stands out as the dominant tool. It's essential...
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...
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