Viewing 15 posts - 166 through 180 (of 198 total)
How exactly is it done? I mean, exporting the existing cache to another system ? (I have not found anything on www on that..).
Your help will be really appreciated...
March 23, 2016 at 7:18 am
Well, this is exactly why I am looking to find out what SQL (and preferrably Calling_Object_Name (SP or FN...) that is associated with each missing indexes, so that we look...
March 23, 2016 at 5:39 am
That's exactly what my final goal is, to find either SQL or better SP or FN names that would benefit from each missing index.
Also, a certain % of queries will...
March 22, 2016 at 6:32 pm
yes. attached. sql works fine. it s a challenge how to format the flat file right..
February 23, 2016 at 11:27 am
that's exactly right. I do not want comma delimited.
but the output (DESIRED one) that you see on the top of the first page of the attachment is correct, there...
February 23, 2016 at 9:36 am
Whatever I do, the columns in text file do not come out justified and separated by equal space, with column name precisely on top of column data (which doesn't happen...
February 23, 2016 at 9:33 am
The reason i asked about that was because there are a couple of folks who i work with who specifically asked me if I know a SQL Coach who could...
January 29, 2016 at 6:18 am
you mean you actually are not doing SQL/databases/programming for living?!
how can that be...
January 29, 2016 at 3:48 am
Thank you !!! You are the man.
I really appreciate your help.
are you actually really coaching some dumber folks like myself in SQL server remotely (I mean for pay)...
January 28, 2016 at 3:11 pm
full table data is also in XL (spreadsheet 2).
December 28, 2015 at 1:48 pm
What you mentioned is very cool. We do not have Identity id column gaps (yet..),
while they are indeed possible.
Thus my next question :
How come that the result-set from this...
December 28, 2015 at 1:45 pm
it was very helpful! thank you!
December 27, 2015 at 8:28 pm
<< I wonder if there is anyway whatsoever to distinguish these dupes from each other.>> well it is NOT KNOWN.
IT will take a while till we complete the study...
February 6, 2014 at 1:52 pm
PROBLEMS with your advises so far:
1 - However if I use all these methods then I will have to face RECREATING INDEXES on a new table. There are several non-clustered...
February 6, 2014 at 11:10 am
Leading space was just my finger tapping the keyboard too intensely..
January 31, 2014 at 9:52 am