Viewing 15 posts - 316 through 330 (of 2,463 total)
SQL_Enthusiast (2/20/2013)
it can't just be random because it's supposed to be unique, correct?)
why you think that random cant be unique ? sql server internally generate this 32...
February 20, 2013 at 11:16 pm
definitely conversion has some cost whether it is explicit or implicit. and if the cast/convert have been used in left part of filter (like cast(last_name as nvarchar(30)) = 'bhuv')...
February 20, 2013 at 11:05 pm
Harish Ajabe (2/20/2013)
But as per requirement I wanted to create computed column this way. Is there any workaround for this so I could execute above DDL query?
If possible ,...
February 20, 2013 at 12:23 am
ScottPletcher (2/18/2013)
Cluster the table by the most common WHERE conditions; make the clustered key unique by including the Policy_transactional_ID on the...
February 18, 2013 at 11:25 pm
GilaMonster (2/15/2013)
identity column does not guarantee uniqueness.
is it so ? but it always generate new value incremented to previous one
February 18, 2013 at 5:11 am
Andy Hyslop (2/15/2013)
could test your ETL's by dropping all of your indexes and re-creating and determining the impact so see which is more efficient
Does it cost intensive if we...
February 18, 2013 at 1:11 am
Jason-299789 (2/15/2013)
It depends, what is the ETL process, is it a snapshot Fact (as is) or incremental with Insert new update existing,
it will be "incremental with Insert new...
February 18, 2013 at 1:09 am
You can use SSIS package which wil only transfer the data.
February 18, 2013 at 12:58 am
Jason-299789 (2/18/2013)
you could use the WITH RECOMPILE option on SP's as its a data warehouse so theres not a major impact with this.
HOw this wouldnt hurt the performance. ?...
February 18, 2013 at 12:56 am
February 15, 2013 at 3:23 am
GilaMonster (2/8/2013)
need information on the queries, the data type, the data distribution and insert pattern, the common access path into the table
Most of the queries having filter
on "Ids...
February 8, 2013 at 1:59 am
m.rajesh.uk (2/8/2013)
February 8, 2013 at 1:07 am
Two approaches :
1) partitioning
2 ) batch process to delete the data (done by scheduled job)
February 8, 2013 at 12:00 am
following are the factors responsible which make the difference in statistics
1) exec plan cached or not ?
2) data available in buffer or not ?
3) statistics upodated or...
February 7, 2013 at 11:44 pm
Viewing 15 posts - 316 through 330 (of 2,463 total)