any idea guys? Struggling with this one

1. My understanding of the licencing is that Microsoft supplies 1x additional replica for free. If my client wants to save money, then adding an extra replica for reporting isnt...

It seems to be working, i have failed it over a few times between different data centers using OLEDB with multisubnetfailover=true without issues.....

I think the article i read is bullsh1t

Appreciate the feedback guys - cheers

Thanks for the reply.

Whats the benefit of using the listener and port to connect rather than cluster name and port or instance name if the instance names are the same...

I would completely disagree with the approach to...

Hi,

We dont do this frequently no I know its not good practise but this is a one off to recover space after a big delete.

DBCC checkdb..

for this particular table...

DBCC results...

Hello,

Just a shrink command..

DBCC SHRINKFILE (N'DATABASE' , 100621)

GO

I just ran a checkDB on the database and no errors popped up so corruption shouldnt be an issue

Cheers Grant, do you definitely lose an hour with the agent with the clock goes forward?

So between 1am and 2am is lost?

agreed - but if there is a different way to do it it would rather do it without SA

Hello!

its not someone else its a service account.

I basically have a process which connects to all of our SQL Servers, queries various aspects such as security info, vlf counts, instance...

flg_attendance is bit

status_ID is int

Just answered my own question on the avg_user_impact column, that's a %.

if someone could clarify if avg_total_user_cost is MS then that would be great.

just dont use Select * is my advice.. its lazy and causes issues in multiple ways

Thanks for the reply.

I want to avoid having to have any external elements to the process.

This SSIS Package will be connecting to 30+ SQL instances and it would require temporary...