Viewing 15 posts - 346 through 360 (of 608 total)
steve.ledridge (6/28/2013)
Here is a little function I wrote to deal with this very problem.
RBAR
June 29, 2013 at 12:13 am
charipg (6/27/2013)
Are there automatic routines that run to synchronize the Server's Clockto the Naval Observatory's master clock?
Not from SQL Server, but you can setup Windows to sync.
June 27, 2013 at 3:43 am
Alan.B (6/26/2013)
Sean Pearce (6/26/2013)
Alan.B (6/25/2013)
June 26, 2013 at 6:01 am
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', ''),...
June 26, 2013 at 5:56 am
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 posted.
Do you not...
June 26, 2013 at 4:24 am
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...
June 26, 2013 at 3:58 am
nicklibee (6/20/2013)
here is the answer!!!!!!!!,
I really hope you don't have to support this code in production.
June 26, 2013 at 3:15 am
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?
June 25, 2013 at 6:25 am
michal.lisinski (6/25/2013)
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...
June 25, 2013 at 6:21 am
x_japanfans5312 (6/24/2013)
seems like the order BY Number DESC on the insert statement doesn;t work in SQL Server 2012
We don't order INSERTS, we order SELECTS.
Your two queries can be read like...
June 25, 2013 at 4:05 am
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',...
June 24, 2013 at 2:59 am
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...
June 24, 2013 at 2:25 am
kiran.vaichalkar (6/19/2013)
Which operator takes the most time for execution?1) IN
2) NOT IN
3) AND
4) ALL
?
Your question makes this much sense:
I have a Sharp Calculator, which operator takes the most time for...
June 21, 2013 at 4:58 am
Viewing 15 posts - 346 through 360 (of 608 total)