MS SQL Forums and Questions Answers

Display

questions sorted by

Topic

Asked By

Replies

Last Reply

Query to get all duplicate records from SQL Table.

3/13/2013 2:12:23 PM

Inayat

3/14/2013 2:49:39 PM

Jal

Best method to compare elements in a string with DB fields before insertion

3/11/2013 11:28:57 AM

Iram

3/12/2013 12:35:47 PM

Muhammad Umair

A connection was successfully established with the server, error occurred during pre-login handshake

7/27/2012 2:47:21 PM

Iram

8/3/2012 3:13:32 PM

Saad

Event to delete expired data from DataBase Table.

7/4/2012 3:20:00 PM

Iram

7/7/2012 2:58:28 PM

Mehmood

Can a Store procedure call itself or any recursive store procedure?

6/30/2012 12:59:46 PM

Iram

7/2/2012 11:03:59 PM

Mehmood

What are multi-query operators and Why we use them in SQL?

6/30/2012 12:45:59 PM

Iram

7/1/2012 11:36:46 PM

Mehmood

How to delete all data from all tables in the database?

6/28/2012 11:56:04 AM

Iram

6/29/2012 12:35:38 AM

Mehmood

Convert DateTime to Date(MDY) in Sql Server 2008

6/20/2012 4:33:44 PM

Iram

6/29/2012 12:26:05 PM

Iram

Cannot alter a table object in Sql Server 2008.

5/16/2012 2:14:30 PM

Iram

5/17/2012 10:32:07 PM

Mehmood

Why SQL Server is showing Login failed for user error while connecting?

4/25/2012 2:59:56 PM

Iram

5/12/2012 3:27:10 AM

Mehmood

Parse Error message

4/3/2012 10:59:21 AM

Iram

Why we use integrity Constraints in SQL?

3/30/2012 5:36:15 PM

Iram

What is BCNF?

3/30/2012 5:33:26 PM

Iram

what are Anomalies in SQL data?

3/30/2012 4:50:49 PM

Iram

What is difference between database table and view?

3/30/2012 4:45:19 PM

Iram

Why we use SqlCommand.CommandTimeout Property?

3/28/2012 5:07:17 PM

Iram

In SQL can we inherit from Sqlconnection class?

3/28/2012 5:01:52 PM

Iram

What is SQL injection attack?

3/28/2012 4:56:59 PM

Iram

What is the use of COUNT() function in SQL?

3/24/2012 1:50:31 PM

Iram

What is the function of triggers in SQL?

3/20/2012 6:14:40 PM

Iram

What are Joins in MS SQL?

3/20/2012 3:29:42 PM

Iram

MS SQL - Concepts and capabilities of SQL Server

12/29/2011 10:56:17 AM

Genious

12/30/2011 10:52:15 AM

Fazal

MS SQL - What is Analysis Services and its Features and concepts in Sql Server

12/29/2011 10:55:00 AM

Genious

12/30/2011 10:50:35 AM

Fazal

MS SQL - What is bit datatype in Sql Server

12/29/2011 10:53:11 AM

Genious

12/30/2011 10:49:37 AM

Fazal

MS SQL - What is SQL service broker in Sql Server

12/29/2011 10:52:07 AM

Genious

12/30/2011 10:48:04 AM

Fazal

MS SQL - What is Analysis service repository in SQL Server

12/27/2011 11:46:23 AM

Fazal

12/29/2011 10:48:19 AM

Genious

MS SQL - What is a linked server in SQL Server

12/27/2011 11:39:52 AM

Fazal

12/29/2011 10:47:36 AM

Genious

MS SQL - How to determine the service pack currently installed on SQL Server

12/27/2011 11:38:16 AM

Fazal

12/29/2011 10:46:32 AM

Genious

MS SQL - What is blocking and how would troubleshoot it in Sql Server

12/27/2011 11:37:01 AM

Fazal

12/29/2011 10:43:11 AM

Genious

MS SQL - What should we do to copy the tables, schema and views from one SQL Server to another

12/19/2011 11:06:57 AM

Fazal

12/20/2011 11:04:37 AM

Genious

MS SQL - What is BulkCopy and why we use it in Sql Server

12/19/2011 11:05:37 AM

Fazal

12/20/2011 11:03:38 AM

Genious

MS SQL - If master db has no backup what actions we should take if rebuilt the database

12/19/2011 11:02:45 AM

Fazal

12/20/2011 11:02:55 AM

Genious

MS SQL - If SQL Server crashed and we are rebuilding the db including master db what proc we follow

12/19/2011 10:59:28 AM

Fazal

12/20/2011 11:01:56 AM

Genious

MS SQL - What is log shipping in Sql Server

12/19/2011 10:55:53 AM

Fazal

12/20/2011 11:00:27 AM

Genious

MS SQL - Where we can store the users names and passwords in sql server

12/19/2011 10:53:23 AM

Fazal

12/20/2011 10:58:43 AM

Genious

MS SQL - What are the authentication modes in SQL Server

12/16/2011 11:01:54 AM

Fazal

12/17/2011 12:07:11 PM

Genious

MS SQL - If due to network or Security issues client is not able to connect to server or vice versa

12/16/2011 11:00:27 AM

Fazal

12/17/2011 12:05:14 PM

Genious

MS SQL - How we can troubleshoot SQL Server if it’s running very slow

12/16/2011 10:56:28 AM

Fazal

12/17/2011 12:02:32 PM

Genious

MS SQL - What is the role of each service that the SQL Server installation adds

12/16/2011 10:53:38 AM

Fazal

12/17/2011 12:00:56 PM

Genious

Ms SQL - What are the OS services that the SQL Server installation adds

12/15/2011 10:50:22 AM

Fazal

12/16/2011 10:31:35 AM

Genious

MS SQL - Can we link only other SQL Servers or any database servers such as Oracle

12/15/2011 10:48:03 AM

Fazal

12/16/2011 10:31:00 AM

Genious

MS SQL - What is a Linked Server and why we use it in Sql Server

12/15/2011 10:45:20 AM

Fazal

12/16/2011 10:30:20 AM

Genious

MS SQL - What is SQL Profiler and when use it in Sql Server

12/15/2011 10:43:18 AM

Fazal

12/16/2011 10:29:44 AM

Genious

MS SQL - Types of Joins that we can have with Sql Server

12/14/2011 11:15:10 AM

Fazal

12/15/2011 10:37:27 AM

Genious

MS SQL - What is a Join in SQL Server

12/14/2011 11:09:18 AM

Fazal

12/15/2011 10:36:41 AM

Genious

MS SQL - What is COLLATION in sql server database

12/14/2011 11:06:55 AM

Fazal

12/15/2011 10:32:56 AM

Genious

MS SQL - Difference between HAVING CLAUSE and WHERE CLAUSE in Sql Server

12/14/2011 10:50:33 AM

Fazal

12/15/2011 10:28:13 AM

Genious

MS SQL - What command we can use to rename a database in ms sql server

12/13/2011 11:24:00 AM

Fazal

12/14/2011 10:44:23 AM

Genious

MS SQL - Database consistency check command options in SQL Server

12/13/2011 11:22:07 AM

Fazal

12/14/2011 10:43:37 AM

Genious

MS SQL - What is the use of Database consistency check commands in SQL Server

12/13/2011 11:19:58 AM

Fazal

12/14/2011 10:38:25 AM

Genious

MS SQL - Can we use Truncate command on a table which is referenced by FOREIGN KEY in SQL Server

12/13/2011 11:17:29 AM

Fazal

12/14/2011 10:37:06 AM

Genious

MS SQL - Difference between DELETE & TRUNCATE commands

12/12/2011 12:00:38 PM

Genious

12/13/2011 11:13:26 AM

Fazal

MS SQL - How i can change the default port

12/12/2011 11:58:41 AM

Genious

12/13/2011 11:12:36 AM

Fazal

MS SQL - Which TCP/IP port does SQL Server run on

12/12/2011 11:57:17 AM

Genious

12/13/2011 11:11:20 AM

Fazal

MS SQL - When we use the UPDATE_STATISTICS command

12/12/2011 11:55:36 AM

Genious

12/13/2011 11:10:31 AM

Fazal

MS SQL - What are cursors

12/10/2011 11:51:19 AM

Fazal

12/12/2011 4:14:55 PM

Naeema

MS SQL - What is the basic difference between clustered and a non-clustered index

12/10/2011 11:50:14 AM

Fazal

12/12/2011 11:49:13 AM

Genious

MS SQL - What are the types of indexes available with SQL Server

12/10/2011 11:49:17 AM

Fazal

12/12/2011 11:48:02 AM

Genious

MS SQL - What is an Index

12/10/2011 11:48:19 AM

Fazal

12/12/2011 11:47:27 AM

Genious

MS SQL - What is a view

12/9/2011 10:55:53 AM

Fazal

12/10/2011 11:46:42 AM

Genious

MS SQL - What is a triggers

12/9/2011 10:54:35 AM

Fazal

12/10/2011 11:45:11 AM

Genious

MS SQL - What is a Stored Procedures

12/9/2011 10:53:32 AM

Fazal

12/10/2011 11:44:19 AM

Genious

MS SQL - What is normalization

12/9/2011 10:52:14 AM

Fazal

3/20/2012 5:01:18 PM

Iram

What’s the data provider name to connect to SQL Server database?

11/29/2011 12:53:54 PM

Genious

11/30/2011 11:31:16 AM

Fazal

What does the parameter Initial Catalog define inside Connection String?

11/29/2011 12:44:14 PM

Genious

11/30/2011 11:30:20 AM

Fazal

Why would we use untrusted verification?

11/29/2011 12:42:48 PM

Genious

11/30/2011 11:29:47 AM

Fazal

Which one is trusted and which one is untrusted?

11/29/2011 12:21:41 PM

Genious

11/30/2011 11:28:01 AM

Fazal

What is a pre-requisite for connection pooling?

11/26/2011 11:16:35 AM

Fazal

11/29/2011 12:14:29 PM

Genious

What is ACID rule of thumb for transactions?

11/26/2011 11:13:28 AM

Fazal

11/29/2011 12:10:28 PM

Genious

What connections does Microsoft SQL Server support?

11/26/2011 11:10:47 AM

Fazal

11/29/2011 12:05:55 PM

Genious

What is the wildcard character in SQL?

11/26/2011 11:08:15 AM

Fazal

11/29/2011 12:04:18 PM

Genious

Get Time from datetime Column of MS Sql 2008?

7/2/2011 1:35:11 PM

M Zunair

3/20/2012 5:53:46 PM

Iram

How can i shrink my database Files in MS SQL 2008?

6/18/2011 12:43:31 PM

Salman

6/19/2011 2:58:24 PM

M Zunair

MS SQL Forums and Questions Answers

Home

Our Websites

Our Products

Policy