Viewing 15 posts - 2,416 through 2,430 (of 3,061 total)
michael vessey (8/5/2009)alter table x alter column y varchar(2)
i tested this against 32 million rows and it performed in 1 second
Quick question... was column "Y" a populated char(1) datatype column...
August 5, 2009 at 10:32 am
The reason for the delay is datatype conversion from chr() to varchar2()
If your table is not too large meaning less than 50 million rows or so and you can afford...
August 5, 2009 at 9:34 am
... how about the physical distance in between the sites?
Any ball-park idea about the size of the databases?... like most likely less than 10 Gig... between 10 to 50 Gig......
August 5, 2009 at 9:26 am
Adam Bean (6/6/2009)
Of course, I make a post and then a few minutes later fix it ... bah, I'm good.
Wrong... WE are good 😀
Just by posting in this forum you...
August 5, 2009 at 6:39 am
You are correct, merge replication might be a good option but unreliable network is a major caveat.
a couple of follow up questions:
1- What volume of data is expected to be...
August 5, 2009 at 6:24 am
rand() solution is not that bad either...
DECLARE @counter smallint
SET @counter = 1
WHILE @counter < 5
BEGIN
SELECT (RAND(convert(int,DATEPART(ms, GETDATE())+@counter))*1000000000000000) Random_Number
...
August 4, 2009 at 1:28 pm
That's a business continuity project and just to get a decent scope of work much more information would be needed.
August 4, 2009 at 12:20 pm
Philip (8/4/2009)
How to manage this parameter?
sp_configure
Philip (8/4/2009)
Is there anyone out there found any e-books with the details on these parameters and possible solutions?
BOL
August 4, 2009 at 7:19 am
patrick ryan (7/24/2009)We have a desktop (winforms) application connected to a database in the USA. However, the users in the global location (UK, BRUSSELS) are experiencing slowness with the...
August 1, 2009 at 6:15 pm
SQL Server is doing what you have asked for which is, enforce a unique key constraint.
You want to define a unique key constraint when you do not want to have...
August 1, 2009 at 2:18 pm
What the "6.5 database compatibility level is not supported" message is telling you?
In a TEST environment you may try this...
use master
go
exec dbo.sp_dbcmptlevel @dbname=N'your65db', @new_cmptlevel=90
go
--- do whatever you have to do,...
July 31, 2009 at 3:51 pm
luckysql.kinda (7/31/2009)
July 31, 2009 at 5:37 am
venu_ksheerasagaram (7/30/2009)
2) What are the ways to decrease the mdf file size?
3) Precautions to take to get rid of increasing the mdf file...
July 31, 2009 at 5:28 am
Viewing 15 posts - 2,416 through 2,430 (of 3,061 total)