Viewing 15 posts - 18,811 through 18,825 (of 26,484 total)
You didn't provide the error message you are getting, but I can see the problem. You can't use variables in the SELECT INTO the way you are attempting. ...
September 21, 2009 at 6:48 am
Roy Ernest (9/18/2009)
Hey Lynn, Why not write about resource governor? There is a lot to write and it is a pretty interesting topic too.
Good idea, just one problem. I...
September 18, 2009 at 3:23 pm
Grant Fritchey (9/18/2009)
Lynn Pettis (9/18/2009)
Grant Fritchey (9/18/2009)
Lynn Pettis (9/18/2009)
Grant Fritchey (9/18/2009)
Lynn Pettis (9/17/2009)
September 18, 2009 at 2:59 pm
admin-783635 (9/18/2009)
5.5 Lakh = 550000 INR = 11,423.49999 USD (Lakh = 100,000)
Next question, annual or monthly salary?
September 18, 2009 at 12:55 pm
Lynn Pettis (9/18/2009)
Anyone else want to add anything here?
It always amazes me how quickly others will join a topic when asked. This site is just awesome! 🙂
September 18, 2009 at 12:47 pm
Grant Fritchey (9/18/2009)
Lynn Pettis (9/18/2009)
Grant Fritchey (9/18/2009)
Lynn Pettis (9/17/2009)
September 18, 2009 at 12:46 pm
Jeff Moden (9/18/2009)
If nothing else, the NOT LIKE will likely force a scan.
Building on this, empid isn't even in the index, so sounds like a good possibility for a table...
September 18, 2009 at 12:29 pm
Grant Fritchey (9/18/2009)
Lynn Pettis (9/17/2009)
September 18, 2009 at 12:13 pm
Anyone else want to add anything here?
September 18, 2009 at 11:54 am
That may be what you are looking for, but don't restrict yourself to just that. There may be other things that maybe better than an indexed view. Leave...
September 18, 2009 at 11:46 am
Jack Corbett (9/18/2009)
I did read your latest article and it was good. I usually only comment on the ones that have what I believe to be a bad practice...
September 18, 2009 at 9:31 am
Paul White (9/18/2009)
¿???p??? o? p??? si?? pui? lli? ????dsi??? u?????ou ??? ?o?? ?ldo?d ?i ??puo? i
Actually, once I saw it here on my pc, no problem reading it at all....
September 18, 2009 at 9:26 am
Tara, please read the second article I have linked in my signature problem regarding performance problems. Follow the instructions in that article regarding what you should post to get...
September 18, 2009 at 9:22 am
Just an FYI for the denizens of The Thread, next Tuesday I have another article being republished here on ssc as well. Keep an eye out as I am...
September 17, 2009 at 8:27 pm
Well, he did apologize, but I'm not sure if there was enough grovelling. 😛
September 17, 2009 at 1:27 pm
Viewing 15 posts - 18,811 through 18,825 (of 26,484 total)