Learn more about SQL Server tools


SQL Server Question and Answers

Ask a SQL Server Question

Search All Questions:
SQL Server Questions And Answers
<< Previous Page        Next Page >>

Primary Key And Unique Key Requirement
1. If we are already having Primary Key why we need Unique Key? 2. Why we allow NULL to Unique Key? 3. Why Primary Key don't allow NULL?

asked 10/9/2014 12:15:14 PM
by Lokesh Shukla
3 answers

I need to truncate a first name in my SSRS 2008R report
The data in the software has first name and I want to truncate it to first initial only.  How would I go about doing that in SSRS 2008R?

asked 10/9/2014 10:01:58 AM
by Sheila Lindergren
1 answers

SQL server - Hot and Standby
Hi, We have a requirement of hosting a web application, backend SQl Server, in two physically separate server for redundancy and high availability requirment. We have installed the application and SQL server on two separate server (two licenses).  

asked 10/8/2014 8:52:54 AM
by Rasheed Abdul
2 answers

sql server
from "not exists" ,"left join" and "except" clause which is better and faster.... tell me with an example  

asked 10/8/2014 2:14:30 AM
by taj
0 answers

mssql server 2008 r2 creating a full backup from one server to another
I need to create a full backup weekly and a differential backup hourly from our production server to our failover server.  I have researched and can not find a detailed document on how to achieve this. I know how to create a full and differential bac

asked 10/7/2014 1:50:09 PM
by katty davis
2 answers

Full Text Catalog taking up all the disk space
We have created full text catalog and index for a pretty large table. The column on which the index is being created has a datatype of varchar(max). The problem started as soon as we started populating the catalog. It almost grew to 835GB and Population s

asked 10/7/2014 5:50:02 AM
by Saikat
1 answers

excel formula
Please I would like this excel formula to be translated into english so that I can be able to write similar in TSQl Language =BK3=IF(AND(OR(AND(AB4="Yes",AA4<>""),AB4="No"),OR(AND(AD4="Yes",AC4<>""),AD4="No"),OR(AND(AF4="Yes",AE4<>""),A

asked 10/6/2014 5:17:57 AM
by Chinedu
0 answers

Error "Invisible Datasource" : End Users are unable to connect to SSAS Cube from Excel on their PC
  I am connecting to analysis Services 2008R2 as a local host. I am the only one having analysis services install.   End Users are able to open Pivot Table on Excel 2013 from a cube I created on my PC, but when those End Users , I included

asked 10/5/2014 6:08:01 PM
by Ann
0 answers

Create Procedure to Keep Track of Last Changed Data
I have two tables: Member with Username,Password and LogMember with Username,Password,dateEdited. So can you help me create procedure with insert Member and when is updated to store the old data in LogMember and the new updated in Member.

asked 10/5/2014 11:46:20 AM
by John
0 answers

Having Trouble with use of CHAR(13) in select
I have this script and it will script all ddl server triggers to its own file. The problem is that in the script generated, I need to put some line breaks. I use CHAR(13), but it does not work. Can someone help please? Thanks in advance: declare @filena

asked 10/3/2014 1:20:56 PM
by Burhan
2 answers

SSRS, Maps, Drilldown, Pass Parameter has error
In main report, 2 parameters @StartDate and @EndDate, the map shows the count of transactions for each Province, in polygon property setting has Action, can drill down to another report. In Action, Pass ProvinceCode, @StartDate and @EndDate to drill

asked 10/3/2014 9:59:19 AM
by doupanpan
1 answers

sql server functions
in sql server ..declare @colName varchar(20)set @colName = 'oKaY'select upper(left(@colName, 1)) + substring(LOWER(@colName), 2, len(@colName)) --as @colNamethis is fine for only 1 word it provides output like ... Okaybut if we have more than 1 word like

asked 10/1/2014 3:33:19 AM
by taj
1 answers

SSRS Space(5) within Expression
I would like to use the Space(5) within an SSRS Expression: This works: =(Fields!WMFNO.Value) & "   |   " & (Fields!CourtDT.Value) & "   |   " & (Fields!L_D.Value)   But I would like to add the Space(5), within

asked 9/30/2014 12:56:19 PM
by JE Ramirez
1 answers

How to shrink the transaction log file in SQL Server
USE DBName;    ALTER DATABASE DBName SET RECOVERY SIMPLE; GO   CHECKPOINT;    DBCC SHRINKFILE (N'DBName_Log' , 2)   Result Cannot shrink log file 2 (smvmch_Log) because of minimum log space required. DbId   F

asked 9/30/2014 8:35:40 AM
by TamilSelvan
1 answers

stored procedure insert into table1 select from table2 query not inserting all the records into table1
i have a sql server 2000 stored procedure. The proceudure inserts the select statement result into different table. There were more than one such insert statement returned in this procedure. When I execute the stored procedure, it executes well. But,

asked 9/29/2014 10:14:34 PM
by Harikumar Srinivasan
0 answers

How to automate the process of Generating Scripts for Server Objects (DDL Triggers etc)
I am looking for a way to create a job that will create an .sql file on disk to store the scripts of all server objects (DDL Triggers etc). I need this so that I can use these scripts as backup and migrate all server objects if needed. Please help me. &

asked 9/29/2014 11:04:44 AM
by Burhan Uddin
6 answers

SSIS Package runs Under Package Execution Utility but not SqlServer Agent
Package is designed to open a remote share to a folder using Net Use as to folder is not in our domain. Package runs fine with utility but has the following errors when run from Agent.  If run as Sql Server agent- Executed as user: KERNPROBATION\sql

asked 9/25/2014 7:25:04 PM
by joe munch
2 answers

migration oracle to sql server 2008
i am migrating oracle database to sql server 2008 without using SSMA is there any doc or pdf for guideline

asked 9/25/2014 3:26:19 AM
by taj kazi
7 answers

How to optimize a stored procedure query containing views & joins to load data into a table(truncate & load).

asked 9/24/2014 1:08:19 PM
by Pravin
0 answers

SMS Text msg data Unreadable
Our company sends out sms text mesgs from our MSSQL Database and stores the responses in a table when a reply is received. My problem is now that some mesgs are showing as blank(even when I copy the raw data field out of the query return window) yet when

asked 9/24/2014 2:38:45 AM
by Enrique Mallon
1 answers

Sponsor Information