Learn more about SQL Server tools


Tutorials          DBA          Dev          BI          Career          Categories          Events          Whitepapers          Q&A List          Join

SQL Server Question and Answers

Ask a SQL Server Question

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

How does an SQL Program look like, for a client
Hello, I have a really stupid, yet important question to ask here. I am a Computer Sciences student, and having not learned anything about Database yet, I have a friend's father who wants me to make him a program to a database for his clients.He basicall

asked 8/17/2015 5:58:14 PM
by Patrick Y
1 answers

Table Design - monthly goals for multiple units
Hello, I need to store the monthly goals for 50+ business units by year. (UnitID, Year, Month, Goal)  These numbers should be static and new goals inserted yearly.  The data will be used in reports to display % to goal and other calculations. &

asked 8/17/2015 12:46:06 PM
by Darwin
1 answers

What are the possible errors found at the time of restoration of database.  

asked 8/16/2015 3:04:17 AM
by Jiten
1 answers

The operating system returned error 665(The requested operation could not be completed due to a file system limitation)
Got this error message on a ~500GBs database DBCC CHECKDB operation: Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be

asked 8/14/2015 12:36:42 PM
by Elise5000
0 answers

Schema, Pranet_object onwership, and child_object ownership
All, This is a project for a Security Class @ a California State University.  Resources VERY limited for help. Trying to gather SQL Server information across a network.  Specifically, what users own which schemas, which schemas conta

asked 8/13/2015 5:58:16 PM
by Elise5000
3 answers

Changes in parameter value on reports in BIDS are not reflected when deployed to website
I have numerous reports built in SSRS 2008 and I need to change the value in the parameters.   The changes done in Bids are saved and the reports run fine from Bids when the new values.   However, when I deploy those reports, the

asked 8/13/2015 3:31:20 PM
by Cindy Filler
0 answers

Object Ownership: Triggers
Apparently you can't change the owner of a trigger using ALTER AUTHORIZATION OBJECT::.  However, if the trigger is in an owned SCHEMA will changing the owner of the SCHEMA effectively change the owner of the trigger in the SCHEMA?  If so, then d

asked 8/13/2015 11:30:09 AM
by Elise5000
2 answers

Windows Server Cluster and SQL AlwaysOn Avaiabilty Group
Hello, i have a problem with my Windows Server 2012 R2 Cluster. I have two nodes of SQL Server 2012. SQL Server was Standalone and use AlwayOn Availability Groups. I Use a File Share Witnees as Quorum. Now when i reboot the Fileserver on which the Fil

asked 8/13/2015 9:50:00 AM
by Alex
0 answers

initial catalog name change as per db name in ssis configuration.
Dear all, in our ssis package migrartion package project. i have faced a problem. our previous version ssis package there are lot of connection manager and we are configed ssis package configuration at that time db name is like ABC_DEPLOY. but after move

asked 8/12/2015 2:04:20 AM
by Subhamay
0 answers

Correcting Server Connection in Maintenance Plans
In SQL 2008 R2, if we clone an environment including SQL server, the maintenance plans retain a connection string to the source/original server they got cloned from and are not editable.  But, I was able to use a work around by editing them in BIDS a

asked 8/11/2015 6:21:24 PM
by Neel
0 answers

Excel source file issue in SSIS
The SSIS is getting fail, The excel source file not having all mapped column, so it is failing to read excel file, I want if column is not present in excel then just keep null for that column. I tried to insert data without column header,but not succeed.

asked 8/6/2015 9:13:07 AM
by Mohit Yadav
0 answers

When i use function and when i use store procedure in sql server
When i use function and when i use store procedure in sql Server

asked 7/31/2015 1:46:59 AM
by sameer Patil
1 answers

Dynamic Stored Procedure work only on limmted number of records
This dynamic Sp works only where there are very few records and failes with 100+ lines of data. I can't firgure out why. Please help. Error Message when runnin g against data with 100+ records: "CategoryTimestampDurationMessageLinePosition Error7/30/201

asked 7/30/2015 6:28:08 PM
by helal
1 answers

stored procedure
dear all sql doctors, i had one stored procedure ...it has multiple coluns some of columns like start date, enddate, spped , distance , address. my need is the startdate & enddate are having records 12 am to 12 am, io need to change that to 2 am to

asked 7/30/2015 8:49:49 AM
by ys reddy
1 answers

  I see below messages in error log(screenshot below).Due to this the response time was very slow. And it caused timeout errors.As per my understanding,"ACCESS_METHODS_SCAN_RANGE_GENERATOR” indicates lot of concurrent parallel scans.Could you

asked 7/30/2015 6:42:12 AM
by ChaituKiran
1 answers

issues in Log shipping

asked 7/30/2015 1:31:53 AM
by siva sankhar
0 answers

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

Sponsor Information



Get Free SQL Tips










BI Professionals


Q and A

Today's Tip







Tip Categories

Search By TipID



First Timer?




User Groups

Author of the Year

More Info








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