Viewing 15 posts - 2,611 through 2,625 (of 5,843 total)
Please put the stuff up as a TEXT document. I don't download files that can run code. :hehe:
April 6, 2013 at 5:52 am
...I would hope that the two executions of the CTE happening together in milliseconds would return the same 10 rows...
Personally I prefer to not rely on "hope" to get the...
April 5, 2013 at 10:31 am
This is an INCREDIBLY COMMON misunderstanding I see at clients all the time. You simply CANNOT rely on ORDER of data unless it is EXPLICITLY stated with an ORDER...
April 5, 2013 at 9:33 am
please read this post (http://www.sqlservercentral.com/articles/SQLServerCentral/66909/) and then reply to this thread with a create table statement, insert statements with your sample data and then formatted output of the desired output....
April 5, 2013 at 9:28 am
Lynn Pettis (4/3/2013)
TheSQLGuru (4/3/2013)
refactor your TVF to be an INLINE TVF and use that. Also push that SELECT ...(SELECT...) out like previous poster did.
Actually, the TVF being used is an...
April 3, 2013 at 9:11 am
refactor your TVF to be an INLINE TVF and use that. Also push that SELECT ...(SELECT...) out like previous poster did.
April 3, 2013 at 9:07 am
Hierarchical data is very difficult in relational structures. If you can refactor the table you might get a win from using the built-in hierarchy datatype, which is CLR based...
April 2, 2013 at 9:40 am
1) a picture of the query plan is NOT the same thing as the ACTUAL query plan. Please post that. Also, since it is failing probably need to...
April 1, 2013 at 8:57 am
That isn't an article, that is the actual BOL entry for MERGE. It has examples (including one that is specifically for your solution). However, I STRONGLY recommend you...
March 29, 2013 at 9:02 am
Are you on a 32 bit sql server install by any chance?
March 29, 2013 at 7:40 am
EL_oh_EL (3/27/2013)
March 29, 2013 at 7:37 am
1) ALWAYS USE BOL!!! It is an AWESOME resource. I NEVER have it closed, and I have been working with SQL Server for 15+ years! 🙂
2) Your sample...
March 28, 2013 at 4:45 pm
it is always best to provide table scripts, sample data and expected outcomes.
BTW, did you review MERGE in Books Online? There are some VERY good examples there to guide...
March 28, 2013 at 4:07 pm
A) does DBCC memorystatus reveal anything?
B) review the SQL and windows error logs (especially around startup) for anything unusual
C) review hyperV and host config, especially everything related to memory (dynamic...
March 27, 2013 at 11:20 am
Given that profiler shows no queries with large numbers of reads took away my normal response.
Complete guesses here:
1) someone accidentally put windows/sqlserver 32 bit on the system (yes,...
March 27, 2013 at 8:46 am
Viewing 15 posts - 2,611 through 2,625 (of 5,843 total)