Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum

Tip: Looking for answers? Try searching our database.

Other Technologies

Recently updated threads


Thread preview

Clustering (view all ...)Last Post  Replies
SQL DB indexing30 Aug 2010 23:09 GMT-
I have the opportunity to design or DB server with the version that will do
what we need.   If I understand my information correctly, my Standard Version
for SQL 2005 Standard Edition, will not perform indexing without shutting
down the DB.  Howver; Enterprise Editition, as I ...
Service Pack install on new cluster node27 Aug 2010 09:48 GMT-
We have an existing 2 node cluster running SQL 2005 Enterprise x64 SP2
on W2K3 R2 Enterprise x64 SP2. We have added a third node to the
cluster. SQL deployed without a hitch. When we ran the SP2 install
from the active node, the install ended saying it had nothing to
Stuck at Cluster Network Configuration Wizard18 Aug 2010 01:29 GMT7
"On the Cluster Network Selection page, specify the network resources for
your failover cluster instance:
   * SQL Server Failover Cluster Network Name — This is the name used to
identify your failover cluster instance on the network.
Active/Active Two Node Cluster and Default instance13 Aug 2010 23:18 GMT1
All,
I'm new to clustering. We are trying to set up an Active-Active cluster
consisting of two nodes with each of the two SQLServer nodes hosting
multiple databases. We followed the two step approach in installing and
Issues creating a new failover cluster on the same server12 Aug 2010 16:09 GMT7
We have a sans and a server box that currently has a SQL 2005 Failover
cluster installed, we are attempting to install a new SQL 2005 Failover
cluster but ran into an issue. After setting up the new cluster group and
installing the instance to this group the installer modified ...
multi node active/active/active/active cluster10 Aug 2010 14:22 GMT3
In a hypothetical scenerio:
I want 4 node, active/active/active/active cluster.
There are 4 sql instances installed on each node, with name SQLInstance1....
SQLInstance4

English Query (view all ...)Last Post  Replies
Primary/Uniqueness  Problem01 Sep 2010 05:14 GMT1
I am going to design hospital database
I have a patient table tblpatient(patientid pk,name,age,................)
another table that is tblyearly(yearlyid ,patientid fk,isadmit,department,....
)
How to get most recent records from table?22 Aug 2010 18:17 GMT-
I have two tables Person and Employment. Person has 1 row per person,
Employment lists that person's job history where each row is an employment
period at a particular grade. Therefore there can be multiple rows per Person
in the Employment table.
How to get row index in column14 Jun 2010 12:09 GMT1
I explain the problem
COL0    COL1     COL2    COL3   COL4          COL5
row1     blabla      37       M        X                 1
row2     dgdgg      35       M        X                 2
Query to return multiple foriengn keys from same table10 Jun 2010 23:46 GMT1
I have an SQL database with the following:
[B]TableA[/B] with ItemID, Fk1, Fk2, Fk3, Fk4
[B]TableB [/B] with DescID, description -
Where Fk1-4 is equal to a DescID in Table B.
Date time difference complex query not working05 May 2010 10:28 GMT4
All, I'm relatively new to SQL server and am having problems writing a
complex date/time query. I have a table with a datecreated field and a
priority. The priority is either 1, 2, 3 or 0. The table also has a
datecompleted field.
SQL UPDATE Query07 Apr 2010 22:11 GMT1
Is there a simple and effective way to revert an update query after the fact?
Signature

-M Noon


Full-Text Search (view all ...)Last Post  Replies
Indexed view for SQL Server Full Text Search15 Aug 2010 14:29 GMT-
I want to use the Full Text Search feature of Microsoft SQL Server.
If I have a table Client which refers other tables like City, Country,
Department, etc. is it better to create a separate table that would
hold de-normalized data, which would then be full text indexed, or is
Hebrew is not in language list on full-text search19 May 2010 16:30 GMT1
How can i repair this?
Is There a Quick Way to Get a Total Match Count (estimate is OK) of a SQL FullText Query?21 Apr 2010 04:58 GMT2
I am using the June CTP release of SQL Server 2005 on Windows Sever 2003.
Is there a quick way to get a total natch count (estimate is OK)
of a SQL FullText query? I am working with about 10 million r
ows of simple character data.
Setting a minimum word length on a FULLTEXT catalog12 Apr 2010 11:12 GMT1
I want to set a minimum word length on a Full Text Catalog to a value lower
than the default setting.  Is this possible to do?  When I look this issue up
on the Internet it can be done using MySQL.  I am using SQL Server 2005.
Please advise...
Unexpected search results with 2+ words and 'AND'24 Mar 2010 16:07 GMT1
I am using SQL Server 2005 and the index for full text search consists of 5
fields.
While there is everything fine searching only one word or searching several
words with OR, i encounter unexpected results while searching with two or
"weight" failing in fulltext search in Sql-Server EE01 Mar 2010 18:45 GMT7
 The query pasted below
SELECT CAST(copy.copyid as VARCHAR(50)) as copyid
FROM copy,story,brief,link_copy_issue,brief_issue
WHERE CONTAINS (copy.*,' weight AND loss ')

Replication (view all ...)Last Post  Replies
merge and identity column screw up31 Aug 2010 14:47 GMT-
Publisher w/ 2 subscribers running merge replication.
the data was on all three machines and the i changed tables on the
publisher so the identity column was in a different range. i wanted it
to be an increment of 2 and a seed of 100,000, but instead i set an
Transactional replication of VLDBs27 Aug 2010 21:55 GMT5
I am assigned to do a transactional replication of a large database of size
more than 4 TB and As the snapshot cannot hold the large amount of data I am
looking for better solution like initialize the database from the backup and
then perform the replication.?
Transactional Replication - multiple schema27 Aug 2010 15:36 GMT-
I have got 2 publisher replicating to a subscriber
Publisher1 - Server1 / Db1
Publisher2 - Server2 / Db2
Subscriber - Server3 /Db3
Replication is stuck - please help27 Aug 2010 06:05 GMT-
Platform: 2 machines - Win2003 Server SP2 x64, SQL Server 2005
Problem: The subscriber is not being updated even though Replication Monitor
says Publication status is OK and Subscription Performance is Excellent.  It
was working fine for weeks and then just got stuck.  ...
How to set-up transactional replication from back-up26 Aug 2010 19:34 GMT7
I am looking for a step-by-step guide on how I can set-up a replication
between 1 single SQL Server 2008 publisher and SQL Server 2008 subscriber. I
am regularly taking full back-up of the publishing database. Distributor is
already present on the publishing server.
question regarding replication25 Aug 2010 16:22 GMT7
I have two questions regarding replication.
1. I have replication that setup as non initial snapshot, and manually
initialize a pull subscription to a transactional publication. When I got
error in subscription and I need to remove the table from replicaiton. But

Service Broker (view all ...)Last Post  Replies
Service Broker proper usage ?11 Mar 2010 03:09 GMT2
Even though it came out with SQL server 2005, I am new to this concept...
I have a process whereby I would like to accomplish the following...
The setting includes many client workstations using a VB.net application to
communicates with a database via ADO connections.
CREATE QUEUE + Procedure_Name + parameters26 Nov 2009 17:17 GMT3
How could I pass parameters to the procedure I execute through a Queue ?
Service Broker = SOA?30 Oct 2009 18:12 GMT1
I'm an analfabeth as long as it concerns buz words..
I tried to search in Wikipedia the term "Service Broker" and was directed to
Service-oriented architecture (http://en.wikipedia.org/wiki/Service_broker).
Is it correct?
Sending SSB messages out of trigger with no cursor!20 Oct 2009 21:25 GMT4
Here is a tip I can share that may help others that use SQL Service Broker in the way I do.
Definition:
I have queue tables that have triggers defined on them, which fire messages on INSERT/UPDATE to SQL Server Broker for processing, sort of like this below.
Sometimes I need to fire ...
Currently Processing Message in Que22 Sep 2009 02:28 GMT1
I have a stored proc. tied to a Queue activation.  I use valid xml to
exchange information between queues.
Is there a way to know which message is being currently processed . ?
Currently i am writing a log when the stored proc is being called. I am
How to Enqueue Messages With Service Broker in a Timely Fashion03 Jul 2009 08:33 GMT23
I have an application that puts data into a table in a remote database
instance. The problem is that when the database or network is down the
application has nowhere to put the data. To overcome this, I have decided to
save the data to a local instance and use Service Broker to ...
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage




©2010 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.