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

Restoration
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

Timeout for latch :class ACCESS_METHODS_SCAN_RANGE_GENERATOR
  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






 

Follow

Get Free SQL Tips

Twitter

LinkedIn

Google+

Facebook

Pinterest

RSS

Learning

DBAs

Developers

BI Professionals

Careers

Q and A

Today's Tip

Resources

Tutorials

Webcasts

Whitepapers

Tools

Search

Tip Categories

Search By TipID

Authors

Community

First Timer?

Pictures

Contribute

Events

User Groups

Author of the Year

More Info

Join

About

Copyright

Privacy

Disclaimer

Feedback

Advertise

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