SQL Server Interview Questions

List of SQL Server Interview Questions. To get the answers of these SQL Server Interview Questions. click here.

1. What is trigger?
2. What is Clustered & Non-Clustered Index?
3. How many types of triggers are there?
4. What is constraints?
5. What is the difference between Truncate and Delete?
6. What Primary key and Unique key?
7. How to join two tables in Sql Server?
8. How do you implement one-to-one, one-to-many and many-to-many relationships while designing tables?
9. What's the difference between a primary key and a unique key?
10. What's the difference between DELETE TABLE and TRUNCATE TABLE commands?
11. What is a transaction and what are ACID properties?
12. What's the maximum size of a row?
13. Difference Between Implict Transaction And Explict Transaction
14. what is the diff between a HAVING CLAUSE and a WHERE CLAUSE?
15. How to change Database name in SQL Server?
16. Difference between Primary key Constraint and Unique key Constraint in SQL Server.
17. What is cursor in SQL Server?
18. What is #temp table and @table variable in SQL Server?
19. How to return XML in SQL Server?
20. What is OPENXML in SQL Server?
21. What is the use of COALESCE in SQL Server?
22. What are joins in SQL Server?
23. which Caluse returns only one copy of each set of duplicate rows selected
24. What are the types of triggers and how the sequence of firing in text item?
25. What is the difference between DELETE and TRUNCATE?
26. Some more differences related to Truncate and Delete
27. An automatic commit ocurrs under the following circumstances
28. What are the properties of the Relational tables?
29. How do you optimize stored procedures in SQL Server 2005
30. What is DESCRIBE command in SQL Server 2005? What is its purpose? How to use it?
31. What is the Maximum number of input and output parameters in Stored procedure in SQL Server 2000 ?
32. What are the limits of Sql Server 2000?
33. How you can get the last identity value inserted in any table ?
34. What is the maximum size of an SQL Server 2000 Database?
35. how many database can be created on MSSQL Server 2000
36. What are the extensions of these three type of file in above question.
37. how you can rename a database ?
38. What is the use of @@TRANCOUNT in SQL Server?
39. What is the maximum limit for Primary Key?
40. What is a Stored Procedure?
41. What is an Index?
42. What command do we use to rename a db?
43. What do you mean by COLLATION?
44. What are the OS services that the SQL Server installation adds?
45. What is log shipping?
46. Where do you think the users names and passwords will be stored in sql server?
47. What is a deadlock?
48. what is ACID?
49. What Is DTS?
50. What is Log Shipping?
51. What are sequence diagrams? What you will get out of this sequence diagrams?
52. What is a tuple?
53. What is the purpose of UPDATE STATISTICS?
54. What is RAID and what are different types of RAID configurations?
55. What are three SQL keywords used to change or set someone’s permissions?
56. What is DTC?
57. How to get GUID in sql server?
58. What is Check Constraint?
59. Can we create a Foreign Key with out Primary Key?
60. Difference between varchar and char:
61. What is blocking in SQL Server?
62. What is the use of bit data type and what kind of data is stored into it?
63. What is user-defined data type in SQL Server?
64. What is user-defined functions in SQL Server?
65. What is the use of Keyword WITH ENCRYPTION keyword in SQL Server?
66. What is Distributed Queries in SQL Server?
67. What is Subquery in SQL Server?
68. What are the restrictions of using Subquery in SQL Server?
69. How many database(s) can have in an instance of SQL Server 2005 ?
70. A fill factor of 0% and 100% means the same thing to SQL Server
71. Root Cause for Increasing the Transaction Log.
72. Default security model in Microsoft SQL Server ?
73. Microsoft SQL Server's default protocol ?
74. What is Two-Phase Commit ?
75. What is Database snapshot ?
76. What is Deferred transaction ?
77. What is Dirty pages ?
78. What is DRI ?
79. What is ETL ?
80. What is Fragmentation ?
81. What is Lock escalation ?
82. What is noise word ?
83. What is point-in-time recovery ?
84. What is Query binding ?
85. What is Roll forward ?
86. What is write-ahead log ?
87. How do you Copy Databases to SQL SERVER 2005 from various versions (6.0/6.5/7.0/2000) ?
88. Number of PRIMARY KEY/FOREIGN KEY Constraints in a Table in SQL Server 2005/2008 ?
89. What is 'Self-referencing' tables in SQL Server ?
90. To modify a DEFAULT definition, We must first DELETE the existing DEFAULT definition and then Re-CREATE it with the new definition.
91. DEFAULT definitions cannot be created on columns defined with the following DATA TYPE ?
92. What is Typed vs. Untyped XML in SQL Server ? Explain with an example
93. What id the Max Length of nVarchar in SQL Server?
94. What is the Max length of varchar variable in SQL Server?
95. How to Get SQL Server Version ?
96. What are the disadvantages/limitation of the cursor?
97. Use of Bulk Copying ?
98. The maximum number of columns a table can have in SQL Server?
99. What’s the difference between a primary key and a unique key?
100. Can UNIQUE KEY in SQL Server 2005 have two or more NULL?
101. What is the page size in SQL Server?
102. Will COUNT(column) include columns with null values in its count?
103. How can we Rollback the Transaction in DataBase?
104. How Can we Write the Transaction Block in SQL Server?
105. Difference Between Truncate Table and Delete Table Command in SQL Server?
106. Which is the best method to get the single value from Database?
107. Unique Key is smilar to Priamary Key,except it
108. What will be the output of the following code?
     
     Declare @Strings VARCHAR(20)
     
     Select @Strings ='Lakhan Pal Garg'
     
     Select SUBSTRING(@Strings,-9,16
109. Which type of datatype is used to store IO Streams in Sql Server?
110. Which Statement describe the COALESCE ?
111. A table can have maximum of 1024 partitions.
112. What is 'NEXT USED' in SQL Server ?
113. How do you determine the maximum nested-level of Stored Procedure ?
114. Which Function is used to count more than two billion rows in a table?
115. Which of the following is a fixed length DataType?
116. SQL Server allows for only _____ levels of nesting in CASE expressions.
117. Is it possible to create Cluster Index on Unique Key Column?
118. You cannot create an Index on a column of the following data type
119. All indexes will automatically get deleted(dropped) if the table is deleted?
120. How to get a row was inserted most recently in a table?
121. How to Get nth Record in a Table?
122. What is Row_Number()?
123. What is the difference between a Local and a Global temporary table?
124. How to get @@ERROR and @@ROWCOUNT at the same time?
125. What is a table called, if it has no Cluster Index?
126. What command do we use to rename a db, a table and a column?
127. Can we use Truncate command on a table which is referenced by FOREIGN KEY?
128. Can we use NEWID(), or RAND() in function?
129. Can we use "Print" statement in function?
130. Which of the following queries generates an error when executed?
     
     DECLARE @x VARCHAR(10), @y VARCHAR(10)
     
     SET @y = ''
     
     SELECT @x/0 -- query 1
     
     SELECT @x/2 -- query 2
     
     SELECT @y/0 -- query 3
     
     SELECT @y/2 -- query 4
131. What type of language is the SELECT command in SQL Server?
132. Is There any other Methods in SQL Server 2005 to Read XML Data?
133. Name the method used in SQL Server to Read XML Data?
134. How we can Modify XMl Data in SQL Server 2005?
135. How to Insert XML Data into Existing XML Node?
136. How we can generate Random number in SQL Server?
137. How we can get the List of System Tables in DataBase?
138. How we can get the list of user tables?
139. How We can Get List of Store Procedures?
140. How We Can Get List of Scalar Functions?
141. Query to Get List of Table Valued Functions?
142. How we can Get List of Triggers?
143. Query To Get The Column Name,DataType, And Length of columns in a Tables?
144. Query to Select n Rendom Records From a Table in the Database?
145. Query to Get List of Views?
146. Query to display List of All Databases in SQL Server 2005/2008?
147. How to get values of identitycolumn when you are not sure about the column name which is identity column?
148. What is the name of store procedure to send Email using SQL Server 2005/2008?
149. I need to Add one column in a existing table and the max value of the column can be 10, which data type i need to use for that?
150. How we can add Description to the Column using Sql Command?
151. How To Update Description Value for a Column in Table using SQL Command?
152. How To Delete Description Value for a Column in Table using SQL Command?
153. How To Get Description Value for all Column in Table using SQL Command?
154. How To Get Description Value for Single Column in Table using SQL Command?
155. How we can Create a .SQL File for the Store Procedure in SQL Server 2005?
156. How We can get the DB name using SQL Command?
157. What is the use of Set NOCOUNT ON;?
158. What is the system table that holds the Store Procedure Script?
159. How we can implement Row lock explicitly in SQL Server?
160. What is the name of the table from which we can get the Locking information in SQL Server?
161. Can we use shared lock with Update Statement?
162. What is the name of the System table from where we can read the Master Files (.mdf, .ldf) Path?
163. Name of the table that contains the Configuration value of SQL Server ?
164. What is the Name of table that contains available data type in SQL Server?
165. What is the use of WAITFOR in SQL SERVER ?
166. What is the name of the Store procedure to get the listing of current users?
167. Maximum number of parameters you can pass in a Store procedure in SQL Server 2005?
168. Are DDL Triggers available with SQL Server 2005 ?
169. How to pass table name as stored procedure parameter in SQL Server 2005 (Write stored procedure) ?
170. What is referential integrity in SQL Server ?
171. What maximum size of row is allowed in SQL Server ?
172. Write a SQL Statement to Get the Definition of the System Store Procedures?
173. Write a Query in SQL Server to get the Parameter list of given Store Procedure.
174. Which system procedure is used to find out lock details about the databases, it's table and procedures.
175. Which system table holds the details of all the processes running on the Microsoft sql server?
176. How can we find the open transactions details in sql server?
177. What is the name of command in sql server 2005 which is used to kill any process?
178. Name of the command to view the current amount of free (unallocated) space in the database in SQL Server?
179. What is the command name to shrink the data file and log file size in SQL server 2005?
180. What are magic tables?
181. What is difference between RANK and DENSE_RANK.
182. What will you do if you need to create clustered index on more than one field? Is it possible?
183. Can you control concatenation of string values with null values? How ?
184. This is used to terminate a query when an overflow or divide-by-zero error occurs during query execution…
185. SET NOCOUNT specified settings are in effect at…
186. SET OFFSETS specified settings are in effect at…
187. To terminate SQL Server immediately, used is…
188. Return type of RAND() is...
189. Write and justify output of - select nullif('test','test')
190. How to get date of 234 days back in SQL?
191. What is SIGN() ?
192. SQL_VARIEANT datatype column can be any datatype except?
193. Which of the following is a Large object Binary Data Type?
194. Which of the following is a Large object data type?
195. INNER JOIN cannot be used without the
196. select COUNT(column_name) from table_name counts only
197. Which of the following is a Aggreate Function?
198. What will be the OutPut of the following Query?
     
     Select CELING(7.69) as number
199. How you will create a UNIQUE Constraint when the table is already created?
200. what is CHECK Constraint?
201. Write query with which you can achieve paging from SQL side.
202. How can you insert multiple rows together in a single insert statement for a table?
203. Tell name of the system procedure to create and drop linked server in SQL SERVER?
204. How will you delete all records of table other then recently added 10 records?
205. How can you declare and initialize variables in a single line with SQL Server ?
206. Which are the five types of SQL table objects?
207. What is XQuery?
208. What is sp_XML_Preparedocument procedure?
209. What is sp_XML_RemoveDocument procedure?
210. What is FOR XML clause in SQL?
211. In which table, SQL SERVER stores the user name and password used for connection?
212. Does Views occupy memory?
213. Clustered Index vs NonClustered Index.
214. What is Index?
215. Difference between DELETE and TRUNCATE commands ?
216. What is the difference between a HAVING CLAUSE and a WHERE CLAUSE ?
217. What is COMMIT and ROLLBACK statement in SQL
218. What are the different types of Locks
219. What is the difference between UNION ALL Statement and UNION
220. How to get number of Maximum connection can be establish to SQL
221. What is a Join in SQL Server?
222. What is the Magic Tables in Sqlserver2000?
223. What is the use of COALESCE function in SQL Server ?
224. What type of Authentication does Microsoft SQL Server support?
225. What is the difference between "dynamic SQL" and "stored procedure" ?
226. How to determine the service pack currently installed on SQL Server?
227. More than one IDENTITY column per table can be exist in SQL Server . (True /False)
228. Is “FOR” available with SQL ?
229. What is Wildcard character in SQL Server ?
230. What are the major new features in SQL Server 2008 ?
231. I have a table with 10 columns. I need to display name column as textfield and Id column as value field in the drop down.
     
     
     
     Write the best possible query to get the records.
232. What is the use of COALESCE function in SQL Server ?
233. How do you Change Stylesheet Dynamically using Javascript?
234. I need to automate some works in SQL Server depending on the time. How can you do this
235. Tell me some system defined procedures
236. How do we list all Databases in a server using query?
237. How do we List all table names?
238. How do we list all column names of a table?
239. What are the steps to create a stored procedure?
240. What is ASCII method?
241. How do we convert money to character?
242. How do we find the duplicate records of a table?
243. How do we find the last date of current month?
244. What is a table variable in T-SQL?
245. Tell me the difference between temporary table and table variable?
     
     Which is better?
246. Write a sample syntax of table variable?
247. How to execute the stored procedure?
248. What is the use of Dense_Rank in Sqlserver?
249. How to rename a database in SQLserver?
250. How do we Unlock Particular User in Sql Server
251. What is the purpose of DATENAME fucntion?
252. What is BCP?
253. What is DTS?
254. Which one is faster? BCP or DTS?
255. Which has more provisions for the export/import functionality? Whether we can customize the data through BCP?
256. How do we get Current Months First Day?
257. What is compute in sql server?
258. What is a COMPUTE BY statement?
259. What is the use of @@CONNECTIONS statement?
260. What is the use of @@CPU_BUSY statement?
261. What is the use of @@LANGID?
262. What is the use of @@VERSION statement?
263. What is the purpose of @@SERVERNAME statement in T-SQL?
264. What is the purpose of @@FETCH_STATUS statement in T-SQL?
265. What is Modulo EQUALS statement in SQL server?
266. What is the use of @@ROWCOUNT?
267. What is the maximum number rows can be returned in SqlServer by the @@ROWCOUNT?
268. If the rows are more than 2 billion, how can I set the rowcount?
269. How do we handle errors in SQL Server?
270. How do we raise the error message?
271. Can we have Try catch in Sqlserver?
272. What is the syntax of try catch?
273. How can we cancel a transaction?
274. What is the purpose of @@LANGUAGE statement?
275. What is the use of @@IDLE in Transact-SQL?
276. What is Replication and Database Mirroring?
277. What is OLTP (Online Transaction Processing)?
278. When is the use of UPDATE_STATISTICS command?
279. What is SQL Profiler?
280. What is Log Shipping?
281. How to get @@ERROR and @@ROWCOUNT at the same time?
282. Can SQL Servers linked to other servers like Oracle?
283. What is BCP? When does it used?
284. What are sp_configure commands and set commands?
285. How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
286. What is an execution plan? When would you use it? How would you view the execution plan?
287. What is ACID ??
288. How can u pick random records from SQL table ?
289. Efficiency comparison of EXISTS and IN
290. Can you compare two SQL fields with datatype "text" by using equal "=" operator
291. What are the three levels of data abstraction?
292. What is the output of the following query?
     
     SELECT TRUNC(1234.5678,­2) FROM DUAL;
293. What is the error in the following command?
     
     DROP TABLE &TABLE_NAME;
294. What is the use of DATEDIFF function in SQL?
295. What is the use of DATEPART function in SQL?
296. Which function is used to find the largest integer less than or equal to a specific value?
297. What is the use of DESC in SQL?
298. Which option is used to drop constraints specified on the table?
299. MONTHS_BETWEEN date function is used for what purpose?
300. Which command is used to create a table by copying the structure of another table?
301. What is the difference between TRUNCATE and DELETE commands?
302. What are the privileges that can be granted on a table by a user to others?
303. !=, <>, ^= all denote the same operation. It is True of False
304. What are the wildcards used for pattern matching?
305. Which command displays the SQL command in the SQL buffer, and then executes it?
306. Which system table contains information on constraints on all the tables created?
307. Which command executes the contents of a specified file?
308. Which operator performs pattern matching?
309. Is SQL case sensitive?
310. What command is used to get back the privileges offered by the GRANT command?
311. What is the default language of SSIS Script Task?
312. How many maximum Clustered indexes on a table ??
313. Is primary key Clustered or Non - Clustered Index in MS SQL
314. What is fixed-length & variable-length characters? Tell me their differences??
315. What is Powershell ?
316. What is SqlBulkCopy in ADO.NET?
317. How do you map a column in SqlBulkCopy?
318. What is a cube?
319. What is the full form of KPI?
320. In Analysis service what is the technology used define the expressions?
321. How To know your SQL Server Version in SQL command prompt ?
322. What is the use of xml datatype in SQL Server?
323. What is the maximum size of data we can store in the image type of SQL?
324. What is the difference between .rdl and .rdlc report.
325. Can we create DTS Package in DTS package in SQL Server 2005 or higher version?
326. What is SSIS
327. Can we write Scripting Language like VB Script and JavaScript in SSIS Package?
328. Name of the containers in SSIS?
329. Can we use Oracle Database as source or destination Database in SSIS?
330. Adding months to a Date in SQL ??
331. Adding minutes to a date ??
332. Adding year to a date ??
333. How to get the month value/month part from the given Date?
334. How to get the Day part from the given Date?
335. How to get the year part from the given Date?
336. How to get the number of quarter from given date?
337. Which function is used to convert the integer value into spaces?
338. Which function performs the opposite function of CEILING function in SQL Server?
339. Why FLOOR function is used?
340. Which function is used to know the database name by giving the database ID?
341. How to know the ID of a database?
342. Which function is used to perform a full text search on a column?
343. Which function is used to know the current active user within the host Operating System?
344. What is the use of MOD function?
345. Name the full-text predicates in SQL server
346. Name the ROW-Valued-Functions in Full Text Search
347. What are the various transaction isolation levels ?
348. What are the variuos lock types ?
349. How can we check the locks defined in a DB ?
350. Which function is used to know the database property in SQL Server.
351. What is the use of CHAR function?
352. What is the use of APP_NAME()?
353. Can we create Web service in SQL Server 2005?
354. will the increase in the size of viewstate will affect the performance of the page?
355. What is the page size of Index Page ?
356. Name the table where the Index information is saved
357. Which Editor we can use to create the SSIS Packages?
358. How we can check the database permission for any user?
359. How we can deploy SSIS?
360. What the value of Identity_Insert to be set for letting the insertion in the identity column ?
361. Can we have option to use configuration file in dts package?
362. Can we use Configuration file in SSIS Packages?
363. Name of the task that is used to execute batch file in SSIS package?
364. Which Task in SSIS is used to perform operation on a file or directory?
365. What is the result of "SELECT 2/2/4" in SQL ?
366. Difference between Table Variable (@tbl) and temporary table (#temp or ##temp
     
     )
367. Can we execute "BCP" command directly in the SQL Server Management studio?
368. Can we restore the database forcefully when it is in use via SQL script?
369. Is it possible to find out .mdf and .ldf file name from the backup(.bak) file? If yes, then how?
370. Select * from table1,table2
371. How we can specify the first day of the week?
372. How to get the value of first day of the week?
373. What is Tabular Value Function ?
374. What is two-phase commit?
375. How many Evaluation Modes are there in "SQL Server 2008 - Policy Based Management" ? Which mode is manual ?
376. What is the Product code (Internal Code) for "SQL Server 2005", "SQL Server 2008" and "SQL Server 2008 R2" ?
377. What is the difference between Host_Name() and ServerProperty('MachineName') Functions ?
378. How will you Enable / Disable Resource Governor Using T-SQL in SQL Server 2008 ?
379. What is the use of "SET NOCOUNT ON;" in SQL Server?
380. How will you calculate maximum range of "INT" Data Type ?
381. When will you go for SQL Server Authentication instead of Windows Authentication ?
382. When will SQL Server throw an Error: "MSSQLSERVER ERROR 576" ?
383. What is Instance-aware and Instance-unaware Services in SQL Server ?
384. What is the difference between following two statements ?
     
     1. SELECT 'DotnetFunda' 'SQL Server'
     
     
     
     2. SELECT 'DotnetFunda' = 'SQL Server'
385. What is "Locking" concept in DBMS?
386. What is a "dead lock"?
387. What is "Functional Dependency"?
388. Difference between Database Migration and Upgradation ?
389. How will you validate whether the linked server properly configured / not ?
390. SQL Server connection is terminated after the query completes. Why ?
391. What is constant folding ?
392. What is Forced Service ?
393. Which objects can not be specified "FORCESEEK" table hint from the following list ?
394. A Foreign Key constraint can be defined to reference the columns of Non Primary key column ?
395. What is Self-referencing table ?
396. Can a FOREIGN KEY constraint reference the column in tables in the different database ?
397. How to identify the "Full-Text search Installed or Not" on your current instance of SQL Server ?
398. What are the key points to be followed when implementing Full-Text Search on View ?
399. How to Enable / Disable the Full-Text Index created on a View / Table ?
400. What is Delegation in SQL Server ?
401. What is "Double Hop" in SQL Server ?
402. How to respond to a Full Transaction Log Error in SQL Server ?
403. Maximum How many Row(s) will be there in Sys.Indexes view for Each table in SQL Server 2008/2008 R2 ?
404. What does the Group By clause mean when used in databases?
405. What do these keywords mean with respect to Sql Server?
     
     a) @@Identity
     
     b) @@Rowcount
     
     c) @@Error
406. What is Stored Procedure? What is the advantage of these?
407. What is error handling in stored procedures of SQL Server 2008?
408. Describe how you can optimize stored procedures in SQL Server?
409. Describe what is trigger in SQL Server?
410. How can you describe RDBMS?
411. I could not see the Maintenance Plans when I login into my LoginID, But its showing in some other LoginId, Why ?
412. How to run Maintenence Plan using script ?
413. How to execute a SQL Job using script ?
414. How to identify the SQL Server Start/Restart Date & Time ?
415. How to identify the Total/Available/Used Physical Memory in database server using script ?
416. Which SQL Server Profiler event enables to trace the users involved in Deadlock cycle ?
417. How do you install SQL Server to take advantage of Microsoft Server Clustering ?
418. What are the various options to move the data/databases ?
419. What are the restrictions apply to compressed backups ?
420. How to enable compressed backup ?
421. What are the performance counters used to monitor the Backup I/O performance ?
422. What is Network model?
423. Explain about the hierarchical model of database?
424. Explain what is object oriented databases?
425. Explain about XML databases?
426. Write disadvantage of File Processing System and what are the advantages of Database over File Processing System?
427. Define Rollback and Rollforward?
428. Define Concurrency and Concurrency control? Explain what are the different techniques?
429. What is a Database Transaction?
430. What is the difference between a Database Administrator and a Data Administrator?
431. What is difference between SUBSTR and INSTR in the SQL?
432. What is the difference between =, == and ===?
433. What is a VIEW in Sql Server?
434. How the SELECT statement parsed/executed by the SQL Server engine ?
435. What is the purpose of Model database ?
436. Can we work on both (After) and (InsteadOf) Triggers in SQL on a single table?
437. How will you create a DML Trigger?
438. Difference between Backup Dump and Backup Device ?
439. To identify the Expiration date of database backup file
440. What is the exact use of PIVOT in sql server ?
441. What do you meant by an UnPivot element in sql server?
442. Limitations of using AWE Memory in SQL Server
443. Difference between PAD_Index and FillFactor ?
444. What are the Advantages of using SQL Triggers ?
445. What are the Disadvantages of using SQL Triggers ?
446. What is UNIQUE KEY constraint
447. What are cross joins?
448. What is a view?
449. What are the index combination's a table can have?
450. What is an index?
451. How the indexing is getting worked?
452. Difference between VARCHAR and NVARCHAR
453. What is normalization?
454. What is the maximum number of parameters SQL Stored procedure can have?
455. Difference between "RID" and "KEY" lock(s) in SQL Server
456. Which recovery model is required for a replication in SQL Server ?
457. What are the advantages of using Stored procedure
458. Difference between char and varchar data types in Sql Server?
459. Difference between Triggers and Stored procedures
460. Whiach of these statements is not supported in Dynamic cursors?
461. Can we reset the identity column?
462. What are derived Tables?
463. Which of these statements cannot be written inside the block
     
     
     
     Begin tran
     
     
     
     Commit Tran
464. What is set_quoted_identifier?
465. Difference between Identity column and Primary Key?
466. What are the different authentications in sql server
467. What are computed Columns?
468. Difference between count(*), count_big(*) and count(<some columnname>
469. Name the sql function that returns the sql object identification number?
470. Difference between HAVING and WHERE Clause
471. Difference Between Union and Union All
472. What are all the SQL Server JOBs involved in LogShipping - SQL Server
473. Can we use order by clause when defining a view?
474. What is the difference between Stored Procedure and Function?
475. Which of these must be there in the delete command?
476. How to insert a single row only in a table
477. Difference between local and global temporary tables:?
478. What are the steps you will take to improve performance of a poor performing query?
479. Can we use TOP with UPDATE and DELETE on partitioned views?
480. What are SQL SERVER INTEGRATION SERVCIES(SSIS) ?
481. How to find SQL SERVER SCRIPTING DUPLICATES ?
482. what is Schemabinding View.
483. How many Foreign key can i have in my MS sql table ?
484. How many tables can be used in a single SELECT statement ? Have you tested that ?
485. In MSSQL What is ISNULL() function? how do we use it?
486. For execution of DML statement in a view, view need to contain ?
487. sql statement which returns all columns of table with no row(assuming that table has more than 3000 row).
488. What does this return ?
     
     declare @adress varchar = 'India'
     
     select @adress
489. What are Deterministic and Non deterministic Functions?
490. Can you set firing order in triggers and in instead of triggers?
491. Can we alter the flow of the execution in SQL Server ?
492. Reverse string with out using in build function
493. What is the purpose of "sp_resetstatus" system stored procedure ?
494. What are all the ways to connecting Locally on the Server ?
495. How to force the protocol(NamedPipe or TCP/IP) connection when connect locally on Server ?
496. In SQL Server, between Windows Authentication and SQL Server Authentication, which one is trusted and which one is untrusted?
497. Once we switched from SIMPLE Recovery model to FULL or BULK_LOGGED recovery model, what are all the recommendations ?
498. Difference between Composite , Candidate and alternate keys ?
499. Delete duplicate rows on table with/without primary key in Sql Server 2005
500. Which character is said to be WildCard Character in SQL ?
501. When we are transferring records from one database to another database so now if we use SqlBulkCopy class to transfer the records then which scenario we need to handle ?
502. What are CRUD operations in database?

To get the answers of these SQL Server Interview Questions. click here.