Viewing 15 posts - 3,796 through 3,810 (of 8,753 total)
The main difference between those two queries is that the first (#1) uses a Stream Aggregation Operator to sum the values while the second (#2) uses an Arithmetic Addition and...
March 20, 2016 at 5:00 am
Can you post the DDL for the AdeccoView table and some sample data as an insert statement, makes answering the question much easier.
😎
March 20, 2016 at 4:49 am
mburbea (3/19/2016)
March 20, 2016 at 3:58 am
Tempdb is always in simple recovery so backup is futile, find out what is filling the log or even better, add the new file and see if what ever operation...
March 19, 2016 at 6:37 am
coolchaitu (3/19/2016)
Good morning Experts,Transaction log file is full. I cannot even issue backup log command as there is no space at all. Please advise the best solution
Temporarily add a file...
March 19, 2016 at 6:00 am
Quick suggestions: don't use table variables for any kind of serious testing and include covering indices to eliminate sorts and key lookups.
😎
IF OBJECT_ID(N'dbo.OrderDetails') IS NOT NULL DROP TABLE dbo.OrderDetails;
CREATE TABLE...
March 18, 2016 at 4:09 pm
mburbea (3/18/2016)
March 18, 2016 at 3:53 pm
Luis Cazares (3/18/2016)
Eirikur Eiriksson (3/18/2016)
Luis Cazares (3/18/2016)
Eirikur Eiriksson (3/18/2016)
Luis,you might be chasing Red Herrings here, does this happen just after the full backups?
😎
Define "just after the full backups". It happens...
March 18, 2016 at 3:42 pm
Jeff Moden (3/18/2016)
Goldie Lesser (3/18/2016)
Ed Wagner (3/17/2016)
If it doesn't have a sequence number, I wont be using it. 'Nuff said.
I use Jeff's function all the time, and I can't...
March 18, 2016 at 3:37 pm
mburbea (3/18/2016)
without...
March 18, 2016 at 3:21 pm
The traceflag 8690 in the test set generation even makes the case worse for the new string_split function, by the looks of it it was benefiting more from the consistent...
March 18, 2016 at 3:14 pm
mburbea (3/18/2016)
http://www.sqlservercentral.com/Forums/FindPost1570980.aspx
Paul White (5/14/2014)
If so, you might not be testing what...
March 18, 2016 at 3:02 pm
Luis Cazares (3/18/2016)
Eirikur Eiriksson (3/18/2016)
Luis,you might be chasing Red Herrings here, does this happen just after the full backups?
😎
Define "just after the full backups". It happens when the query is...
March 18, 2016 at 2:57 pm
mburbea (3/18/2016)
Also sqlperformance article seems to suggest the thing performs fairly well...http://sqlperformance.com/2016/03/t-sql-queries/string-split
Obviously, his t-sql and xml based splitters are poor choices.
Did read Aaron's post, thanks again
😎
March 18, 2016 at 2:54 pm
Goldie Lesser (3/18/2016)
Ed Wagner (3/17/2016)
If it doesn't have a sequence number, I wont be using it. 'Nuff said.
I use Jeff's function all the time, and I can't even think...
March 18, 2016 at 2:52 pm
Viewing 15 posts - 3,796 through 3,810 (of 8,753 total)