Viewing 15 posts - 316 through 330 (of 2,462 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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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')...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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 ,...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
February 18, 2013 at 1:09 am
You can use SSIS package which wil only transfer the data.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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. ?...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
February 18, 2013 at 12:56 am
see this http://www.sqlservercentral.com/Forums/Topic580781-146-1.aspx
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
February 15, 2013 at 3:23 am
2.5 to 5 Lacs
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
February 15, 2013 at 3:20 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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
February 8, 2013 at 1:59 am
m.rajesh.uk (2/8/2013)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
February 8, 2013 at 1:07 am
Two approaches :
1) partitioning
2 ) batch process to delete the data (done by scheduled job)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
February 7, 2013 at 11:44 pm
Viewing 15 posts - 316 through 330 (of 2,462 total)