djj (9/1/2016)

---

Sean Lange (9/1/2016)

---

Odd...I can't find it....

Can't help when I can't follow what you are saying. Are you saying that a database created in the default instance on ServerA is visible and accessible in one...

And his forced vacation from SSC did nothing to motivate White Horse from his berating ways. Who let him back in?

drew.allen (9/1/2016)

---

First, the mantra is "It's a bad idea to declare a cursor. Period. End of sentence." 😀

T-SQL is not C#. It's certainly easy enough to test.

DECLARE @i INT...

Brandie Tarvin (9/1/2016)

---

Took a look at local weather over lunch time and immediately saw:

83° Mostly Cloudy

feels like 90°

H 84° / L 77°...

I can't tell you what is happening when creating a clustered index on a heap, or what is happening when it rolls back. What I can tell you, and...

Jeff Moden (9/1/2016)

---

Looks good, Gail.

Just...

SQL Galaxy (9/1/2016)

---

while fetching data through Linked server column data not display full qualified rows.

Source server: Property vendor database, this database data can't visible normally and viewing thru ODBC query...

spaghettidba (9/1/2016)

---

PLE is a counter that represents the number of seconds a data page is expected to live in the buffer cache before it is evicted to make room for...

Greg Edwards-268690 (9/1/2016)

---

Part of the...

Indianrock (8/30/2016)

---

Erland's article may not be current. In discussing TVP's and the ability to use them with Entity Framework, one of our developer's pointed out the article below. ...

I don't think that word means what you think it means.

I had to deal with it at a previous employer where I implemented database mirroring. I used event notifications to handle the fixing of the SID in the databases...

manie (8/29/2016)

---

I am not against the ORM approach completely and I must say the first...

Sean Perkins (8/29/2016)

---

Lynn Pettis (8/29/2016)

---

First, to clarify, you say this only happens on the mirrored instances of SQL Server, not the stand alone instances.

When you get these errors, has there...