Viewing 15 posts - 586 through 600 (of 1,170 total)
@RDBMS (3/16/2014)
What if I create two indexes as below:CREATE INDEX IDX_DATE
ON Transaction_Date
CREATE INDEX IDX_LOCATION
ON Location_ID
INCLUDE (Vertical_ID, Customer_Id)
You'd better go with one index having Location_ID and Transaction_Date in the key...
Igor Micev
March 16, 2014 at 11:57 am
Hi,
You should always keep the indexing key as narrower as possible. However, sometimes you could use one index to cover more queries. In your case you plan to use only...
Igor Micev
March 16, 2014 at 11:40 am
Hi
This is also a solution:
declare @table table(start varchar(4)
,[end] varchar(4))...
Igor Micev
March 16, 2014 at 6:39 am
Hi
One solution is to use conversion for @testVal
select *
from NumericOnly
where convert(varchar(4),@testVal) between NStart and NEnd
Another solution is to use a temp tables like for e.g. below:
declare @NumericOnly table(Nstart smallint,Nend smallint)
insert...
Igor Micev
March 15, 2014 at 5:41 pm
Luis Cazares (3/14/2014)
Igor Micev (3/14/2014)
Do you know that cursors' performance is nearly the same to the set-based statements when they are run on up to about 1000 rows.
Not really, it...
Igor Micev
March 14, 2014 at 3:25 pm
Do you know that cursors' performance is nearly the same to the set-based statements when they are run on up to about 1000 rows. In your case 2 million rows...
Igor Micev
March 14, 2014 at 3:04 pm
80+ filegroups is too much for that size of a database.
80+ files is also a big number, but it's more normal for files.
There are benefits of having multiple filegroups. Do...
Igor Micev
March 14, 2014 at 2:47 pm
What is the size of your database?
Do you have 80+ RAID10 volumes?
You're good with the tempdb files. Start with 1/4 and add up to 1/2 (the number of cores) if...
Igor Micev
March 14, 2014 at 2:32 pm
The attach/detach method is not recommended. Read this http://msdn.microsoft.com/en-us/library/ms345483.aspx
Igor Micev
March 11, 2014 at 10:46 am
archi (3/10/2014)
Thanks for reply.But how to go for it, i mean what are the Steps for it to process with?
If you don't have some experience with SSIS, than you can...
Igor Micev
March 10, 2014 at 12:40 pm
archi (3/10/2014)
we are planning for Microsoft SSIS i.e ETL for the same is that a feasible solution?
Exactly, SSIS is designed for such stuff.
Igor Micev
March 10, 2014 at 12:14 pm
twin.devil (3/10/2014)
like i wanna display each pincodes how to make a code?
what do mean why above statement ?
Maybe this:
select pincode,SUM(sales) from cust
group by pincode
Igor Micev
March 10, 2014 at 4:20 am
select 'Total '+convert(varchar(10),pincode) as [Total],sum(sales) [Sales]
from cust
--where pincode = 600004
group by convert(varchar(10),pincode)
Rgds
Igor Micev
March 10, 2014 at 4:18 am
Question is identical with that of 2014/02/26.
The answer is also identical.
Am I missing something?
Igor Micev
March 2, 2014 at 5:29 am
Viewing 15 posts - 586 through 600 (of 1,170 total)