Always Encrypted

Learning Always Encrypted

Learn about the SQL Server 2016 Always Encrypted feature.

RE: UDF Problem

You can't use another table unless you're inside the udf or inside a trigger. Maybe you could send the parameters needed to calculate the first field in the 2nd udf and recall the 1s udf in the 2nd one (don't know if it's allowed in this context). The only other way I see is the […]

RE: Shut Down Your Network

When you show her the monitor, also show her the link to the news story on that same page, "Health Scientist Says Laziness Lengthen Life"http://weblog.physorg.com/news1280.htmlShould be a slam dunk.

RE: A way to estimates the size of the transaction log file

I think you might want to have more than 10% additional space.If you run dbcc log or also ::fn_dblog, it shows almost 80 columns  which includes objectid, pageid, element length, row length, current/previous LSN and many more.

RE: SQL Server Perfomance issue

How could I eliminate the cause of the pagefile being overloaded. My perf counters does not show a big number of page faults, only the occasional one.

RE: Store Procedure compilation not giving error if table does not exist like SQL6.5.

One cool feature of "deferred name resolution" is that no matter what you do wrong, you can't accidentally turn it off. 

What's SQLServerCental.com All About

Comments posted to this topic are about the content posted at http://qa.sqlservercentral.com/columnists/s

RE: dtsrun would not die

If you have not done so already, you should try bouncing the service "MSSQLSERVER".  That will usually clean up processes like that.Jeff

RE: Upgrade to MDAC 2.8 or not?

If you use W2003, you do not have any choice about using MDAC 2.8 - it is the version shipped with W2003.