Viewing 15 posts - 1,816 through 1,830 (of 2,463 total)
varshachyk (4/24/2010)
" failed with the following error: "The transaction log for database 'connect_prod' is full.
it clearly showed the problem .What have you done for it ?
Resolution:
When the transaction logs...
April 24, 2010 at 10:09 am
Jeff Moden (4/23/2010)
Also, is there a chance that WWW and WWW1 are actually views.
Why do you think that it could be view ? because of "Select * " ?
April 24, 2010 at 10:01 am
Jeff Moden (4/23/2010)
Bhuvnesh (4/23/2010)
Also check ANSI_NULL and ANSI_PADDING settings on both databases ?Spot on.
Jeff , i didnt get you here ? did i suggest wrong workaround ?
April 24, 2010 at 9:58 am
i feel that still some members didnt share their nationality with us.
@steve-2 : DID you sign any confidential document with them:-D ?
April 24, 2010 at 9:46 am
Can i check myself without his interference ?. or can you suggest any other way to send mails to longer list
April 24, 2010 at 9:42 am
To get faster response always put sample data with table/index definitions
April 23, 2010 at 7:47 am
Also check ANSI_NULL and ANSI_PADDING settings on both databases ?
April 23, 2010 at 7:37 am
Ather M (4/22/2010)
Database 1
Select LEN('Ather ')
retrun...
April 23, 2010 at 7:32 am
Whenever you drop any object , sql will remove everything related with it.
April 23, 2010 at 5:36 am
Sree-258588 (4/22/2010)
Thank you for ur quick response.Please could you let me know how to do this in batches ... in jobs...
SRee
this is rough approach, mold it according to your...
April 22, 2010 at 3:09 am
eseosaoregie (4/22/2010)
Why does the clustered index improve performance. More specifically, what is the clustered index doing that is different? I will try this once I get into work.
Create clus...
April 22, 2010 at 12:32 am
eseosaoregie (4/22/2010)
How did you replace my indexes with a clustered index? Were they added to the apllication and user table?
DROP INDEX [IX_USER] ON [dbo].[dimUser]
GO
DROP INDEX [IX_Application] ON [dbo].[dimApplication]
GO
DROP...
April 22, 2010 at 12:20 am
i also found same type of problem with heavy views.
Have you checked that join have proper indexes?. Give some time with "ImpressionTitle" and "PreTMSTitile" table , i...
April 22, 2010 at 12:16 am
(SELECT
SUBSTRING(LineRead,2,24) AS [Date]
,SUBSTRING(
LineRead,
CHARINDEX('/',LineRead)+1,
...
April 22, 2010 at 12:05 am
Viewing 15 posts - 1,816 through 1,830 (of 2,463 total)