The files are open by SQL server.

If you want to move these, as well as other files, you will need to stop the SQL Server service on your...

Ed Wagner (9/23/2016)

---

Michael L John (9/22/2016)

---

I've stocked up on suits of armor.

I'm installing 2016 on the new dev box, and as part of it, removed the functionality that takes the...

I've stocked up on suits of armor.

I'm installing 2016 on the new dev box, and as part of it, removed the functionality that takes the last full production backup of...

Ok, do these jobs that...

ysrhashmi (9/21/2016)

---

Hi ,

Thanks for your reply.

SAN replication would be taken care by Storage admin.

From sql server DBA perspective, need to know my tasks in this scenario.

I am assuming below points:

1)...

Good, because this is a frequent error that I see.

2016-09-30 15:39:50.197 would be an...

It also appears that you may have a logic error in your code:

WHERE

CONVERT(varchar(20), H.TransactionDate, 101) >= @StartDate

AND CONVERT(varchar(20), H.TransactionDate, 101) <= @EndDate

If the H.TransactionDate field...

Concat null yields null.

One of the variables you are concatenating is null. So, you get nothing.

Add some print statements after you initialize each variable, and see what is...

Just did it on our production systems. A rouge process blew up the log file on a database. We shrunk the primary, and the secondaries also shrunk.

How about this?

http://www.sqlservercentral.com/articles/Restore+Genie/145380/

I've seen it. The work around is to script the changes, or, resize the window.

And it's already been reported:

https://connect.microsoft.com/SQLServer/Feedback/Details/3102793

Powershell does not have to be installed on each server.

I'm guessing that you can connect to each server from a central location and run a powershell script.

Try...

Does this help?

SELECT

servicename,

service_account

FROM sys.dm_server_services

tshad (9/8/2016)

---

Depending on the logic, you might want to have multiple tables.

Just having a unique id to have one is not normally useful. What does it signify. In...

rash3554 (9/7/2016)

---

Hi there,

I have a table with 100 million records containing Employee information without a Unique key.

Create Table Employee

(

EmpName varchar(100);

EmpAddress1 varchar(max);

EmpAddress2 varchar(1000);

EmpAddress2 varchar(500);

EmpCity varchar(100);

EmpState varchar(50);

)

I...