Viewing 15 posts - 18,121 through 18,135 (of 26,484 total)
Yes, you are welcome. It is always good to hear when we have been able to help.
😀
December 4, 2009 at 4:40 pm
Without seeing the code for the stored procs, I'd say it sounds like a good case of parameter sniffing. By forcing a recompile of the procedures each time they...
December 4, 2009 at 3:06 pm
Semantics can be a pain, but just going by what is in BOL:
When a CTE is used in a statement that is part of a batch, the statement before it...
December 4, 2009 at 12:14 pm
homebrew01 (12/4/2009)
December 4, 2009 at 11:42 am
bitbucket-25253 (12/4/2009)
cos_ta393... Notice neither your post or Jasons showed that the
T-SQL WITH is preceded by a ; be careful it is a requirement.
Not quite correct, actually. It...
December 4, 2009 at 10:53 am
siddaiah.k (12/4/2009)
yes , I am preparing for interview for ssrs position .plz send ssrs interview questions and answers or send links
With respect, if you aren't ready for the interview based...
December 4, 2009 at 10:37 am
homebrew01 (12/4/2009)
In looking at some inherited applications, I see some indexes with names like:_dta_index_MyTableName_10_1831013604__K2_K4_K8
These look like system generated names. Any idea where they come from ?
Bru is correct.
The _dta indicates...
December 4, 2009 at 10:24 am
Bru Medishetty (12/4/2009)
Bob Hovious 24601 (12/4/2009)
Visions of William Shatner in Airplane II: The Sequel.
I thought it was Lloyd Bridges.
Bru: Lynn is correct.
If I post something...
December 4, 2009 at 10:19 am
Bru Medishetty (12/4/2009)
Bob Hovious 24601 (12/4/2009)
This isn't the right thread for technical questions. I'd move it to one of the usual forums.
No.... that's just what they'll be expecting us to...
December 4, 2009 at 9:42 am
GSquared (12/4/2009)
WayneS (12/4/2009)
I'm having a weird issue. I can run a select * from a view from SSMS, no problem. Web site can't run it, and can't open the...
December 4, 2009 at 9:04 am
Nope. I would need to see the error message(s) that you should find in the log files. They may say more than to error messages you posted.
December 4, 2009 at 8:38 am
For the right position, I'd consider moving, but not to California. I have no desire to live there.
December 4, 2009 at 8:37 am
Please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
December 4, 2009 at 8:00 am
Where is the data coming from that you are trying to insert? I seem to missing something when I look at the code.
December 4, 2009 at 7:55 am
Unfortunately, I can't see what your package looks like, and I realize debugging an SSIS package over the internet is more difficult than SQL code, but without more info can't...
December 4, 2009 at 7:53 am
Viewing 15 posts - 18,121 through 18,135 (of 26,484 total)