Viewing 15 posts - 3,211 through 3,225 (of 6,676 total)
For a single row insert, this is how I would approach it:
First, start a transaction...
Update the rows associated with the key - changing the position:
UPDATE table
SET pos = pos +...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
May 18, 2011 at 4:46 pm
A CTE is just a part of a normal DML statement. It can be included with any SELECT, INSERT, UPDATE or DELETE statement.
You are going to have to show...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
May 18, 2011 at 3:50 pm
koolme_85 (5/17/2011)
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
May 17, 2011 at 7:44 pm
The coalesce and case statements are not equivelant. COALESCE will return the firt non-null value and your case statement is going to return the first code that does not...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
May 17, 2011 at 2:38 pm
colin.Leversuch-Roberts (5/17/2011)
I will say I did some tests...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
May 17, 2011 at 2:01 pm
You could also look at replication as an option - again, it really depends on what you need to accomplish.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
May 17, 2011 at 1:58 pm
The only way I can think of to guarantee that format would be to create your query with a single column where you concatenate every column into the result.
SELECT quotename(column1,...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
May 16, 2011 at 8:15 pm
RLB (5/16/2011)
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
May 16, 2011 at 8:10 pm
Welsh Corgi (5/15/2011)
I'm sorry but but it appeared to to be a "special" new classification, for I have not seen it before?
You have not seen it before, because you did...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
May 15, 2011 at 6:50 pm
LM1 (5/11/2011)
SELECT DATEADD(DAY, DATEDIFF(DAY, 0, GETDATE()), 0) AS DateOnly
(Replace GETDATE() with the name...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
May 15, 2011 at 10:46 am
I think it really is going to depend on what you are trying to accomplish. Is this requirement for reporting, and does it need to be real-time?
If it doesn't...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
May 15, 2011 at 10:39 am
How have you determined that this is happening automatically? Do the SQL Server Logs show that SQL Server was shut down and then restarted? Is there any indication...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
May 14, 2011 at 3:07 pm
Also talk to your SAN guys - or your SAN vendor, if the LUN where the log file is located has been presented from a SAN and is not direct...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
May 14, 2011 at 11:27 am
This could be done using a batch file and calling out to SQLCMD. However, you would have to get that installed on each client's desktop.
You could also use a...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
May 13, 2011 at 8:31 pm
I believe SQL Server will no longer be available - or, at least it will have problems.
Not that I have had multiple files on separate LUNs where I lost one...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
May 13, 2011 at 5:17 pm
Viewing 15 posts - 3,211 through 3,225 (of 6,676 total)