Ms Sql Server Technology Discussions

[mtkr]

[quote name='chelsea' timestamp='1354160570' post='1302869136']
guys evaru ayyina data modeling meda chesaru database design and ER model ayyina sare koncham help cheyyara
[/quote]

ne req enti mama!!!?
like db design chesthunnaraa!!! tbls inka annii?

[deals2buy]

[quote name='mtkr' timestamp='1354158005' post='1302868960']
endhi mama prathi saarii baaga ochina vallu unnara ani aduguthavvv....!!!! leru ante ne Q adagavaaa????

[b][color=#ff0000]No 1 iz perfect in this world!!!![/color][/b]


ne dbt ei ikkadaaa......
[/quote]

[deals2buy]

[b] Splitting Strings Based on Patterns[/b]


[url="http://www.sqlservercentral.com/articles/String+Manipulation/94365/"]http://www.sqlservercentral.com/articles/String+Manipulation/94365/[/url]

[Desamudhuru]

[quote name='deals2buy' timestamp='1354202924' post='1302870888']
[b] Splitting Strings Based on Patterns[/b]


[url="http://www.sqlservercentral.com/articles/String+Manipulation/94365/"]http://www.sqlserver...pulation/94365/[/url]
[/quote]
register ava mantondi bhayya

[deals2buy]

[b]
[url="http://www.sqlservercentral.com/blogs/dave_ballantynes_blog/2012/11/26/when-row-estimation-goes-wrong/"]When row estimation goes wrong[/url][/b]

[deals2buy]

How many queries does the following code produce in an estimated execution plan?

Begin Transaction

SET QUOTED_IDENTIFIER ON;

SET ARITHABORT ON;

SET NUMERIC_ROUNDABORT OFF;

SET CONCAT_NULL_YIELDS_NULL ON;

SET ANSI_NULLS ON;

SET ANSI_PADDING ON;

SET ANSI_WARNINGS ON;

COMMIT

[deals2buy]

[b]
[url="http://www.sqlservercentral.com/blogs/sql_awesomesauce/2012/11/26/tip-over-and-partition-by/"]Tip: OVER and PARTITION BY[/url][/b]

[chelsea]

[quote name='mtkr' timestamp='1354162511' post='1302869206']

ne req enti mama!!!?
like db design chesthunnaraa!!! tbls inka annii?
[/quote]

na reqirement kada job search lo vunna andaru database design and data modeling aduguthunnaru

[deals2buy]

[quote name='chelsea' timestamp='1354203100' post='1302870905']

na reqirement kada job search lo vunna andaru database design and data modeling aduguthunnaru
[/quote]
doubt ento exact ga adugu? chesina vaallu kaavala? leka em cheppala ani?

[Desamudhuru]

[quote name='chelsea' timestamp='1354203100' post='1302870905']

na reqirement kada job search lo vunna andaru database design and data modeling aduguthunnaru
[/quote]
EDI ADIGINA 2 YRS ANI CHEPU. Konowledge vundi handle cheyagalanu ani chepu. End of the day nuvu interview lo manager tho matlade daka emi kavalo em avasaram ledo telusthadi. Madhyalo vendor gallu masthu pisuku tharu. So, anni telusu ani chepu.

[Darling999]

[quote name='deals2buy' timestamp='1354123569' post='1302865620']
Sorrry, paina data maarchanu chudu


I want output like this:

1,Chicago, 2012-11-27, 2020-12-31
[/quote]

nuvvu nenu raasina query lo ee entities petti choodu vastadi

filder lo NOT null pettu city ki , NULL unnavi automatic ga eliminate avtaayi incase NULL lekundaa value untey display avtadi.

[Darling999]

[quote name='chelsea' timestamp='1354203100' post='1302870905']

na reqirement kada job search lo vunna andaru database design and data modeling aduguthunnaru
[/quote]

erwin and targit tools meeda light ga research cheyyi ayipoddi. datamodelling nenu cheyyaledu but ee madya konni interviews lo adigaaru nannu kudaa.

[deals2buy]

[quote name='DARLING...' timestamp='1354206425' post='1302871269']

nuvvu nenu raasina query lo ee entities petti choodu vastadi

filder lo NOT null pettu city ki , NULL unnavi automatic ga eliminate avtaayi incase NULL lekundaa value untey display avtadi.
[/quote]
NOT NULL pedithe vasthadani naaku telusu bhayya..but I am not supposed to do so...

May be MTKR bhayya cheppinattu self join cheyyali anukunta

[Darling999]

[quote name='deals2buy' timestamp='1354210234' post='1302871842']
NOT NULL pedithe vasthadani naaku telusu bhayya..but I am not supposed to do so...

May be MTKR bhayya cheppinattu self join cheyyali anukunta
[/quote]
ooh ok ayitey case statement raaskoo lekapotey chinna subquery raasko A does not exit in B ani vastundi

[deals2buy]

[quote name='DARLING...' timestamp='1354210481' post='1302871873']
ooh ok ayitey case statement raaskoo lekapotey chinna subquery raasko A does not exit in B ani vastundi
[/quote]
ya subquery kante case statement better anipistondi...but even though I find some duplicates

chudaali inkem possibilities unnayo