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 >>

Transpose Columns to Rows
I have my data (attached) in cloumns and I like to transpose them into rows. I tried Unipovt but since most of the fileds are dynamics and not fixed, I am having issues to set Unipivot dynamically. Here is current data in colums: create table #columnstor

asked 7/28/2015 8:07:34 PM
by helal
1 answers

Select - slow performing query
I have a query against a table with 31 million rows in it that is very slow performing.  I am including below the structure of the table and the query itself.  I have tried adding a non-clustered index with no benefit.  I am considering thi

asked 7/28/2015 3:51:44 PM
by Michael Cuccia
1 answers

How to enable Data Compression on Subscriber only?
Hi All, I have a transactional replication setup and i want to enable data compression(page or row) only on the subscriber side. I tried setting this up and it works fine until you reinitialize the subscriber. Everytime i reinitialize the subscription it

asked 7/26/2015 7:09:25 PM
by Sam
0 answers

AWS EC2 MS SQL server instance, not RDS - SQL Data Tools still missing.
Hello, I've read all your information on the limitations of an AWS RDS MS SQL server instance. I have installed an EC2 instance instead. I can now see folders in my SQL management console for reporting services and integrated servers etc but I don't se

asked 7/26/2015 4:17:07 PM
by Deborah
0 answers

When use function and when use store procedure. means in what scanerio i used fuction and store procedure..

asked 7/24/2015 5:40:32 AM
by sameer
0 answers

Error .. Cluster SQL Server and Kerberos
Hi , Im cannot installing a SQL Server instance  cause this error , could someone explain me about it . I really need to know something about this cause I try everything and didnt work .

asked 7/22/2015 9:06:14 PM
by alex84
0 answers

TRN file corrupted
Backup job for database threw error '64(The specified network name is no longer available.)' while attempting 'SetEndOfFile' on...' Tested BAK file restored with no problems.  DBCC CHECKDB  on restored BAK file reported no error

asked 7/22/2015 3:52:41 PM
by Elsie5000
0 answers

Log not truncating after multile log backups
Hello All, I have a log that will not truncate.  details about the database: 1. Database is in Full recovery 2. No replication or mirroring flags enabled 3. Database Never been backed up, but I did so before the log backups 4. Someone attempted

asked 7/21/2015 4:56:26 PM
by Elise5000
1 answers

How To Solve This in SQL SERVER 2008 R2
empnoenamesalary   1abhi10000.00    2balu20000.00    3chow40000.00    4dongi80000.00       i want output like empnoenamesalary 1abhi10000.00 2balu10000.00     3chow2000.00 4dongi40000.

asked 7/19/2015 4:25:08 AM
0 answers

How Many Records Load into Excel from OLEDB Source
I Have a table it has around 1,21,317 records are there while i am loading to excel it's loaded only 65683 records...how can i perform to load all records into excel.I am using SQL SERVER 2008R2.  

asked 7/17/2015 2:18:37 PM
4 answers

Hi, how to recover my TEMPDB DATABASE? My Tempdb Datafies drive is corrupted.   Thanks & Regards, Subhamay Chatterjee India

asked 7/17/2015 2:40:30 AM
by Subhamay
2 answers

Frozen table
Hello All, Used the import wizard to upload data from an Excel file.  Took the following steps:  1.      The import froze on a specific row. 2.      Cancelled the import due to ~2minute hang

asked 7/16/2015 6:46:33 PM
by Elise5000
4 answers

The value violated the integrity constraints for the column
We have SSIS jobs to import data from an upstream which would pass through stage tables, intermediate and then to final. In intermediate table we have NOT NULL constraint on a column. It never happened before and suddenly from upstream NULL values st

asked 7/16/2015 11:09:33 AM
by Harini
1 answers

mdx help
hello I am new in mdx and I need help I create a report using ssas as data source the problem is I that for one column when there are some specific data then I want to name it 'george' like in sql case when name in ( 'george', 'john') then 'first' &

asked 7/16/2015 6:36:06 AM
0 answers

Error during installation of an SQL server Failover Cluster Instance
Hi. I really need help . Im trying to install an SQL Server instance and I got  this error. I already check user and CNO permissions .. the CNO  had "Read all properties" and "Create Computer objects" . the user that create the instance is

asked 7/13/2015 9:31:27 PM
by alex84
1 answers

SSRS Reports Scheduling and exporting
I have 4 SSRS reports that must be scheduled to run at different times and then send these SSRS reports in csv format (tab delimited) to the ftp server of the third party client 

asked 7/11/2015 10:47:12 AM
by Kris Maly
0 answers

sql licences
  We have one SQL Proc Licence We have now purchased two new ibm servers. How much SQL licences we have to purchase  What is SQL CAL . do we require SQL CAL as 25 users are working on application running on one server. Which version of SQ

asked 7/11/2015 12:48:53 AM
by p k goel
1 answers

When you run SQL Queries on SSMS we monitor on SQL Profiler but when we run SSIS Packages is there any tool exits?
When you run SQL Queries on SSMS we monitor on SQL Profiler but when we run SSIS Packages is there any tool exits?

asked 7/10/2015 8:56:46 AM
by Kris Maly
3 answers

How to transfer XML files from folder to another folder with a new name change using SQL 2008.
Hi,   Hope someone could help me on this.   Problem: I have an SQL jobs that gets the XML file  from specific folder and transfer to database. However if that XML file will come in bulk. I'm thinking if how can I transfer all of that u

asked 7/9/2015 10:16:56 PM
by Jay Lorca
2 answers

How frequently are system tables in SQL updated
Hi   I recently came across a tip in which we can find the number of rows in a table from sysindexes aystem table. I want to know how frequently is it updated. Are all the system tables up to date all the time   Regards, Harini

asked 7/9/2015 7:41:33 AM
by Harini
2 answers

Sponsor Information



Get Free SQL Tips










BI Professionals


Q and A

Today's Tip







Tip Categories

Search By TipID



First Timer?


Free T-shirt



User Groups

Author of the Year

More Info








Copyright (c) 2006-2015 Edgewood Solutions, LLC All rights reserved
Some names and products listed are the registered trademarks of their respective owners.