Email: Password:       Forgot Password 
    .netCodeSG
A Saarsha Group Online Community for dot net codes group like C#, Asp.NET, VB.NET, Sharepoint, JavaScript, JQuery, Ajax, SQL, WCF, WPF.
 
TECHNOLOGIES:
Help Board:: By Technology
LEFT OUTER JOIN to a MIN/MAX row
Answer: 0  |  Posted On: 24/12/2014 20:02:59  |  Posted By: Rahul Saxena  |  Viewed: 2068
Types of Views in SQL Server ?
Answer: 1  |  Posted On: 16/12/2014 08:57:46  |  Posted By: Rahul Saxena  |  Viewed: 2008
Can Foreign Key be null ?
Answer: 1  |  Posted On: 23/08/2014 03:39:40  |  Posted By: Kashish  |  Viewed: 1016
Difference between Delete and Truncate
Answer: 2  |  Posted On: 28/02/2014 15:02:42  |  Posted By: Rahul Saxena  |  Viewed: 1540
Delete Duplicate Rows In SQL
Answer: 3  |  Posted On: 28/02/2014 14:58:49  |  Posted By: Rahul Saxena  |  Viewed: 1378
What is the purpose of using SET ANSI NULLS ON?
Answer: 1  |  Posted On: 24/09/2013 09:30:12  |  Posted By: Rahul  |  Viewed: 1314
How would you handle error in SQL SERVER 2008?
Answer: 1  |  Posted On: 30/07/2013 11:48:51  |  Posted By: varun  |  Viewed: 1382
What is use of EXCEPT Clause?
Answer: 1  |  Posted On: 30/07/2013 11:47:53  |  Posted By: Rahul  |  Viewed: 1218
What is Isolation Levels?
Answer: 1  |  Posted On: 30/07/2013 11:47:16  |  Posted By: Rahul  |  Viewed: 1210
What are synonyms?
Answer: 1  |  Posted On: 30/07/2013 11:46:29  |  Posted By: Rahul  |  Viewed: 1258
What are the Advantages of using CTE?
Answer: 1  |  Posted On: 30/07/2013 11:44:59  |  Posted By: Rahul  |  Viewed: 1256
Which are new data types introduced in SQL SERVER 2008?
Answer: 1  |  Posted On: 30/07/2013 11:44:20  |  Posted By: Rahul  |  Viewed: 1472
What is Filtered Index?
Answer: 1  |  Posted On: 30/07/2013 11:43:26  |  Posted By: sachin  |  Viewed: 1216
What is CTE?
Answer: 1  |  Posted On: 30/07/2013 11:41:51  |  Posted By: sachin  |  Viewed: 1354
What are Sparse Columns?
Answer: 1  |  Posted On: 30/07/2013 11:40:44  |  Posted By: Sara  |  Viewed: 1358
What is Replication and Database Mirroring?
Answer: 1  |  Posted On: 30/07/2013 11:40:17  |  Posted By: Sara  |  Viewed: 1232
What is Service Broker?
Answer: 1  |  Posted On: 30/07/2013 11:39:40  |  Posted By: Sara  |  Viewed: 1162
What are the basic functions for master, msdb, model, tempdb and resource databases?
Answer: 1  |  Posted On: 30/07/2013 11:37:36  |  Posted By: Rahul  |  Viewed: 1214
What is Trigger? What is its use?
Answer: 1  |  Posted On: 25/02/2013 12:27:59  |  Posted By: Rahul  |  Viewed: 1244
What is isolation level?
Answer: 1  |  Posted On: 25/02/2013 12:25:51  |  Posted By: Rahul  |  Viewed: 1670
What are Magic tables in SQL Server?
Answer: 1  |  Posted On: 25/02/2013 12:23:15  |  Posted By: Rahul  |  Viewed: 1248
What are the recovery models for a database?
Answer: 1  |  Posted On: 25/02/2013 12:17:56  |  Posted By: Sara  |  Viewed: 1280
What is the difference between a Delete and Truncate?
Answer: 1  |  Posted On: 25/02/2013 12:16:11  |  Posted By: Sara  |  Viewed: 1256
How many columns can be created in a single table?
Answer: 1  |  Posted On: 25/02/2013 12:15:10  |  Posted By: Sara  |  Viewed: 1246
How many Clustered and Non-Clustered Indexes can be created on a single table?
Answer: 1  |  Posted On: 25/02/2013 12:13:44  |  Posted By: Sara  |  Viewed: 1222
What is the difference between Clustered and Non-Clustered Index?
Answer: 1  |  Posted On: 25/02/2013 12:09:47  |  Posted By: Sara  |  Viewed: 1248
What are the different constraints in SQL Server?
Answer: 1  |  Posted On: 25/02/2013 12:07:19  |  Posted By: Sara  |  Viewed: 1246
Write a SELECT statement without FROM Clause?
Answer: 1  |  Posted On: 25/02/2013 12:05:20  |  Posted By: Sara  |  Viewed: 1468
What is a CTE?
Answer: 1  |  Posted On: 25/02/2013 12:04:39  |  Posted By: Sara  |  Viewed: 1278
New Features of SQL Server 2008 Management Studio
Answer: 1  |  Posted On: 25/02/2013 11:43:07  |  Posted By: Rahul  |  Viewed: 1216
What are the basic functions for master, msdb, model, tempdb and resource databases?
Answer: 1  |  Posted On: 25/02/2013 11:37:50  |  Posted By: Rahul  |  Viewed: 1214
Difference between LINQ and Stored Procedures
Answer: 1  |  Posted On: 23/02/2013 06:14:39  |  Posted By: Rahul  |  Viewed: 1314
Common Table Expressions
Answer: 1  |  Posted On: 23/02/2013 06:10:25  |  Posted By: Rahul  |  Viewed: 1354
Explain Cursor in SQL Server 2008?
Answer: 4  |  Posted On: 29/10/2012 07:15:10  |  Posted By: deepak  |  Viewed: 1364
Difference between union and union all in SQL Server 2008?
Answer: 1  |  Posted On: 29/10/2012 07:12:54  |  Posted By: deepak  |  Viewed: 1268
Primary Key Constraint in Sql Server ..?
Answer: 1  |  Posted On: 29/10/2012 07:09:35  |  Posted By: deepak  |  Viewed: 1230
How to generate GUID In sql Server..?
Answer: 1  |  Posted On: 29/10/2012 07:06:51  |  Posted By: deepak  |  Viewed: 1254
How will retrieve the 2nd highest salary from a table...
Answer: 1  |  Posted On: 05/09/2012 23:20:11  |  Posted By: naman  |  Viewed: 1344
How can you improve SQL Query performance...
Answer: 1  |  Posted On: 03/09/2012 20:20:49  |  Posted By: Rahul  |  Viewed: 1460
SQL LIKE Operator...
Answer: 2  |  Posted On: 20/08/2012 23:42:41  |  Posted By: Ayush  |  Viewed: 2048
What is the Difference between a HAVING clause and a WHERE clause?
Answer: 1  |  Posted On: 15/08/2012 00:27:58  |  Posted By: Rahul  |  Viewed: 1362
What are Pessimistic Lock and Optimistic Lock?
Answer: 1  |  Posted On: 15/08/2012 00:27:14  |  Posted By: sonam  |  Viewed: 1348
What is an SQL Server Agent?
Answer: 1  |  Posted On: 15/08/2012 00:26:39  |  Posted By: sonam  |  Viewed: 1528
What is the difference between UNION and UNION ALL?
Answer: 1  |  Posted On: 15/08/2012 00:25:56  |  Posted By: sonam  |  Viewed: 1356
What is CHECK Constraint?
Answer: 1  |  Posted On: 15/08/2012 00:25:25  |  Posted By: sonam  |  Viewed: 1544
What are Different Types of Locks?
Answer: 1  |  Posted On: 15/08/2012 00:24:36  |  Posted By: sonam  |  Viewed: 1342
What is Dirty Read?
Answer: 1  |  Posted On: 14/08/2012 23:51:01  |  Posted By: sonam  |  Viewed: 1340
What is the Correct Order of the Logical Query Processing Phases?
Answer: 1  |  Posted On: 14/08/2012 23:50:24  |  Posted By: sonam  |  Viewed: 1534
What do you mean by Identity in SQL Server?
Answer: 1  |  Posted On: 14/08/2012 23:28:12  |  Posted By: Ayush  |  Viewed: 1332
Explain Primary Keys and Foreign Keys?
Answer: 1  |  Posted On: 14/08/2012 23:27:17  |  Posted By: Ayush  |  Viewed: 1478
Explain JOIN...
Answer: 1  |  Posted On: 14/08/2012 23:26:40  |  Posted By: Ayush  |  Viewed: 1474
What is subquery?
Answer: 1  |  Posted On: 14/08/2012 23:26:10  |  Posted By: Ayush  |  Viewed: 1536
What is the Difference between a Function and a Stored Procedure?
Answer: 1  |  Posted On: 14/08/2012 23:25:46  |  Posted By: Ayush  |  Viewed: 1340
What is a Cursor?
Answer: 1  |  Posted On: 14/08/2012 23:24:58  |  Posted By: Ayush  |  Viewed: 1524
What is a Linked Server?
Answer: 1  |  Posted On: 14/08/2012 23:24:35  |  Posted By: Ayush  |  Viewed: 1422
What is an Index?
Answer: 1  |  Posted On: 14/08/2012 23:24:08  |  Posted By: Ayush  |  Viewed: 1440
What are the Different Types of Triggers?
Answer: 1  |  Posted On: 14/08/2012 23:00:15  |  Posted By: Ayush  |  Viewed: 1434
What is a Trigger?
Answer: 1  |  Posted On: 14/08/2012 22:59:33  |  Posted By: Ayush  |  Viewed: 1375
What is a Stored Procedure?
Answer: 1  |  Posted On: 14/08/2012 22:58:10  |  Posted By: Ayush  |  Viewed: 1340
What is Normalization?
Answer: 0  |  Posted On: 14/08/2012 22:57:37  |  Posted By: Rahul  |  Viewed: 1296
How we can get the full information about a table...
Answer: 2  |  Posted On: 14/08/2012 22:45:11  |  Posted By: Rahul  |  Viewed: 1342
How we can monitor SQL Server performance?
Answer: 0  |  Posted On: 14/08/2012 22:43:23  |  Posted By: Rahul  |  Viewed: 1346
ow do I get a list of SQL Server tables and their row counts?
Answer: 2  |  Posted On: 14/08/2012 22:41:33  |  Posted By: Rahul  |  Viewed: 1340
Which TCP/IP port does SQL Server run on?
Answer: 1  |  Posted On: 19/07/2012 13:13:33  |  Posted By: Rahul  |  Viewed: 1352
MOST VIEWED QUESTION:
 
         HOME   |   Submit Article   |   Contact Us   |   About Us   |   Terms & Condition   |   Advertise With us