drew.allen (7/22/2011)

---

Eric M Russell (7/21/2011)

---

SQL_By_Chance (7/21/2011)

---

Assuming that changing the data is not an viable option, then I suggest you try modifying the SQL like below, doing a left outer join(s),...

In my experience, a large table is...

IRK (7/19/2011)

---

Hi ,

I prepared same query in following 3 ways

1) using NOT IN

2) using LEFT JOIN WITH NULL

3) using NOT EXISTS

then the Query cost is same i.e., 33%,33%,33%

at last...

SQL_By_Chance (7/21/2011)

---

Hi All,

Thanks a lot for your thought. As, I can't change the schema. I think the most suitable suggestion that worked for me is the Update and then indexing...

Raphra (7/18/2011)

---

I altered a stored procedure and unknowingly overwrote some changes that were made to it by another developer. Is there a way to undo the changes and get the...

Here is a script I wrote up a while back. It uses impersonation and the has_perms_by_name() function to test access permissions for a specific account against each database object. If...

Rather than jumping through all the hoops of impersonating a SYSADMIN, you could just grant the login(s) VIEW SERVER STATE permission.

http://msdn.microsoft.com/en-us/library/ms186717.aspx

I don't know about your SharePoint environment, but where I work we use it mostly for publishing documents, typically MS Office or PDF documents. One thing to keep in mind...

Freddie-304292 (7/21/2011)

---

I think encrypting the data on a laptop is putting a sticking plaster on the real problem. So much of our data is held in the cloud now,...

Not knowing anything specific about managing SharePoint portal applications or databases,...

The skillset for database development and administration, specifically SQL, tends to hold it's value longer relative to other IT skills like web or mobile device development. New features like analytical...

spadavala82 (7/18/2011)

---

...

The Results in this Table are:-

id name1name2

1 1,2,3

2 2,3,4

3 4,5 ...

Steve Jones - SSC Editor (7/20/2011)

---

I'd tend...

Rod at work (7/20/2011)

---

I appreciate this article, Steve, as it's something I have faced for the last 3 years. No training, no conferences, etc. However, in my situation it...

When it comes to technology training, I've always trained myself. I attend monthly user group meetings and local day events, and I earned my certifications by studying exam prep books...