Viewing 15 posts - 346 through 360 (of 5,394 total)
Breaking a big transaction in smaller batches is not nesting transactions. The main benefit is less transaction log space used (the log can be truncated by checkpoints in simple recovery...
July 3, 2015 at 2:21 am
Weird, I never came across such a situation.
Sorry for being unhelpful.
July 1, 2015 at 8:32 am
What does job activity monitor say? Does it display the job as executing or completed?
July 1, 2015 at 7:01 am
Duplicate post. Replies here please: http://www.sqlservercentral.com/Forums/FindPost1699207.aspx
July 1, 2015 at 6:32 am
Job history does not show information for running executions of the job. It only show information for the latest completed execution.
July 1, 2015 at 6:28 am
Congrats Alan! My second daughter turns 3 months on Friday and I can confirm that SQL stands for Sleep Quality Lowered in this case 😀
June 29, 2015 at 2:32 pm
Can you resolve the server name?
nslookup servername
Can you ping the server name?
ping servername
Can you connect to the server on port 1433? (Download portqry from here: http://www.microsoft.com/en-us/download/details.aspx?id=17148)
portqry -n servername -p TCP...
June 25, 2015 at 3:17 am
This procedure has been migrated from Oracle. Returning a cursor from a stored procedure is a common pattern in Oracle, but much less common in SQL Server.
This is because Oracle...
June 25, 2015 at 2:56 am
If you installed SQL Server Express using the default settings, it installed a named instance (SQLEXPRESS). This instance is listening on a dynamic port by default. The only way to...
June 25, 2015 at 2:53 am
Thanks for the feedback!
June 25, 2015 at 2:00 am
ChrisM@Work (6/24/2015)
I wonder how a rCTE version would fare, in terms of performance?
Brilliant! Works like a treat!
June 24, 2015 at 6:50 am
The error suggests that the server name was misspelled in the ODBC settings. Did you check it?
June 24, 2015 at 3:46 am
Maybe this?
DECLARE @tmp TABLE(fruit VARCHAR(50),shop VARCHAR(10),preference INT, qty INT)
INSERT INTO @tmp(fruit,shop,preference,qty) VALUES ('orange','shop 1',1 ,4)
INSERT INTO @tmp(fruit,shop,preference,qty) VALUES ('orange','shop 2',2 ,3)
INSERT INTO @tmp(fruit,shop,preference,qty) VALUES ('orange','shop 3',3 ,5)
INSERT INTO @tmp(fruit,shop,preference,qty) VALUES...
June 24, 2015 at 3:44 am
I tried to play with the code a bit, but frankly I have no time. Probably your initial idea of using a temp table and compute the sums is the...
June 24, 2015 at 3:20 am
Viewing 15 posts - 346 through 360 (of 5,394 total)