all groups > sql server programming > december 2005 > threads for sunday december 25
Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
Transactional Repl
Posted by Yaniv at 12/25/2005 6:14:31 PM
Hi,
I recently updated an ntext column on a Publisher server and then found that
the data is replicated very slow, that is in the following days a few more
rows were added /replicated to the Pull Subscriber every day.
sp_configure shows the following output for the max text repl size:
max... more >>
Update - What is Wrong
Posted by Vishal at 12/25/2005 5:11:06 PM
Hi,
I am trying to update one field in a table from the existing values in the
table & have been getting an error since the past 4 years, have tried a lot
of things but it just does't seem to work. Have I had enough for the day or
is it just SQL. Here is the update query
The field types ar... more >>
Merge tables into one
Posted by Nitz at 12/25/2005 6:38:47 AM
Hi,
I have about 600 tables with the same structure which I want to
merge into one table.
Table names are in format of data_<USER_ID> where user_id is unique.
I want to merge all of them into one new table users_data where the
user_id is the table key.
Is there a script or other way that c... more >>
Slow User Defined Function (UDF) performance
Posted by Cyr1dian at 12/25/2005 2:01:33 AM
Hi all,
First off: since having this problem I have noticed that many poeple hav=
e =
similair perfomance issues, but very few explanations exist.
Platform:
Windows Server 2003 Enterprise (fully updated)
SQLserver2000
AthlonXP 1900+
512 RAM
Situation:
I have 7 SELECT queries whic... more >>
Select Question
Posted by Vishal at 12/25/2005 12:46:56 AM
Hi,
I have one Table which has Sales for 5 Year, the structure is as follows
Store ID INT
Year INT
Month INT
SALES MONEY
Is it possible to get the sales for Feb 2004 & Feb 2005 in a single query ?
Something like this
Store ID Year Month Sales
1 ... more >>
|