Jump to content

Ms Sql Server Technology Discussions

9Pardhu

By 9Pardhu
in Old Discussions

 Share

Recommended Posts

9Pardhu Side Hero

9Pardhu

Posted
  • Author
Posted

High-availability clusters (also known as HA clusters or failover clusters) are groups of computers that support server applications that can be reliably utilized with a minimum of down-time. They operate by harnessing redundant computers in groups or clusters that provide continued service when system components fail. Without clustering, if a server running a particular application crashes, the application will be unavailable until the crashed server is fixed. HA clustering remedies this situation by detecting hardware/software faults, and immediately restarting the application on another system without requiring administrative intervention, a process known as failover. As part of this process, clustering software may configure the node before starting the application on it. For example, appropriate filesystems may need to be imported and mounted, network hardware may have to be configured, and some supporting applications may need to be running as well.

Link to comment
Share on other sites
  • Replies 1.6k
  • Created
  • Last Reply

Top Posters In This Topic

  • deals2buy

    643

  • Darling999

    178

  • mtkr

    118

  • loveindia

    112

Popular Days

Top Posters In This Topic

Popular Days

Popular Posts

loveindia
loveindia

[quote name='calmandquiet' timestamp='1362496130' post='1303368874'] Calling SSAS thopulu [b]AFAIK Facts & Dimensions are base tables and based on those tables you build Cubes[/b] ----what

loveindia
loveindia

[quote name='calmandquiet' timestamp='1362496304' post='1303368889'] SSIS Packages to import data daily from OLTP Applications to data [size=4]warehouse Evvaraina chesara ?????[/size] [/quote] c

deals2buy
deals2buy

nice posts rey loveindia, Littlemoon, DARLING

deals2buy Celebrity

deals2buy

Posted
Posted

[quote name='9pardhu' timestamp='1350936923' post='1302671737']
High-availability clusters (also known as HA clusters or failover clusters) are groups of computers that support server applications that can be reliably utilized with a minimum of down-time. They operate by harnessing redundant computers in groups or clusters that provide continued service when system components fail. Without clustering, if a server running a particular application crashes, the application will be unavailable until the crashed server is fixed. HA clustering remedies this situation by detecting hardware/software faults, and immediately restarting the application on another system without requiring administrative intervention, a process known as failover. As part of this process, clustering software may configure the node before starting the application on it. For example, appropriate filesystems may need to be imported and mounted, network hardware may have to be configured, and some supporting applications may need to be running as well.
[/quote]


koddiga clear ga seppamante akkada nundi matter teesukochi paste chesatava [img]https://lh4.googleusercontent.com/-2pGLHOiACac/TX5xcSHoksI/AAAAAAAAB9k/-GfBtkrsonc/s180/CHiru%2520beating.gif[/img]

Link to comment
Share on other sites
9Pardhu Side Hero

9Pardhu

Posted
  • Author
Posted

dantlo ardam kakapovadaniki emundi ..... neeku sadavadaniki ollu baruvu la vunde.. anduke neekosam wikipedia nunche copy chesa,
[img]http://www.desigifs.com/sites/default/files/a0dm6w.gif?1290061243[/img]

Link to comment
Share on other sites
deals2buy Celebrity

deals2buy

Posted
Posted

[quote name='9pardhu' timestamp='1350938441' post='1302671914']
dantlo ardam kakapovadaniki emundi ..... neeku sadavadaniki ollu baruvu la vunde.. anduke neekosam wikipedia nunche copy chesa,
[img]http://www.desigifs.com/sites/default/files/a0dm6w.gif?1290061243[/img]
[/quote]


ala ala english raaste ardham kaadu bhayya..koddiga mana native terms lo easy ga cheppochu ga

Link to comment
Share on other sites
deals2buy Celebrity

deals2buy

Posted
Posted

aaha PATINDEX gurinchi racha example..real time lo baga use chestuntaru ee scenario..Hope it helps u guys

[color=green]-- How to find first non numberic character[/color]
[color=blue]USE [/color][color=black]tempdb
GO[/color]
[color=blue]CREATE TABLE [/color][color=black]MyTable [/color][color=gray]([/color][color=black]ID [/color][color=blue]INT[/color][color=gray], [/color][color=black]Col1 [/color][color=blue]VARCHAR[/color][color=gray]([/color][color=black]100[/color][color=gray]))[/color]
[color=black]GO[/color]
[color=blue]INSERT INTO [/color][color=black]MyTable [/color][color=gray]([/color][color=black]ID[/color][color=gray], [/color][color=black]Col1[/color][color=gray])[/color]
[color=blue]SELECT [/color][color=black]1[/color][color=gray], [/color][color=red]'1one'[/color]
[color=blue]UNION [/color][color=gray]ALL[/color]
[color=blue]SELECT [/color][color=black]2[/color][color=gray], [/color][color=red]'11eleven'[/color]
[color=blue]UNION [/color][color=gray]ALL[/color]
[color=blue]SELECT [/color][color=black]3[/color][color=gray], [/color][color=red]'2two'[/color]
[color=blue]UNION [/color][color=gray]ALL[/color]
[color=blue]SELECT [/color][color=black]4[/color][color=gray], [/color][color=red]'22twentytwo'[/color]
[color=blue]UNION [/color][color=gray]ALL[/color]
[color=blue]SELECT [/color][color=black]5[/color][color=gray], [/color][color=red]'111oneeleven'[/color]
[color=black]GO[/color]
[color=green]-- Select Data[/color]
[color=blue]SELECT [/color][color=gray]*[/color]
[color=blue]FROM [/color][color=black]MyTable
GO[/color]
[color=green]-- Select Data[/color]
[color=blue]SELECT [/color][color=gray]*[/color]
[color=blue]FROM [/color][color=black]MyTable[/color]
[color=blue]ORDER BY [/color][color=black]Col1
GO[/color]
[color=green]-- Use of PATINDEX[/color]
[color=blue]SELECT [/color][color=black]ID[/color][color=gray],[/color]
[color=black]Col1 [/color][color=red]'Original Character'[/color]
[color=blue]FROM [/color][color=black]MyTable[/color]
[color=blue]ORDER BY [/color][color=magenta]LEFT[/color][color=gray]([/color][color=black]Col1[/color][color=gray],[/color][color=magenta]PATINDEX[/color][color=gray]([/color][color=red]'%[^0-9]%'[/color][color=gray],[/color][color=black]Col1[/color][color=gray])-[/color][color=black]1[/color][color=gray])[/color]
[color=black]GO[/color]
[color=blue]DROP TABLE [/color][color=black]MyTable
GO[/color]

-- Alternative Solution to the above:

SELECT ID,
Col1 'Original Character'
FROM MyTable
ORDER BY LEFT(Col1,PATINDEX('%[^0-9]%',Col1+'a')-1)

SELECT ID, Col1 'Original Character' FROM MyTable ORDER BY UNICODE(Col1), PATINDEX('%[^0-9]%', Col1+'a'), Col1


-- One more alternative to the above

select ID, Col1 as Original_String, SUBSTRING(Col1, 0, PATINDEX('%[a-z]%', Col1)) as Numeric_Character
from MyTable
order by Numeric_Character

Link to comment
Share on other sites
Darling999 Celebrity

Darling999

Posted
Posted

[quote name='deals2buy' timestamp='1351000841' post='1302675783']
aaha PATINDEX gurinchi racha example..real time lo baga use chestuntaru ee scenario..Hope it helps u guys

[color=green]-- How to find first non numberic character[/color]
[color=blue]USE [/color][color=black]tempdb
GO[/color]
[color=blue]CREATE TABLE [/color][color=black]MyTable [/color][color=gray]([/color][color=black]ID [/color][color=blue]INT[/color][color=gray], [/color][color=black]Col1 [/color][color=blue]VARCHAR[/color][color=gray]([/color][color=black]100[/color][color=gray]))[/color]
[color=black]GO[/color]
[color=blue]INSERT INTO [/color][color=black]MyTable [/color][color=gray]([/color][color=black]ID[/color][color=gray], [/color][color=black]Col1[/color][color=gray])[/color]
[color=blue]SELECT [/color][color=black]1[/color][color=gray], [/color][color=red]'1one'[/color]
[color=blue]UNION [/color][color=gray]ALL[/color]
[color=blue]SELECT [/color][color=black]2[/color][color=gray], [/color][color=red]'11eleven'[/color]
[color=blue]UNION [/color][color=gray]ALL[/color]
[color=blue]SELECT [/color][color=black]3[/color][color=gray], [/color][color=red]'2two'[/color]
[color=blue]UNION [/color][color=gray]ALL[/color]
[color=blue]SELECT [/color][color=black]4[/color][color=gray], [/color][color=red]'22twentytwo'[/color]
[color=blue]UNION [/color][color=gray]ALL[/color]
[color=blue]SELECT [/color][color=black]5[/color][color=gray], [/color][color=red]'111oneeleven'[/color]
[color=black]GO[/color]
[color=green]-- Select Data[/color]
[color=blue]SELECT [/color][color=gray]*[/color]
[color=blue]FROM [/color][color=black]MyTable
GO[/color]
[color=green]-- Select Data[/color]
[color=blue]SELECT [/color][color=gray]*[/color]
[color=blue]FROM [/color][color=black]MyTable[/color]
[color=blue]ORDER BY [/color][color=black]Col1
GO[/color]
[color=green]-- Use of PATINDEX[/color]
[color=blue]SELECT [/color][color=black]ID[/color][color=gray],[/color]
[color=black]Col1 [/color][color=red]'Original Character'[/color]
[color=blue]FROM [/color][color=black]MyTable[/color]
[color=blue]ORDER BY [/color][color=magenta]LEFT[/color][color=gray]([/color][color=black]Col1[/color][color=gray],[/color][color=magenta]PATINDEX[/color][color=gray]([/color][color=red]'%[^0-9]%'[/color][color=gray],[/color][color=black]Col1[/color][color=gray])-[/color][color=black]1[/color][color=gray])[/color]
[color=black]GO[/color]
[color=blue]DROP TABLE [/color][color=black]MyTable
GO[/color]

-- Alternative Solution to the above:

SELECT ID,
Col1 'Original Character'
FROM MyTable
ORDER BY LEFT(Col1,PATINDEX('%[^0-9]%',Col1+'a')-1)

SELECT ID, Col1 'Original Character' FROM MyTable ORDER BY UNICODE(Col1), PATINDEX('%[^0-9]%', Col1+'a'), Col1


-- One more alternative to the above

select ID, Col1 as Original_String, SUBSTRING(Col1, 0, PATINDEX('%[a-z]%', Col1)) as Numeric_Character
from MyTable
order by Numeric_Character
[/quote]

Nice one DealstoBuy

Link to comment
Share on other sites
deals2buy Celebrity

deals2buy

Posted
Posted

[quote name='DARLING...' timestamp='1351005556' post='1302676129']

Nice one DealstoBuy
[/quote]
thankyou mama

nuvvu DBA kadaa..ivanni meeku antha use undakapovachu ga sSc_hidingsofa

Link to comment
Share on other sites
vikuba LEGEND

vikuba

Posted
Posted

SQL server tech antey enti ? meeru server ni update cheyadam ? cycles run cheyadam lantivi ?
anythin invovled with querying

Link to comment
Share on other sites
Darling999 Celebrity

Darling999

Posted
Posted

[quote name='deals2buy' timestamp='1351005607' post='1302676136']
thankyou mama

nuvvu DBA kadaa..ivanni meeku antha use undakapovachu ga sSc_hidingsofa
[/quote]
nenu BI mama, SSIS/AS/RS chestaa Also Admin kudaa.. Veedu nachetaa cheyinchani pani ledu. Lan Admin, Sharepoint dev, SQl etc etc etc [img]http://lh6.ggpht.com/-KhXstN1bseU/T-LLDDtHUWI/AAAAAAAAHTw/k5J4J0Xge_Y/h120/chakri.gif[/img]

Link to comment
Share on other sites
deals2buy Celebrity

deals2buy

Posted
Posted

[quote name='Aamphat' timestamp='1351005783' post='1302676151']
SQL server tech antey enti ? meeru server ni update cheyadam ? cycles run cheyadam lantivi ?
anythin invovled with querying
[/quote]
:3D_Smiles: Miscrosoft's Database tool adi

Link to comment
Share on other sites
deals2buy Celebrity

deals2buy

Posted
Posted

[quote name='DARLING...' timestamp='1351005860' post='1302676163']
nenu BI mama, SSIS/AS/RS chestaa Also Admin kudaa.. Veedu nachetaa cheyinchani pani ledu. Lan Admin, Sharepoint dev, SQl etc etc etc [img]http://lh6.ggpht.com/-KhXstN1bseU/T-LLDDtHUWI/AAAAAAAAHTw/k5J4J0Xge_Y/h120/chakri.gif[/img]
[/quote]
aithe pay kuda oka $100/hr untundi ga ..inkenduku edupu? [img]http://i56.tinypic.com/2w2r5gm.jpg[/img]

Link to comment
Share on other sites
vikuba LEGEND

vikuba

Posted
Posted

[quote name='deals2buy' timestamp='1351005891' post='1302676166']
:3D_Smiles: Miscrosoft's Database tool adi
[/quote]
ok...
inka ? chepu..bhaiya...
batti kotukochinattu...oneword answer voddu pls

Link to comment
Share on other sites
deals2buy Celebrity

deals2buy

Posted
Posted

[quote name='Aamphat' timestamp='1351006004' post='1302676176']
ok...
inka ? chepu..bhaiya...
batti kotukochinattu...oneword answer voddu pls
[/quote]
inka endi? [img]http://i56.tinypic.com/2w2r5gm.jpg[/img] idemaina love story na? [img]http://i56.tinypic.com/2w2r5gm.jpg[/img]

Link to comment
Share on other sites
vikuba LEGEND

vikuba

Posted
Posted

[quote name='deals2buy' timestamp='1351006057' post='1302676182']
inka endi? [img]http://i56.tinypic.com/2w2r5gm.jpg[/img] idemaina love story na? [img]http://i56.tinypic.com/2w2r5gm.jpg[/img]
[/quote]
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)

Link to comment
Share on other sites
Darling999 Celebrity

Darling999

Posted
Posted

[quote name='deals2buy' timestamp='1351005934' post='1302676169']
aithe pay kuda oka $100/hr untundi ga ..inkenduku edupu? [img]http://i56.tinypic.com/2w2r5gm.jpg[/img]
[/quote]

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

Link to comment
Share on other sites
 Share
Go to topic listing
×
×
  • Create New...