You're welcome 🙂 Thank you for the feedback.

Just one more note about the use of an explicit transaction. By default SQL Server will auto-commit statements unless the...

Two definite issues:

1. You have to watch your data types. In your CASE expression your default case outputs a 0, which will default to an INT in SQL Server. Try...

Yes. Drop the SQL Server...

I agree in so far as I could not find anything in spec related to this behavior, but not that it signifies any type of bug. I do not have...

Just a quick update. This problem was fixed on the Surface RT a while back. Thanks!

In that case I would go with a 3GB max memory setting as well provided SQL Server is the only thing running on the machine, and monitor available memory to...

The reason why I disagree is because of the behavior of the after trigger when it is the instead trigger that is fired first. The instead trigger fires the after...

Is your Server/SQL Server 32 or 64 bit? That will make a difference in terms of the percentage of your 4GB SQL Server can actually use by default.

This is a website dedicated to SQL Server. You mat get lucky and snag someone who also uses Jira that can help, but you may also want to consider posting...

brettstahlman (3/15/2013)

---

I agree that the "instead of delete" trigger will not be fired, but because the docs seem to indicate that it should be[/u], I don't feel comfortable relying on...

We're in a 2012 Forum so I'll assume SQL 2012. Support for COMPUTE was dropped from SQL Server 2012 and is not available under any compatibility mode. Use ROLLUP instead.

http://technet.microsoft.com/en-us/library/ms144262.aspx

I just ran Profiler to see what was happening and as I suspected the operation to get the list of databases is happening on the same SPID as the query...

PS Forgot to mention the function is undocumented so take that into consideration.

Are these SQL Agent date and time values? I used to have my own homegrown functions but I just picked up knowledge of this lttle gem on these forums the...

It's anyone's guess right now. To know for sure log the results of DBCC SQLPERF(logspace) right before you take your log backups for a few days and see what the...