ScottPletcher (10/12/2015)

---

Eric M Russell (10/12/2015)

---

Kristen-173977 (10/9/2015)

---

Eric M Russell (10/9/2015)

---

Stuff like aliasing column names and stripping quotes from column values can be easily handled within the view or stored procedure, from...

Meatloaf (10/12/2015)

---

Hi, I am working with a SSIS Execute SQL Task and would like to see the results of my query. Is there a way to write the...

I could see a scenario where new hardware is purchased for the database server, and the old hardware ends up donated to the Development team or for sale on the...

If nothing else, TDE protects IT from the intrusion of nosy compliance auditors. However, as you know, there are other options for implementing data at rest encryption that might work...

When it comes to data governance, in the absence of any preexisting official documentation and governance, there simply is no deterministic truth. You're attempting to measure something that is subjective...

This was our philosophy when we built Chaos Monkey, a tool that randomly disables our production instances to make sure we can survive this common type of failure without any...

Kristen-173977 (10/9/2015)

---

Yeah, but...

The following doesn't use an UDF or CLR, and seems to cover all the (4) scenarios you described above.

declare @Invoice as table( BillID varchar(20) primary key );

insert into @Invoice...

https://msdn.microsoft.com/en-us/library/ms174408(v=sql.105).aspx

So this should work:

object_name( @@procid )

SQL_Surfer (10/8/2015)

---

I have two tables. Table A has 2162 rows and table B has 101 rows. There isn't any join keys that I can join on these two tables. But...

You can do a brute force dictionary query against the sys.sql_logins table.

http://www.sqlservercentral.com/Forums/FindPost1623412.aspx

When I say ad-hoc queries, I'm referring to scenarios where users are typing SQL into a query tool ad-hoc, or perhaps where an application has a search feature with an...

There has been more than one occasion in the past where I would hire on full-time at a company and then conclude within the first 90 days that the job...

thebrewersinaz (10/9/2015)

---

Hi our group is debating whether we should use views or data marts. WE have some huge queries that can have many joins up to 20 in some cases....

Kristen-173977 (10/9/2015)

---

...

The actual code to do the CSV part was trivial, but we did need to take care of properly quoting columns that had embedded commas, and then double-quoting any...