My understanding of an instance is that it acts as if it is another server without actually needing to buy another server. Thus I assume all the permissions/checkpoints you normally...

I tried querying using your suggestion on a couple of instances on one of our machines. I was not successful. Maybe I am missing something.

I have a similar report that runs on a schedule. Before I even published it I created to new datasets, one for the start time and one for the end...

In case you haven't , my recommendation is to learn on BOL about ISOLATION. Then also look at the indexes and tune those.

One benefit of instances is that when you create a linked server connection to a database in another instance (of the same machine) then data does not have to travel...

If you created the SSIS package under a Windows account then you can create a Proxy object to run the job under. The way I understand it a proxy treats...

You can then create a view as a UNION ALL of the those two tables and use that for simplicity.

SELECT * , 1 as 'party' FROM myproducts

union all

SELECT...

Hi and thanks for your replies --

Accounts is a table, thus there are no calculations occurring.

I will post any news I have for I am working away on isolating the...

I did something like the following

set rowcount 0

Select id,

case when datecolumn1 is null then 2 else isdate(datecolumn1) end as c1, /*isdate returns 1 when true and 0 when false*/

case...

Hi Kal -- I'm not the original author of this thread. I am just issuing my own grievances with the same message the author gets. All of our date columns...

I should be a bit more clear:

I can query all the date fields in the record mentioned (id 509416). They show up as a date or as NULL. But the...

I run select * from accounts where id = 509416 and the SSMS just hangs there executing the query - even stopping doesn't help, I have...

We get this error when we select * on one of our records in one table (using like where id = 12345). I can see all the dates and nulls...

I agree with Paul. Just look up the SUBSTRING function.

I experienced this problem after I installed a service pack. I opened the "configure report service" application on the server machine. In report manager virtual directory settings I checked the...