Viewing 15 posts - 4,186 through 4,200 (of 9,722 total)
Post the code inside the window using the IFCodes please. Many of us don't open attachments. Also, post DDL with sample data so we can help you better.
July 13, 2012 at 12:36 pm
More information.
When we call the webservices directly from the service, it doesn't timeout at the 15 minute mark. Only when we call it from the SSIS package does it timeout.
Does...
July 13, 2012 at 12:35 pm
bitbucket-25253 (7/13/2012)
Revenant (7/13/2012)
Lynn Pettis (7/13/2012)
Brandie Tarvin (7/13/2012)
YAY for people who still allow SQL Injection on their servers! (NOT!)http://news.cnet.com/8301-1009_3-57470786-83/hackers-post-450k-credentials-pilfered-from-yahoo/%5B/url%5D
Yes, saw that on twitter yesterday.
Some people will never learn I guess.
I am...
July 13, 2012 at 12:31 pm
YAY for people who still allow SQL Injection on their servers! (NOT!)
http://news.cnet.com/8301-1009_3-57470786-83/hackers-post-450k-credentials-pilfered-from-yahoo/%5B/url%5D
July 13, 2012 at 10:45 am
That is a very good point, Gazareth. Even my query won't run very well if the table is a heap.
July 13, 2012 at 5:32 am
jdbrown239 (7/11/2012)
Can you show us an example of File to Table conversion? (I can't see 4000 only showing up as 0s or 1s).--select eb_recent_high_credit from gdsland where EB_RECENT_HIGH_CREDIT >= 0
eb_recent_high_credit
0
0
0
0
0
0
0
0
0
0
0
0
Note...
July 13, 2012 at 5:19 am
Do you have a question or are you just reporting something you ran across and fixed?
July 13, 2012 at 5:13 am
Instead of doing all your processing in the CASE statement, try using subqueries. I was going to do this using CTEs, but decided to go with the multiple join method.
SELECT...
July 13, 2012 at 5:10 am
There is no backup designed for indexes only. You could script them out as a DROP - CREATE series of statements by going to the GUI though, right-clicking the database...
July 13, 2012 at 4:49 am
Mahmood, would you please bold the places where you made chances to the code to make it easier to read?
July 13, 2012 at 4:45 am
Lowell (7/11/2012)
last i heard, the views were there to stay, but could be changed;
some article i read said any changes would be things like adding columns to the end of...
July 11, 2012 at 12:01 pm
Lowell, Ah. Interesting. I didn't think about it that way.
FYI: Please don't think I was saying "it's bad to use sys.columns." I was just genuinely curious why people would still...
July 11, 2012 at 11:49 am
Just a note on forms. So far as I know, a label box doesn't actually point to a database & table. It is just a label. So trying to connect...
July 11, 2012 at 11:34 am
Lowell (7/11/2012)
since you are searching every table/column for text, this is slow, and any tables with a Million rows are...
July 11, 2012 at 11:28 am
Viewing 15 posts - 4,186 through 4,200 (of 9,722 total)