Small apart - being a MS CRM db replication is not supported by Microsoft - be careful with that. Having said it  I have implemented it myself with no major...

please post the actual explain plan of that query so we can have a look at it.

and DDL for both temp table and main table (including all indexes)

most common issues...

If you can get procmon from sysinternals suite https://docs.microsoft.com/en-us/sysinternals/downloads/sysinternals-suite%5D and within the server itself kick it off and monitor both SQL Server and SSMS and see if it gets a...

you can buy one !!!!! https://www.adverts.ie/vintage-classic/t-55-tank-for-sale-unarmed/221665

Good reply Brandie 🙂 I wish I had the communication skills for that.

I do see the point of adding an account to all instances - I would hope it is...

Is it my impression or we are getting more cases of "professionals" asking to be supplied with fully functional scripts to solve their issues and at the same time getting...

you were given 2 options - one easy and the other requiring you do do a tiny bit of code yourself - either option are useful even if not an...

this is called being lazy - this is a task that you would not be performing that often so just creating a sqlcmd execute query command line string on the...

following will work with sample data.

constraints:

PriorityOrder always starts at 1

PriorityOrder increments by exactly 1 (e.g. there are no gaps)

with operations
as (
select *
from (values 
 (cast(1 as int),...

In SQL Server 2005 Management Studio:

View Menu -> Summary (or F7)

In SQL Server 2008 Management Studio:

View Menu -> Object Explorer Details (or F7)

pretty useless though - as soon as you...

without the full sql you are doing on your package, and indeed the package itself I would guess you have a SQL Statement agains Oracle where you are concatenating various...

your issue is that you don't have a domain - as such you need to do a few extra steps to enable Windows authentication

https://dba.stackexchange.com/questions/39614/connect-to-sql-server-using-windows-authentication-from-another-pc-without-activ

main thing as per the post is...

https://visualstudio.microsoft.com/vs/compare/ - to compare the VS editions

for list of included software https://docs.microsoft.com/en-us/visualstudio/subscriptions/subscriber-downloads and more specifically the spreadsheet on the link above http://download.microsoft.com/download/1/5/4/15454442-CF17-47B9-A65D-DF84EF88511B/Visual_Studio_by_Subscription_Level.xlsx

As you are a freelancer you will most likely...

• This reply was modified 6 years, 3 months ago by frederico_fonseca.

and how many files you got on tempdb?

and can you go to CU7 just in case it fixes the issue?

on the link that Sue gave there is a set of instructions to debug it.

Also a set of details of steps that need to be done to ensure that the...