If you are the DBA (or simply the person sitting closest to the database server), then probably the best thing you can do to improve performance is educate yourself about...

sp_MsForEachDB may not be officially documented by Microsoft, but back in 2007 an anonymous member of Microsoft's SQL Server team did obliquely acknowledge it's existence.

https://connect.microsoft.com/SQLServer/feedback/details/264677/sp-msforeachdb-provide-supported-documented-version

Phil Parkin (10/4/2016)

---

New Born DBA (10/4/2016)

---

Experts,

Is is possible to create multiple tables with same tablename and column in multiple databases without selecting each database from the drop down menu and...

You can use a Derived Column transformation task between source and destination, or you can modify SQL to cast the column as specific data type.

For example: CAST( col1...

OK, I thought he said stored procedure earlier, so scratch that.

So, you have this flat denormalized table containing nearly 100 million rows and 100+ columns. The problem is you need to report from it; performing rollups at various levels, aggregation...

If for whatever reason the extended event trace doesn't give you what you need about input parameter values, then can also implement procedure call auditing using a table and adding...

If I understand you correctly, you have a table containing a significant amount of history, much of which you believe can be archived elsewhere. You now want to know the...

Gary Varga (10/4/2016)

---

So now everyone and their grandma is going to ask us to secure their IoT lightbulb because it is going to be "their" responsibility. Legally, would it then...

When in the role of a candidate, I'll typically ask why the previous person in the position decided to leave, or why he/she was let go. It's a good one...

Perhaps the procedure you are executing is calling the other procedure. Look at the T-SQL contents to confirm. That would be my first guess.

Are you asking how to SQL query a text file?

If so, then you canuse OPENROWSET function.

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

jasona.work (10/3/2016)

---

...

Which, really, comes around to "why in the H*LL does my refrigerator need to be on the internet in the first place?" So I can remotely check my...

One option is to use VPN/RDP to access your PC or server from where you can use SSMS or SQLCMD.

I'm only somewhat acquainted with Oracle, enough to form an opinion without forming an attachment. In my opinion, Oracle has a lot of "junk in it's trunk" dating back to...