Viewing 15 posts - 526 through 540 (of 662 total)
I agree with Andy.
I think the cursor issues become relevant with upscaling/concurrency issues, specially when the box start to take a bit of strain!
April 21, 2003 at 4:57 pm
Add your own select for one record and execute the code. It will display asci values for none digit and none alphabetical characters.
Declare @Tmp Varchar(1000),
...
April 16, 2003 at 9:40 pm
What environment ASP, VB, etc. ?
How many records in the result set?
How about a VB DLL, pass parameters to get data to dll and then pass a comma delimited string...
April 16, 2003 at 9:25 pm
Create Table Test(A varchar(2000))
Go
Insert Test
Select Replicate('1234567890',100) -- 100 * 10 = 1000 characters
GO
Select 'Column A contains ',DataLength(A),' characters' From Test
Go
Drop table test
GO
If you are using Query Analyzer, go to
Tools->Options->Results...
April 16, 2003 at 4:15 pm
exec xp_cmdshell 'c:\pkzipc -add c:\test.zip c:\test.txt' and place pkzipc in c:\ or try place in sql binn directory.
April 16, 2003 at 3:37 pm
set Col2 = IsNull(@2,Col2),
Col3 = IsNull(@3,Col3)
where Col1 = @1
April 16, 2003 at 3:05 pm
Which reindexing method drop index / dbcc indexdefrag / dbcc dbreindex do you use. See article in SQL Server Magazine of April 2003, page 42 about defragmentation methods and...
April 15, 2003 at 3:18 pm
Did you try the COALESCE function?
BOL 2000:
Returns the first nonnull expression among its arguments.
April 15, 2003 at 2:58 pm
Is'nt your log size a bit big / bloated.
What recovery model?
When last did you do a full backup?
Assumes SQL 2000?
April 14, 2003 at 10:30 pm
In SQL 6.5 with, the I think it was the job history table, when the 1000 rows limit was exceeded the latest rather than oldest was job history was deleted....
April 9, 2003 at 3:55 pm
Production box. Only operation staff.
Development box, all developers are sa. Nightly, automated Sourcesafe update of complete database.
Formal process of upgrades every 3 months to 3 months.
ERP / MRP development.
April 8, 2003 at 9:23 pm
Did you update statistics, defrag, etc after the upgrade!
April 8, 2003 at 12:06 am
Don't they perform a backup to a local device?
April 7, 2003 at 10:14 pm
Viewing 15 posts - 526 through 540 (of 662 total)