Jack Corbett (11/24/2015)

---

Yes that is how it should work. The first row is inserted successfully because it won't violate the PK and the next row with the...

I'm with Jack on this one. A duplicate to me is where all column values are equal, if you mean duplicate key fields... then the issue is which is the...

You can have your main query in the form of ::

SELECT /* your columns */

FROMyour table

WHEREdateField>= @startDate and dateField < @endDate

Set startDate ,@endDate default to the value of...

Inside of the SSRS development environment you can create a data set that has this information, that is, the calendar months that Jeff Mentioned. You want that table/dataset to...

I've seen this issue when the report itself dumps tons of possible values for the parameter. Can the values be grouped somehow and chosen through a cascading relationship between the...

The purpose of a shared/common data source is that when you need to redirect to a new database, you only need to change the configuration at one place rather than...

Even if it is a valid user at the database, do you have the select permission on the objects that you need or are you calling a stored procedure that...

You need to make sure that the credential configured at the data connection is valid for the database you are getting on your new server. Is this a SQL login...

Also for safe measure, make sure you do not have the file open or the package in an open BIDS window locking it at the same time. Likely though, as...

Our storage admin has begun with disk performance monitoring. As I do not want to throw this over the fence, I would still like to check any and...

PHXHoward (11/30/2015)

---

I get it that they look the same but I did not know that SQL Server was smart enough to use an NCI on a computed column that is...

Try to get the actual query plan attached here. A couple of people have mentioned that before, plus your table definitions. That will go further in helping us to help...

It looks like that Left Join is essentially an inner join... you are filtering the results back down AFTER you are first putting together the bigger recordset. Make this

tbl_documents...

So you are able to change the index on the table and not a query? If you knew for a fact that changing the query will not break anything else...

siugoalie78 (11/25/2015)

---

I am not sure if this is the exact same issue, but I was getting the same error. In my organization, every time there is a schema change we...