Ms Sql Server Technology Discussions

[9Pardhu]

**

[deals2buy]

[quote name='9pardhu' timestamp='1350669658' post='1302657364']
**
[/quote]
pardhu [img]https://lh3.googleusercontent.com/-X6-ozvOaawI/T-eJ9JLTgQI/AAAAAAAAHCE/YAozy1LwAdA/s150/PK-71.gif[/img]

[JUJUBI_JULABI]

[quote name='deals2buy' timestamp='1350657971' post='1302655890']


requirements emaina unte kanuka aa details anni kalipi ee kinda thread lo post chey mama..

evaraikaina use avvochu

[url="http://www.andhrafriends.com/topic/343901-monna-evaro-sql-server-position-adigaaru-kada-db-lo/"]http://www.andhrafri...aru-kada-db-lo/[/url]
[/quote]
oh ok mama .. req inka baytaki raley .. they just want to recruit internally .. t sql and ssis ane chepadu vaadu ..

[ChampakDas]

[deals2buy]

[quote name='JUJUBI_JULABI' timestamp='1350673321' post='1302658045']
oh ok mama .. req inka baytaki raley .. they just want to recruit internally .. t sql and ssis ane chepadu vaadu ..
[/quote]


whatever may be..adanna post chey akkada.. and ninnu contact cheyyamanu or else edaina num unte akkada post chey

[9Pardhu]

we are intsalling sql server cluster on 2 brand new test servers.

[9Pardhu]

learning from our team.. watching their screens and making notes. SQL install lo even warnings vachina they are finiding the cause and rectifying them.. they are now installing after 0 errors and 0 warningss

[deals2buy]

[quote name='9pardhu' timestamp='1350674445' post='1302658216']
we are intsalling sql server cluster on 2 brand new test servers.
[/quote]

cluster ante endi?
[quote name='9pardhu' timestamp='1350674580' post='1302658249']
learning from our team.. watching their screens and making notes. SQL install lo even warnings vachina they are finiding the cause and rectifying them.. they are now installing after 0 errors and 0 warningss
[/quote]

ippati varaku eppudu installation cheyyaleda? atleast local machine lo aina?

[deals2buy]

[b] New feature in SQL Server 2012 - Sequence[/b]


Sequence feature which has been in Oracle for a number of years is now available in MS SQL 2012! A [color=#ff0000]Sequence object is an object that provides functionality similar to Identity (Autonumber) column.[/color] The sequence object can be used with more than one table which is not possible in identity object. This is useful when you have parent-child tables and you want to know the value of the ID column before you insert records. We are including some examples here that you can use with SQL Server 2012.




use Nwind
/*
Sequence feature which has been in Oracle for a number of years is now available in MS SQL 2012
A Sequence object is an object that provides functionality similar to Identity (Autonumber) column
The sequence object can be used with more than one table which is not possible in identity object
This is useful when you have parent-child tables and you want to know the value before you insert records
[url="http://msdn.microsoft.com/en-us/library/ff878091.aspx"]http://msdn.microsoft.com/en-us/library/ff878091.aspx[/url]
We are going to look at two examples:
-One with regular sequence function
-Second with using sequence in a table
*/
--Example 1
--run together
create sequence dbsequence
start with 1 increment by 5
select next value for dbsequence
--output=1
select next value for dbsequence
--output=6

--run seperate
drop sequence dbsequence


--Example 2, with a table
--run together
create sequence idsequence
start with 1 increment by 3
create table Products_ext
(
id int,
Name varchar(50)
)
INSERT dbo.Products_ext (Id, Name)
VALUES (NEXT VALUE FOR dbo.idsequence, 'ProductItem1')

INSERT dbo.Products_ext (Id, Name)
VALUES (NEXT VALUE FOR dbo.idsequence, 'ProductItem2')

--run seperate
select * from Products_ext
/* Output
1 ProductItem1
4 ProductItem2
*/

drop table Products_ext
drop sequence idsequence

[9Pardhu]

[quote name='deals2buy' timestamp='1350674657' post='1302658262']
cluster ante endi?
Fail Over Clustering.

ippati varaku eppudu installation cheyyaleda? atleast local machine lo aina?
[/quote]

Clustered Environment lo Installation Cheyaledu
Disk management kooda cheyali

[Desamudhuru]

nenu vunanu.

[deals2buy]

[quote name='9pardhu' timestamp='1350922278' post='1302670354']

Clustered Environment lo Installation Cheyaledu
Disk management kooda cheyali
[/quote]

Clustered environment ante endo kusantha clear ga seppu bhayya
[quote name='Desamudhuru' timestamp='1350922403' post='1302670362']
nenu vunanu.
[/quote]

which place are u from?

[9Pardhu]

[url="http://technet.microsoft.com/en-us/library/hh831579.aspx"]http://technet.microsoft.com/en-us/library/hh831579.aspx[/url]

[9Pardhu]

[quote name='deals2buy' timestamp='1350927762' post='1302670880']
Clustered environment ante endo kusantha clear ga seppu bhayya


which place are u from?
[/quote]



[url="http://www.elmajdal.net/win2k8/Installing_Failover_Clustering_With_Windows_Server_2008_R2.aspx"]http://www.elmajdal.net/win2k8/Installing_Failover_Clustering_With_Windows_Server_2008_R2.aspx[/url]

[deals2buy]

[quote name='9pardhu' timestamp='1350928980' post='1302670999']
[url="http://technet.microsoft.com/en-us/library/hh831579.aspx"]http://technet.micro...y/hh831579.aspx[/url]
[/quote]


ala matter sadivithe ardhm kaadu bhaya..simple ga mana basha lo seppochu ga