Programming with SQL Servier in .NET
Comments posted to this topic are about the content posted at http://www.c-sharpcorner.com/database/dbsqlnet.asp
2001-10-15
2 reads
administration
Does Merge Replication Delete Data & Re-Insert
I had tried Merge Replication. But due to some problem (supposedly connection problems)... some tables got replicated but at one point of time when the replication failed ... it had deleted data from the server (from where I was pulling data). Why did this happen... does merge replication firstly delete all data and then re-inserts […]
2001-10-14
4 reads
How to direct the SQL query output to a file?
How to direct the SQL query output to a file for a query like select * from test1
2001-10-12
4 reads
How to do the free text search
If i want to catelog or rebuild the catelog and create full text index feature from the remote machine which is free text enabled server then how to do using the Wizard option or sql server i.e when u click the table it displays the option "DEFINE Full TEXT INdexing table" which is get disabled […]
2001-10-12
1 reads
Microsoft Analysis Services Trounces the Competition
Comments posted to this topic are about the content posted at http://www.microsoft.com/PressPass/press/2001/Sep01/09-18OLAPReportPR.asp
2001-10-12
2 reads
sqldmo backup/restore problem
I have the following source code to backup database: Dim oBackup As New SQLDMO.Backup Dim oSQLServer As New SQLServer oSQLServer.Connect "WENDY", "sa", "" oBackup.Action = SQLDMOBackup_Files oBackup.Database = "Jantzen" oBackup.DatabaseFiles = "Jantzen_Data" ' Example illustrates backup implemented to a single operating system ' file. A file naming convention could be easily applied allowing ' rapid […]
2001-10-11
15 reads
SP_Rename
Running sp_rename, we are inserting @@error. When the procedure fails it does not provide the error number, instead it provides 0. Running a different SP with @@error produces the right results. Is anyone aware of problems when using sp_rename with @@error?
2001-10-11
2 reads
Common SQL Server and Windows Clustering Questions and Problems
This article covers some of the common issues and questions when you cluster SQL Server 2000 and Windows 2000.
2001-10-11
13,440 reads
Improve System Performance in Your Indexing Scheme Using Asynchronous
The Web Data Administrator is a utility program implemented in ASP.NET that enables you to easily manage your SQL data, wherever you are.
2001-10-10
1,911 reads
SQL2000 Developer really slow - any ideas why?
Hi, We're using sql2000 on win2k with 1/2 GB memory and a P3 933 processor. The Developer version was installed and the machine ran fine yesterday. However, this morning it hung for 5 mins, and then seemed to right itself. When I found out it was hanging, I used Enterprise Manager Client on a separate […]
2001-10-09
Blogs
Step Up Your Data Game: Learn Advanced SQL Techniques for Analysis
In the modern data-centric landscape, SQL stands out as the dominant tool. It's essential...
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
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