Viewing 15 posts - 1,816 through 1,830 (of 2,462 total)
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 * " ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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 ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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 ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 24, 2010 at 9:42 am
To get faster response always put sample data with table/index definitions
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 23, 2010 at 7:47 am
Also post table and index definition
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 23, 2010 at 7:42 am
Also check ANSI_NULL and ANSI_PADDING settings on both databases ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 23, 2010 at 7:37 am
Ather M (4/22/2010)
Database 1
Select LEN('Ather ')
retrun...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 23, 2010 at 7:32 am
Whenever you drop any object , sql will remove everything related with it.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 22, 2010 at 12:16 am
(SELECT
SUBSTRING(LineRead,2,24) AS [Date]
,SUBSTRING(
LineRead,
CHARINDEX('/',LineRead)+1,
...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 22, 2010 at 12:05 am
Sree-258588 (4/21/2010)
I thought like can we write a better query or do something on the table
you can execute that in batches like on every go 10000 rows will get...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 21, 2010 at 11:43 pm
Viewing 15 posts - 1,816 through 1,830 (of 2,462 total)