what is package and it uses and how can u call a package851
What meant by Performance Tuning,how can we do the performance tuning on stored procedures and tell some steps to do the performance tuning
how to find the particular row in table?(means suppose one table contain 10 rows , in these 10 rows how to find the particular row(example in 10 rows i want 5 row how)?15 13945
About Indexed Views? with example? plz reply...2 5856
What is indexed views? plz explain with example?2 2323
What is Covering Indexes? Plz explain with example3 6487
what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?831
what is Archive old data?1 1708
could you please reply for these question: 1.About Use Apply? 2.Avoid cursors - When we have a situation that we can not avoid the use of cursor than what is the alternate solution? is there anything we can use instead of cursor to perform the desired task? which optiomize the peroformance too. 3.What is computed columns? Thanks in advance. Regards, Rupesh3 3041
What is RMS migrations?
Scalability, Availability, Integration with internet, etc.)?
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?
how to do partition in sqlserver
wat wil hapn if we give the both read and deny read permission to user?
whats new about truncate in sql server 2008?
How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?
how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A
This question asked during interview, 2) At the end of each month, a new table is created for each bank that contains monthly metrics consolidated at the account level. The table naming convention is bankX_YYYYMM where X represents the numeric designation of the bank and YYYYMM indicates the 4 digit year and 2 digit month. The tables contain the following fields: name data type description account text account number registered boolean indicates whether the account is registered num_trans integer number of transactions made during the time period spend numeric(9,2) total spend during the time period a) Write a SQL query that will display the total number of transactions and total spend for "Bank1" during the 4th quarter of 2009. b) Write a SQL query that will display the total number of transactions and total spend at "Bank1" and "Bank2", broken out by registered vs. non-registered accounts, during January 2010 not sure what is correct answer and how to solve?
Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.
Any one plz send me SQL Server Developer/DBA resume for 4 years experience
ow to bring suspect mode datbase online from scratch
how many no of arguments can be passed in procedures and functions
SQL Server Architecture ?