If there is failure during updation of certain rows, what will be the state?2 8191
What is the difference between Userdefined function and stored procedure? Explain and give the example also5 6167
how to dispaly a particular row details from a given table2 3648
What is a transaction and what are ACID properties?3 4623
Explain different isolation levels?4 7271
What's the maximum size of a row?4 7418
Explain Active/Active and Active/Passive cluster configurations?1 2920
What is lock escalation?1 5213
What's the difference between DELETE TABLE and TRUNCATE TABLE commands?9 12481
Explain the storage models of OLAP?1 5182
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?1083
What are constraints? Explain different types of constraints?26 115340
Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?2 7583
what operator performs pattern matching?2 8310
What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?
what is the Ticketing tool used in Wipro technologies at Bangalore...???
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
If the job running very slow what is the action you do
hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.
What is the query optimization statistics?
How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
Why we need to use secondry database file? though, we can do same work using primary database file also.
If user is owning any SQL Objects, can we drop that user
Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
How do you Implement SSIS Packages in your Project?
how many no of arguments can be passed in procedures and functions
What are the dis_advantages of stored procedures, triggers, indexes?
Does any body please help me what question's have asked for SSRS in the interview?