Viewing 15 posts - 8,041 through 8,055 (of 26,490 total)
TravisDBA (4/11/2013)
majorbloodnock (4/11/2013)
TravisDBA (4/10/2013)
djackson 22568 (4/10/2013)
SuperDBA-207096 (7/22/2008)
April 11, 2013 at 7:58 am
ChrisM@Work (4/11/2013)
I only see one plan for the conditional select, the same plan whichever parameter I use. It's what I'd expect to see. Am I missing something?
If you run the...
April 11, 2013 at 7:52 am
curious_sqldba (4/11/2013)
Lynn Pettis (4/10/2013)
April 11, 2013 at 7:35 am
ejoell 66477 (4/11/2013)
Concerning your remark from July 2008 about CS degreed folks having a better grasp of DB theory.
In my experience that has not been necessarily the case. Even...
April 11, 2013 at 7:26 am
I think I know why, the table #test are different tables when the stored procedure is run in different sessions. Therefore you will get separate plans for the execution...
April 10, 2013 at 8:54 pm
curious_sqldba (4/10/2013)
Lynn Pettis (4/10/2013)
curious_sqldba (4/10/2013)
April 10, 2013 at 7:27 pm
Couple of things that would help here, the DDL for the tables and the indexes defined on the tables also, the query being used to pull the data (I know...
April 10, 2013 at 6:29 pm
I'm curious as to you reasoning behind the choice for your partitioning.
April 10, 2013 at 6:26 pm
Have you searched the forums on ssc for MySQL and Linked Servers? I know this has been asked before but I don't remember the specific threads.
April 10, 2013 at 5:28 pm
curious_sqldba (4/10/2013)
April 10, 2013 at 4:24 pm
Are you using sp_start_job to execute your jobs? If so, that procedure is asyncronous, meaning it returns immediately after starting the job and doesn't wait for it to complete.
April 10, 2013 at 4:01 pm
shahdipen727 (4/10/2013)
can someone explain me why we use replicate in our queryand also len, ltrim, rtrim and convert with useful example
Have you looked up in Books Online what these...
April 10, 2013 at 2:52 pm
bagofbirds-767347 (4/10/2013)
April 10, 2013 at 2:46 pm
Erin Ramsay (4/10/2013)
Thanks! I never thought of using a recursive CTE but that seems like the ticket to me if we stick with a straight SQL solution.
sturner:
I have to...
April 10, 2013 at 2:12 pm
johnnyrmtl (4/10/2013)
yep the column is in a "datetime" format
You are saying that the datatype of the column is datetime, correct?
April 10, 2013 at 2:10 pm
Viewing 15 posts - 8,041 through 8,055 (of 26,490 total)