Viewing 15 posts - 721 through 735 (of 1,048 total)
Learn new thing today 🙂
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
January 28, 2013 at 5:15 am
nice question..
+1 😛
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
January 23, 2013 at 10:46 pm
Can you please provide us the table structure so that we can try to solve your problem?
Its good practice to provide detailed information so that everyone can understand problem that...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
January 21, 2013 at 11:38 am
NIce basic question..
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
January 16, 2013 at 2:39 am
nice question and excellent explanation from you guys
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
January 16, 2013 at 2:32 am
really nice question.....
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
January 16, 2013 at 2:16 am
it exists on my same PC...
Can I create another instance with version 10.50.2500 on same PC ?
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
January 10, 2013 at 8:18 am
it takes about 13 min to execute 🙁
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
December 31, 2012 at 3:12 am
can we improve the %of table scan elements in Query execution plan?
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
December 30, 2012 at 11:13 pm
thanks,
I will work on this 🙂
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
December 22, 2012 at 5:34 am
But all the columns on which you are suggesting to creating indexes, all are PK in their respective tables and as per my concern when we creating a PK it...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
December 22, 2012 at 1:55 am
if i cerate index on the columns in list :
DimLocation(DimLocation)
DimInsurance(FinsCode, dimLocationId)
DimPatient(chartno, Fcategory, fPatient)
DimCategory(Fcategory)
lkpProvider(ProviderCode, ProviderCode)
DimProcedure(fProcedure)
TxPayPlan(Faccount, Finscode)
query will gets less time right?
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
December 21, 2012 at 8:12 am
No, I dont have have indexes..
please find the attached current execution plan..
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
December 21, 2012 at 4:40 am
these are the table structure that i am using:
CREATE TABLE [dbo].[DimInsurance](
[dimInsId] [int] IDENTITY(1,1) NOT NULL,
[EtlDate] [datetime] NOT NULL,
[dimLocationId] [int] NULL,
[dimInsuranceGroupId] [int] NULL,
[InsuranceGroupName] [nvarchar](30) NULL,
[Fcategory] [nvarchar](30) NULL,
[Fbillout] [tinyint] NULL,
[FinsCode] [nvarchar](10) NULL,
[Finsname]...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
December 21, 2012 at 4:10 am
Good Question 🙂
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
December 19, 2012 at 4:23 am
Viewing 15 posts - 721 through 735 (of 1,048 total)