RBAR

Not from SQL Server, but you can setup Windows to sync.

Alan.B (6/26/2013)

---

Sean Pearce (6/26/2013)

---

Alan.B (6/25/2013)

---

Which is why I included two solutions: My original solution which I believe is correct and one which was cleaner and faster than the one Michael...

These solutions will all give the desired output

DECLARE @MyVal BIGINT = 1234567890

SELECT 15

SELECT (@MyVal / 100000000) + 3

SELECT (@MyVal * 0) + 15

SELECT REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(CAST(@MyVal AS VARCHAR(20)), '2', ''),...

Do you not...

This happens in concatenation when the path is not executed due to the request being satisfied. The path is not executed (as seen by 0 actual rows after the clustered...

I really hope you don't have to support this code in production.

http://forums.asp.net/t/1916175.aspx/1/10?help+to+query

Double check the definition of the UNIQUE constraint and make sure your check is checking on the same columns.

Does the table have a trigger?

Profiler?

michal.lisinski (6/25/2013)

---

Hi Gila

You have the right to disagree with my opinion, but there is no "right" answer here. For data that is not meant to persist beyond the scope of...

http://msdn.microsoft.com/en-us/library/ms143703(v=sql.90).aspx

We don't order INSERTS, we order SELECTS.

Your two queries can be read like...

Running this 24\7 is potentially going to be massive amounts of data. I would have dedicated storage for the trace files.

exec sp_trace_setevent @TraceID, 'RPC:Completed', 'EndTime', @on

exec sp_trace_setevent @TraceID, 'RPC:Completed', 'Reads',...

The Login Properties window allows you to select a default database for a sql server login. This database must exist, be online and the login must have permission to access...

Your question makes this much sense:

I have a Sharp Calculator, which operator takes the most time for...