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

[SwamyRaRa]

Just now, k2s said:

Indexes per table is 32

[kum5758]

3 minutes ago, k2s said:

>How do you track the changes – insert/update/delete transactions on the table?

 

>if the table has no primary key and there are duplicate rows in the table, how would you retrieve the duplicate rows only?

 

>differences between rank and dense rank

 

> can we pass a table as an input to stored procedure? If yes how? If no why?

 

>Differences between clustered index and non-clustered index, when to use what?

 

>If there is a primary key column and a high selectivity column, which one would you prefer having a clustered index on?

 

>How many indexes can we have on a table?

 

>What is live lock and dead lock and no lock? What is it used for?

 

bhayya alane answers kuda post-- we can maintain some sort of excel document or word by EOD and keep updating- keep up the flooww

[sanbk]

Indexes per table 32 kadu 

Clustered index only one per table

Nonclustered ayithe 249 for 2005 version 999 since 2008 onwards

[k2s]

1 minute ago, kum5758 said:

bhayya alane answers kuda post-- we can maintain some sort of excel document or word by EOD and keep updating- keep up the flooww

i have only qochens man.. am searching for answers too 

[k2s]

2 minutes ago, SwamyRaRa said:

Indexes per table is 32

why only 32 man ?why so less 

[kum5758]

last time interview questions:

replication usage for moving the data from ods database to report database--? replication best ah lekunte Red gate ah adgadu-- or Upsert Store proc or ETL--SSIS ah ani.

RDLC Reports ku RDL Reports ki difference.

Hadoop/Red Shift /Big Data/Tera Data/ Postgres SQL ku em drivers use chestharu?

 

[k2s]

Gippudey Explicit Data Types conversion nersukunna

CAST/TRY_CAST

CONVERT/TRY_CONVERT

PARSE / TRY_PARSE

STR

 

TRY version returns NULL when data type conversion fails whereas nonTry version throws error if conversion fails 

[SwamyRaRa]

3 minutes ago, sanbk said:

Indexes per table 32 kadu 

Clustered index only one per table

Nonclustered ayithe 249 for 2005 version 999 since 2008 onwards

I see ...I remember that I read somewhere its 32... Anyways thnx for updating me 

[sanbk]

2 minutes ago, k2s said:

Gippudey Explicit Data Types conversion nersukunna

CAST/TRY_CAST

CONVERT/TRY_CONVERT

PARSE / TRY_PARSE

STR

 

TRY version returns NULL when data type conversion fails whereas nonTry version throws error if conversion fails 

Lead and Lag kuda nercuko bhayya interview lo adugutharu 

[ronitreddy]

28 minutes ago, mtkr said:

performance tunng:

 

For  performance, the columns used in joins should be of the same data types. And if possible, they should be numeric data types rather than character types.

Avoid SQL Server functions in the WHERE clause for Performance
--- when functions are used in the WHERE clause this forces SQL Server to do a table scan or index scan for results instead index seek if there is index that can be used.  b/c the function value has to evaluate for each row of data to determine the match. 

Use queries with NOLOCK to over come blocking issues

create index on filtered columns if query returns large data
create index on aggregate column if they are used in aggregate functions.
create index on column if its used in order by clause
(if more inserts updates r deletes are done then indexing this decrease performance)

use join instead of correlated sub query

gp

[k2s]

1 minute ago, sanbk said:

Lead and Lag kuda nercuko bhayya interview lo adugutharu 

Sure bro... but i aint preparing for any interviews 

[ronitreddy]

2 minutes ago, sanbk said:

Lead and Lag kuda nercuko bhayya interview lo adugutharu 

Yeah..Analytical functions chala imp man

[k2s]

3 minutes ago, ronitreddy said:

Yeah..Analytical functions chala imp man

antey endo seppochu kada man 

imp un-imp antey saripothunda 

[mtkr]

29 minutes ago, sri_india said:

mahatma , meeru SQL guruvu mahatma

avi ekkado copy kotti raasukunnaviii...

guruvu 

               

[loveindia]

15 minutes ago, SwamyRaRa said:

Indexes per table is 32

32 is number of nesting levels a stored procedure can have upto man.. its not the number of indexes a table can have...