probably a join algorithim issue might be fixed using a query hint. but without looking at the execution plan its impossible to say. also how big is the dbo.OwnershipRoleDiscipline...

do you mean you are trying to attach the mdf file ?

here is a video explaining how to create package configuration file.

https://www.youtube.com/watch?v=Ap5Mc6lS_PI

I think the Op is measuring the dimensions of a building and are probably not interested in anything beyond 2 decimal places. I wonder if people will ever truly...

this should get you started

http://blogs.msdn.com/b/repltalk/archive/2011/02/08/what-does-high-wait-in-sos-scheduler-yield-mean.aspx

Why not store only the 5 min intervals and then use GROUP by ROLLUP syntax to find the higher levels as needed.

Fire the DBA , esp since his job is not to accidentally delete / drop the database. Its the one thing he needs to do.

Test environment can be easily rebuilt...

declare @num1 decimal(4,2) = 12.56

declare @num2 decimal(4,2) = 96.54

declare @num3 decimal(4,2)

declare @num4 decimal(4,2)

declare @num5 decimal(4,2)

select @num3= @num1 + @num2

select @num4=@num1 * @num2

select @num5=@num2 / @num1

select @num3 , @num4 , @num5

GO

declare...

With Agile , Continuous Build and DevOps now , DACPAC has a very important role to play. Inf act it is considered one of the best ways to move databases...

There are a number of factors fill factor etc as mentioned before , ghost records could also be a factor. Also what kind of autogrowth settings does the database...

Just wanted to pint out a very detailed explaination on BCHR and why it is misunderstood as a memory pressure counter.

https://www.simple-talk.com/sql/database-administration/great-sql-server-debates-buffer-cache-hit-ratio/

In this case I feel the root cause is adhoc...

Sorry I misread the OPs question here is the updated script as Chris mentioned

create table #t1

( id int identity(1,1) ,

city varchar(128)

)

create table #t2

( id int identity(1,1),

city varchar(128)

)

insert into #t1

select...

change it to your account , the username and password you use to login and it should work

before you try SSIS you might want to explore the import export wizard in SSMS since this is a one time job.

You could also use Openrowset

http://www.ashishblog.com/importexport-excel-xlsx-or-xls-file-into-sql-server/

https://www.youtube.com/watch?v=FMZR94hW5xc

If the disk is already added to the server it should reflect under disk management in the MMC snap in. In which case it will be available as a cluster...