JoshDBGuy (7/29/2015)

---

Igor Micev (7/29/2015)

---

JoshDBGuy (7/29/2015)

---

Igor Micev (7/29/2015)

---

Hi All,

Thanks for replying.

Issue is resolved.

The ssd disk has been going working worse and worse. Its response time has been changing in the last...

JoshDBGuy (7/29/2015)

---

Igor Micev (7/29/2015)

---

Hi All,

Thanks for replying.

Issue is resolved.

The ssd disk has been going working worse and worse. Its response time has been changing in the last couple of weeks...

Exactly that. I later saw that...

Hi All,

Thanks for replying.

Issue is resolved.

The ssd disk has been going working worse and worse. Its response time has been changing in the last couple of weeks having increments.

Today...

I did all...

sqlfriends (7/24/2015)

---

Anyone installs multiple instances on a SQL server either virtual or physical?

All my company's SQL server currently only have single default instance.

I know we can install named instance besides...

Try with this code in the WHERE clause

where

(up.UserId = @UserId or up.UserId = @SenderId)

and

up.IsProfilePic = 1

and

...

SimonH (7/6/2015)

---

Igor,

I've not used delete on cascade.

Looking into it this might work.

I was under the impression this only worked if you had joins in your delete statement.

Would I add this...

SimonH (7/6/2015)

---

Igor Micev (7/6/2015)

---

Is the table's PK a foreign key in other tables. Are some foreign keys using the CASCADE-ing?

What about triggers?

You can always perform the deletion in batches, let's...

Is the table's PK a foreign key in other tables. Are some foreign keys using the CASCADE-ing?

What about triggers?

You can always perform the deletion in batches, let's say each batch...

Good discovery. Thanks.

Did you check the iSCSI initiator for the disks? Once we had to re-initiate in order to continue.

Nice question. Good to know the difference in modes for JSON and XML.

This is first QotD touching SQL 2016.

Great question! Thanks.

SELECT

d.referenced_entity_name,

o.type_desc,

object_schema_name(d.referencing_id) As ReferencingSchema,

object_name(d.referencing_id) AS ReferencingObject

FROM sys.sql_expression_dependencies d

INNER JOIN sys.objects o ON d.referenced_id=o.object_id

LEFT OUTER JOIN sys.columns colz ON o.object_id = colz.object_id

...