Try tuning you indexes, NOLOCK is guaranteed to read uncommitted transactions but not necessarily guaranteed to improve performance.

Not sure of all the features of MySQL but it may have an import wizard that you would execute after you had your tables in place. Also don't forget to...

Just a note:

For every trigger defined on a table, SQL must run through the code of each to see what action, if any, is called for. Thus this may...

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