Occasionally two machines will hit the database at the same time and end up with sets of data that overlap each other causing the applications to act twice on the...

CLR is more elegant.

Regards,

Jason

http://dbace.us

----------------------------------------------------------------------------------------------

using System.Net;

using System.Security;

using System.Data.SqlTypes;

using Microsoft.SqlServer.Server;

public class SQLSPGetHostName

{

// static string whatipaddress

[Microsoft.SqlServer.Server.SqlProcedure]

public static void GetHostNameFromIPAddress(string whatipaddress)

...

http://blogs.msdn.com/b/jimmymay/archive/2008/12/02/case-study-part-2-cxpacket-wait-stats-max-degree-of-parallelism-option-suppressing-query-parallelism-eliminated-cxpacket-waits-liberated-30-of-cpu.aspx

http://msdn.microsoft.com/en-us/library/gg415714.aspx

Just to clarify there are differnt operating systems:

http://www.whylinuxisbetter.net/items/defragment/index.php?lang=

You would want to query the actual physical IO.

Definitely. I agreed 100%. That is why I titled my web site "DBA Automation". Once you see the value, you will never go back.

Not only you automate your tasks, you...

If a foreign key referenced only one of the rows you are deleting, isn't that by definition not a duplicate? So then in that case can't you just delete with...

I just did DAC a week ago with windows local administrator rights, and without build-in administrator being as sysadmin.

DAC is calling SQLCMD locally on the server. Please read BOL.

Windows...

Paul and Divine, There are no tricks. I just did DAC a week ago with windows local administrator rights, and without build-in administrator being as sysadmin. (Paul, we did deselect...

If you are already local administrator, why don't you just use DAC. See BOL if you don't understand DAC.

SQLSaturday#57

http://dbace.us/repriser/images/abstractwhyquerysoslow_.html

Check my published scripts. You will find where that data is stored in the script code.

Kalen Delaney has a chart in her book "SQL Server 2008 Internals" that shows the difference of isolation level. I will prefer use of snapshot isolation vs read_committed_snapshot isolation.

On my...

This article again shows SQL Server's shortcomings.

1) default to full recovery mode (Oracle is opposite)

2) not able to free unused space without side effecct. (Oracle does not have this problem)

3)...

I wrote a stored procedure that generates "restore script" by entering a date-time parameter. (We can also do this with LSN or transaction mark). I also have a version that...