Viewing 15 posts - 34,231 through 34,245 (of 59,102 total)
kmaker (4/18/2011)
Thank you very much for the info on how to post.
Unfortunately I cannot get the table definitions of the SCADA (supervisory control and data acquisition) data so I...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 18, 2011 at 6:30 pm
p.s. According to what you posted... since you don't have a clustered on that table and I saw a FILL FACTOR of 100 running around in that code, you...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 18, 2011 at 6:20 pm
aGuareschi (4/18/2011)
select * from vipt_tab_003where pt03_annomese = 201001
and pt03_r_abi = 'XXXXX'
and pt03_num_eff = '569845456165748'
I agree with Syed above. The index you created doesn't have all the columns of your...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 18, 2011 at 6:10 pm
Tom.Thomson (4/18/2011)
Jeff Moden (4/17/2011)
Tom.Thomson (4/17/2011)
Incidentally, you can't call a stored procedure using OPENQUERY either.Maybe not, but OPENROWSET works a treat.
Interesting. I wonder why MS decided to forbid calling...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 18, 2011 at 5:33 pm
ChrisM@home (4/18/2011)
Jeff Moden (4/18/2011)
ChrisM@home (4/18/2011)
nikplic (4/17/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
April 18, 2011 at 5:28 pm
Gianluca Sartori (4/18/2011)
If somebody asked me for a compression tool, I would recommend IZArc, which is free and handles a lot of archive types, including RAR and ZIP.
Thanks, Gianluca. ...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 18, 2011 at 7:39 am
GilaMonster (4/18/2011)
Higher compression. Ability to split the archive into multiple files (great for huge archives going onto CD/DVD or for getting through email limits). Encryption and passwords....
--Jeff Moden
Change is inevitable... Change for the better is not.
April 18, 2011 at 7:33 am
That data structure will continue to burn you throughout your professional career at whatever company you're working for. Make them change it to a normalized data structure. Don't...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 18, 2011 at 7:27 am
Someone please tell me the advantage to using RAR files over ZIP files. ZIP files are the defacto compression type... what does RAR do that ZIP does not (except...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 18, 2011 at 7:20 am
As a side bar, I have an older machine that doesn't have RAR extracters in it, yet (so I can't see the OPs attachment). Someone please tell me if...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 18, 2011 at 7:14 am
ChrisM@home (4/18/2011)
nikplic (4/17/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
April 18, 2011 at 7:08 am
I'll also state that "genericising" stored procs like this is a really bad idea. Be very careful. And, I'll warn again, I've not tested the above for SQL...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 18, 2011 at 6:07 am
You can't have variables in OPENROWSET. Instead, you have to make the whole thing a dynamic statment. With that comes the possiblity of SQL INJECTION. You need...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 18, 2011 at 5:59 am
That, most definitely, would be true. 🙂
--Jeff Moden
Change is inevitable... Change for the better is not.
April 18, 2011 at 5:11 am
Restore from tape maybe?
--Jeff Moden
Change is inevitable... Change for the better is not.
April 17, 2011 at 9:16 pm
Viewing 15 posts - 34,231 through 34,245 (of 59,102 total)