sql nerchukundam randiii... Ms sql server technology discussions...

[mtkr]

old thread closed.. so openning new thrd...

 

meek em aina dbts unte r meeku telisina interesting pts r topics unte postandiii...

 

[mtkr]

select *
from afdb 
where thread_name = 'sql_discussion'

[SwamyRaRa]

And date>='06/02/2016'

[Butterthief]

ok

[argadorn]

procedures ki macros ki difference ....

[mtkr]

6 minutes ago, argadorn said:

procedures ki macros ki difference ....

sql lo macro naa!! eppudu vinaledeee!!!

[sanbk]

Eppudu tadabadutha eh question ki interview loo performance tuning gurinchi major points em cheppalo oh palu rayandii 

[ronitreddy]

gp mayya

[mastercheif]

Differences between MS SQL vs ANSI SQL ?

[k2s]

SQL always on lo oka node on-prem and oka node cloud lo pettali. dani setup ela cheyyali ? enni listeners kavali ? enni IP addresses kavali ? enni Load balancers kavali etc ? full details pls 

[i_sudigadu]

oka string search cheyali across all the tables in a schema .. stored procedure please

[Bairagi From Bapatla]

25 minutes ago, sanbk said:

Eppudu tadabadutha eh question ki interview loo performance tuning gurinchi major points em cheppalo oh palu rayandii 

1st of all performance issue unna query ni ardham chesukovali... Then aa query lo losugulu kanipettali like joins ekkuva vaduthunara, vallu major ga use chesthunna indexes correct ga unnayo ledho check cheyali... Then aaa query execution plan chusi developer em em changes cheyalo ela ipprove cheyalo suggestions ivvali... Idhi oka chinna example

[loveindia]

ee thread enti ila undi man...

[i_sudigadu]

30 minutes ago, i_sudigadu said:

oka string search cheyali across all the tables in a schema .. stored procedure please

LTT

[SANANTONIO]

gp