Ms Sql Server Technology Discussions

[deals2buy]

[quote name='Aamphat' timestamp='1351006539' post='1302676220']
antey em em chestaaru vaay..
dantlo development side untadha ? testing side untadha ? admin side untadha ?
anni angles untaaya?
queries tho ney kotich kovaala ?
adhi languaage aa ?....(not ..because its a tool)
[/quote]


anni sides untaayi..development, testing, admin (to be specifi testing peddaga undadu anukuntunna)

queries tho ne kotttichukovakkarledu..basically SQL Server lo 4 parts

1) SSMS - the platform/tool which is used to do all the work using queries (language used is called T-SQL)
2) SSIS - tool which is used to perform the ETL Work
3) SSRS - tool which is used to generate reports
4) SSAS - which is also a tool for reporting but holds the data in a 3 dimensional view. (fast retrieval of data untundi ikkada)

PS: 2 & 3 tools lo kuda querying use cheyyochu/chestaru. 4 lo different type of querying untundi(which are called MDX queries)

[deals2buy]

[quote name='DARLING...' timestamp='1351006652' post='1302676229']

aah Istaadu istaadu 100 teeskuntey nenu ila DB lo undey vaadini kaadu ee time ki [img]http://i56.tinypic.com/2w2r5gm.jpg[/img]
[/quote]

NASA lo unde vaadiva? [img]http://i56.tinypic.com/2w2r5gm.jpg[/img]

[vikuba]

thank you deals to buy
per maarpinchukoo needhi...edhaina better name adgu admin ni

[url="http://en.wikipedia.org/wiki/Microsoft_SQL_Server"]http://en.wikipedia.org/wiki/Microsoft_SQL_Server[/url]

[deals2buy]

[quote name='Aamphat' timestamp='1351006941' post='1302676253']
thank you deals to buy
[size=4][color=#FF0000]per maarpinchukoo needhi...edhaina better name adgu admin ni[/color][/size]

[url="http://en.wikipedia.org/wiki/Microsoft_SQL_Server"]http://en.wikipedia....soft_SQL_Server[/url]
[/quote]


adenti maaya sudden ga ala anesaaav?

aa kinda link enti? wikipedia link ivvakunda eedu sodantha seppadu ani sattire aa? [img]http://i56.tinypic.com/2w2r5gm.jpg[/img]

[vikuba]

[quote name='deals2buy' timestamp='1351007070' post='1302676264']


adenti maaya sudden ga ala anesaaav?

aa kinda link enti? wikipedia link ivvakunda eedu sodantha seppadu ani sattire aa? [img]http://i56.tinypic.com/2w2r5gm.jpg[/img]
[/quote]no sattires..
nuvu one word istey..nen elli akada saduvuku vacha...
but nuv koncham better clarity ichav...so oorkey source pasted.

deals2buy...ticketforsale ratriki_rendu_vandhal endhivaay ee perlu..
interact aitunappdu konchame better name untey we can get to you...u know..
nothin offensive..if you felt so..mybad

[deals2buy]

[quote name='Aamphat' timestamp='1351007547' post='1302676314']
no sattires..
nuvu one word istey..nen elli akada saduvuku vacha...
but nuv koncham better clarity ichav...so oorkey source pasted.

deals2buy...ticketforsale ratriki_rendu_vandhal endhivaay ee perlu..
interact aitunappdu konchame better name untey we can get to you...u know..
nothin offensive..if you felt so..mybad
[/quote]nee yavva ratriki_rendu_vandal aa? [img]http://i56.tinypic.com/2w2r5gm.jpg[/img] adi lollillolli2012 peru kada [img]http://i56.tinypic.com/2w2r5gm.jpg[/img]

sarle..nenu kuda name change cheyinchukundaam ani eppati nundo anukuntunna..ela change cheyichukovali ippudu?

[deals2buy]

declare @Quota1 int, @Quota2 int, @Quota3 int, @Value int;

Set @Value = 20;

select @Quota1 = @Value * 1.05;

select @Quota2 = cast(@Value as real) * 1.05;

Set @Value = 100;

select @Quota3 = cast(@Value as real) * 1.05;

Select @Quota1 * 5, @Quota2 * 5, @Quota3;



ee paina query execute chesinappudu aa @Quota3 value enduku differ aitundi? evaraina cheppandi plz

[deals2buy]

[b] Using the Script Task in SSIS to Process Data Files When They Arrive[/b]



The most used task in almost all businesses. Hope it helps someone

http://www.sqlservercentral.com/articles/Integration+Services+%28SSIS%29/91665/

[Darling999]

[quote name='deals2buy' timestamp='1351089807' post='1302682049']
declare @Quota1 int, @Quota2 int, @Quota3 int, @Value int;

Set @Value = 20;

select @Quota1 = @Value * 1.05;

select @Quota2 = cast(@Value as real) * 1.05;

Set @Value = 100;

select @Quota3 = cast(@Value as real) * 1.05;

Select @Quota1 * 5, @Quota2 * 5, @Quota3;



ee paina query execute chesinappudu aa @Quota3 value enduku differ aitundi? evaraina cheppandi plz
[/quote]

@Quota3 painaa @Value lo 100 ani pettav kada enduku maradu mari ....

[Darling999]

[quote name='deals2buy' timestamp='1351177792' post='1302688108']
[b] Using the Script Task in SSIS to Process Data Files When They Arrive[/b]



The most used task in almost all businesses. Hope it helps someone

[url="http://www.sqlservercentral.com/articles/Integration+Services+%28SSIS%29/91665/"]http://www.sqlserver...s (SSIS)/91665/[/url]
[/quote]
Deals2Buy roju oka kotha topic esi deeni paiki lepudaam SQl Chadivey vallaki use ayitadi

[deals2buy]

[quote name='DARLING...' timestamp='1351178279' post='1302688171']
@Quota3 painaa @Value lo 100 ani pettav kada enduku maradu mari ....
[/quote]
[quote name='DARLING...' timestamp='1351178356' post='1302688180']
Deals2Buy roju oka kotha topic esi deeni paiki lepudaam SQl Chadivey vallaki use ayitadi
[/quote]sure..naa vanthu krushi nenu chestunna

[ChampakDas]

endhi comedy naa jsut above the final query value marsutunnav kada
[quote name='deals2buy' timestamp='1351089807' post='1302682049']
declare @Quota1 int, @Quota2 int, @Quota3 int, @Value int;

Set @Value = 20;

select @Quota1 = @Value * 1.05;

select @Quota2 = cast(@Value as real) * 1.05;

Set @Value = 100;

select @Quota3 = cast(@Value as real) * 1.05;

Select @Quota1 * 5, @Quota2 * 5, @Quota3;



ee paina query execute chesinappudu aa @Quota3 value enduku differ aitundi? evaraina cheppandi plz
[/quote]

[deals2buy]

[quote name='ChampakDas' timestamp='1351180426' post='1302688385']
endhi comedy naa jsut above the final query value marsutunnav kada
[/quote]
aa sangathi taruvatha chusina maaya

[ChampakDas]

veelu untey chadavandi vayya...chadivi pakanolaki chepandi..delete gurinchi thelusu truncate gurinchi thelusu...reseed gurinchi nerchukondi

CREATE TABLE Test(
ID INT IDENTITY(11,1) NOT NULL,
VARD VARCHAR(10) NULL
) ON [PRIMARY]
GO


INSERT INTO Test
VALUES ('abc')
GO

select * from test

DBCC CHECKIDENT ('Test', RESEED, 1)
GO

new value will insert internalvalue + reseed value here it is 1+1 =2...query execute cheskondi ardham ipotundhi

[deals2buy]

[quote name='ChampakDas' timestamp='1351181222' post='1302688456']
veelu untey chadavandi vayya...chadivi pakanolaki chepandi..delete gurinchi thelusu truncate gurinchi thelusu...reseed gurinchi nerchukondi

CREATE TABLE Test(
ID INT IDENTITY(11,1) NOT NULL,
VARD VARCHAR(10) NULL
) ON [PRIMARY]
GO


INSERT INTO Test
VALUES ('abc')
GO

select * from test

DBCC CHECKIDENT ('Test', RESEED, 1)
GO

new value will insert internalvalue + reseed value here it is 1+1 =2...query execute cheskondi ardham ipotundhi
[/quote]


Checking identity information: current identity value '11', current column value '1'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.


ee msg vachindi..daani ardham endi mayya?