The obvious requirements for a "SQL Server Developer" would be to know relational database concepts and how to write SQL. Start with a book on generic RDMS theory, data modeling,...

I suspect there is something in the other four databases that reference the CONFIG database. Trying running a SQL Profiler trace filtered on the database object CONFIG, and then have...

Reading email doesn't necessarily have to involve preemptive multi-tasking. The developer can read and reply as they come in, or he can just let them queue up for a couple...

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 ...