Jump to content

Ms Sql Server Technology Discussions

9Pardhu

By 9Pardhu
in Old Discussions

 Share

Recommended Posts

loveindia LEGEND

loveindia

Posted
Posted

[quote name='Kaarthikeya' timestamp='1365446037' post='1303565509']
cheste em prob avutundi? sCo_^Y okasari nenu indexes pettakunda/petto gurthu ledu kaani oka data load run chesa....oka 30 min ayye sariki DBA gaadu em chestunnav desk daggara...disk space ala aipoindi okkasare annadu CITI_c$y
[/quote]

temp db full aindi ani shrink chestey evaranna active ga run chestunna connections alantivi anni bisket avtaai... plus 90% of the times databases corrupt avtai.. appudu ninnu boothulu titti bayataki tostaaru simple ga... try it once ya... feel the fireeeeeeeee.....

ur dba called u cos, may be nuvvu chestunna dataload dead lock create chesi migata anni resources ni eating emo.. or tempdb fill up aipotu undi emo.. indexes are good if correctly used, nightmare if played around with...

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='loveindia' timestamp='1365446841' post='1303565680']

temp db full aindi ani shrink chestey evaranna active ga run chestunna connections alantivi anni bisket avtaai... plus 90% of the times databases corrupt avtai.. appudu ninnu boothulu titti bayataki tostaaru simple ga... try it once ya... feel the fireeeeeeeee.....

ur dba called u cos, may be nuvvu chestunna dataload dead lock create chesi migata anni resources ni eating emo.. or tempdb fill up aipotu undi emo.. indexes are good if correctly used, nightmare if played around with...
[/quote]

first line...naaku antha dhoola ledu maha prabho @3$%

second line @gr33d

Link to comment
Share on other sites
littlemoon Celebrity

littlemoon

Posted
Posted

[quote name='kumargadu' timestamp='1365445733' post='1303565468']


you rock I did that , Thank you !!!
[/quote] _-_ a day or two log files growth ela undo cheyandi also trn backup ni chk chesthundalii
[quote name='Kaarthikeya' timestamp='1365445406' post='1303565429']


*=: you rock both of u
[/quote] S#d^[size=4] [/size]

Link to comment
Share on other sites
littlemoon Celebrity

littlemoon

Posted
Posted

guys question...

In sql 2008 oka database logins and permissions script cheyali... evari degara aina script alrdy unte pls share...

also GUI nunchi cheydnaki emaina procedure unte chepandi.. :4_12_13:[size=4] [/size]

Link to comment
Share on other sites
deals2buy Celebrity

deals2buy

Posted
Posted

[quote name='littlemoon' timestamp='1365448963' post='1303566126']
guys question...

In sql 2008 oka database logins and permissions script cheyali... evari degara aina script alrdy unte pls share...

also GUI nunchi cheydnaki emaina procedure unte chepandi.. :4_12_13:
[/quote]

GUI lo aithe...usually right click chesi aa script lo ye user ki kaavalante aa user name enter chesi run cheyyadame kada...I might be wrong

Link to comment
Share on other sites
littlemoon Celebrity

littlemoon

Posted
Posted

[quote name='Kaarthikeya' timestamp='1365449650' post='1303566199']
GUI lo aithe...usually right click chesi aa script lo ye user ki kaavalante aa user name enter chesi run cheyyadame kada...I might be wrong
[/quote]
permissions kuda generate avali... kani whn I do as you said only create user ani untundi

Link to comment
Share on other sites
innovative LEGEND

innovative

Posted
Posted

[quote name='littlemoon' timestamp='1365448963' post='1303566126']
guys question...

In sql 2008 oka database logins and permissions script cheyali... evari degara aina script alrdy unte pls share...

also GUI nunchi cheydnaki emaina procedure unte chepandi.. :4_12_13:
[/quote]
requirement clear ga cheppu javascript iythe rasipedtha .. :P

Link to comment
Share on other sites
deals2buy Celebrity

deals2buy

Posted
Posted

[quote name='littlemoon' timestamp='1365449735' post='1303566206']
permissions kuda generate avali... kani whn I do as you said only create user ani untundi
[/quote]

Thats what I've mentioned...but again I might be wrong

[CODE]
/****** Object: DatabaseRole [db_accessadmin] ******/
EXEC dbo.sp_addrole @rolename = N'db_accessadmin', @ownername = N'dbo'
/****** Object: DatabaseRole [db_backupoperator] ******/
EXEC dbo.sp_addrole @rolename = N'db_backupoperator', @ownername = N'dbo'
/****** Object: DatabaseRole [db_datareader] ******/
EXEC dbo.sp_addrole @rolename = N'db_datareader', @ownername = N'dbo'
/****** Object: DatabaseRole [db_datawriter] ******/
EXEC dbo.sp_addrole @rolename = N'db_datawriter', @ownername = N'dbo'
/****** Object: DatabaseRole [db_ddladmin] ******/
EXEC dbo.sp_addrole @rolename = N'db_ddladmin', @ownername = N'dbo'
/****** Object: DatabaseRole [db_denydatareader] ******/
EXEC dbo.sp_addrole @rolename = N'db_denydatareader', @ownername = N'dbo'
/****** Object: DatabaseRole [db_denydatawriter] ******/
EXEC dbo.sp_addrole @rolename = N'db_denydatawriter', @ownername = N'dbo'

/****** Object: DatabaseRole [db_owner] ******/
EXEC dbo.sp_addrole @rolename = N'db_owner', @ownername = N'dbo'

/****** Object: DatabaseRole [db_securityadmin] ******/
EXEC dbo.sp_addrole @rolename = N'db_securityadmin', @ownername = N'dbo'
[/CODE]

Link to comment
Share on other sites
deals2buy Celebrity

deals2buy

Posted
Posted

[quote name='innovative' timestamp='1365449945' post='1303566224']
requirement clear ga cheppu javascript iythe rasipedtha .. :P
[/quote]naaku javascript nerpinchu aithe :P

Link to comment
Share on other sites
innovative LEGEND

innovative

Posted
Posted

[quote name='Kaarthikeya' timestamp='1365450208' post='1303566249']
naaku javascript nerpinchu aithe :P
[/quote]
nerpinche antha time ledhu kaarthik ... emanna script kavali ante i can help .. S%Hi

Link to comment
Share on other sites
littlemoon Celebrity

littlemoon

Posted
Posted

[quote name='innovative' timestamp='1365449945' post='1303566224']
requirement clear ga cheppu javascript iythe rasipedtha .. :P
[/quote] :D ikada vaddu le
[quote name='Kaarthikeya' timestamp='1365450142' post='1303566241']
Thats what I've mentioned...but again I might be wrong

[CODE]
/****** Object: DatabaseRole [db_accessadmin] ******/
EXEC dbo.sp_addrole @rolename = N'db_accessadmin', @ownername = N'dbo'
/****** Object: DatabaseRole [db_backupoperator] ******/
EXEC dbo.sp_addrole @rolename = N'db_backupoperator', @ownername = N'dbo'
/****** Object: DatabaseRole [db_datareader] ******/
EXEC dbo.sp_addrole @rolename = N'db_datareader', @ownername = N'dbo'
/****** Object: DatabaseRole [db_datawriter] ******/
EXEC dbo.sp_addrole @rolename = N'db_datawriter', @ownername = N'dbo'
/****** Object: DatabaseRole [db_ddladmin] ******/
EXEC dbo.sp_addrole @rolename = N'db_ddladmin', @ownername = N'dbo'
/****** Object: DatabaseRole [db_denydatareader] ******/
EXEC dbo.sp_addrole @rolename = N'db_denydatareader', @ownername = N'dbo'
/****** Object: DatabaseRole [db_denydatawriter] ******/
EXEC dbo.sp_addrole @rolename = N'db_denydatawriter', @ownername = N'dbo'

/****** Object: DatabaseRole [db_owner] ******/
EXEC dbo.sp_addrole @rolename = N'db_owner', @ownername = N'dbo'

/****** Object: DatabaseRole [db_securityadmin] ******/
EXEC dbo.sp_addrole @rolename = N'db_securityadmin', @ownername = N'dbo'
[/CODE]
[/quote] will try ... Ty

Link to comment
Share on other sites
kumargadu Jr Artist

kumargadu

Posted
Posted

[quote name='innovative' timestamp='1365449945' post='1303566224']
requirement clear ga cheppu javascript iythe rasipedtha .. :P
[/quote]

SQL lo Javascript a ? H&T@ _*hiDe &*B@

Link to comment
Share on other sites
kumargadu Jr Artist

kumargadu

Posted
Posted

[quote name='Doolanagi' timestamp='1365450391' post='1303566269']
Hi everyone SQL BI developer here
[/quote]

welcome bud where are you working ?

Link to comment
Share on other sites
deals2buy Celebrity

deals2buy

Posted
Posted

[quote name='kumargadu' timestamp='1365450502' post='1303566279']

SQL lo Javascript a ? H&T@ _*hiDe &*B@
[/quote][img]http://lh3.ggpht.com/--o7mXz3u-j4/T9VVBGzBJAI/AAAAAAAAGo0/kmj8a1-XW2g/s150/PK-1.gif[/img]

[quote name='Doolanagi' timestamp='1365450391' post='1303566269']
Hi everyone SQL BI developer here
[/quote]welcome to the league mama :D

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