ZZartin (12/1/2016)

---

Eric M Russell (12/1/2016)

---

Other than something like pushing a deployment outside the formal change control process or granting someone elevated permissions, has anyone here ever been asked to compromise...

Are you the DBA for this server; can you connect to the instance using SSMS or SQLCMD and execute SP_WHO2 ?

Other than something like pushing a deployment outside the formal change control process or granting someone elevated permissions, has anyone here ever been asked to compromise their ethics while on...

savibp3 (12/1/2016)

---

There is stored procedure which show no error but keeps on executing with stop.I had placed some select statements to debug when i stop the browser after some time...

Gabriel P (11/30/2016)

---

Hey, does anyone know if there's some undocumented feature that would allow you to query a table by FileID/PageID?

Something like this:

SELECT *

FROM dbo.ThisTable

WHERE $FID = @FileID

AND $PID =...

You can also strip characters from a string using the REPLACE function. The ASCII characters for carriage return is (13) and it's typically followed by a line feed (10).

DECLARE @s-2...

Even if a column contains the same value for every row, it can still very well be used. If you do choose to remove the physical column, you may want...

No, you can't open a SSIS project or package directly and edit in place, or at least it's not as easily done as jobs or stored procedures. However, there are...

For the concepts of relational algebra that underly SQL, here is an overview:

https://en.wikipedia.org/wiki/Relational_algebra

The mathematical operators and functions included in the T-SQL language are quite basic.

https://msdn.microsoft.com/en-us/library/ms187716.aspx

https://msdn.microsoft.com/en-us/library/ms177516.aspx

Steve Jones - SSC Editor (11/30/2016)

---

Eric M Russell (11/30/2016)

---

I totally don't understand why someone would publish sample programming code on the public web and then expect other folks not to...

Years ago, Adam Machanic developed a load testing tool for running either batches of T-SQL statements or stored procedure calls.

http://sqlblog.com/blogs/adam_machanic/archive/2016/01/04/sqlquerystress-the-source-code.aspx

https://www.brentozar.com/archive/2015/05/how-to-fake-load-tests-with-sqlquerystress/

Also, you can leverage the WAITFOR command to execute a T-SQL...

I totally don't understand why someone would publish sample programming code on the public web and then expect other folks not to use it or even expect folks to ask...

mjh 45389 (11/30/2016)

---

Eric M Russell (11/30/2016)

---

If we eliminate cows as a source for green-house gas emissions then next up will be human produced gas emissions... particularly that of west coast...

First, not everyone has a SSN, and another problem is that it's not verifiable. How do I know that John Smith's SSN is 111-22-3333?

If you identify someone by their email...

David.Poole (11/30/2016)

---

What I'd like to see is a framework to support whistle blowers.

By all means insist on evidence but whistle blowers need protection. Most companies have a whistle blower...