Viewing 15 posts - 6,661 through 6,675 (of 9,715 total)
The only real difference between your SELECT * statement and Magoo's code is the varbinary column. At a guess, this column is storing some sort of images, yes?
Images are huge....
January 26, 2011 at 12:30 pm
Trey Staker (1/26/2011)
I guess I'll appologize for being too sensitive.
Trey, don't apologize for standing up and voicing your opinion. Every now and again, everyone needs a reminder than none of...
January 26, 2011 at 12:19 pm
SQLkiwi (1/26/2011)
WayneS (1/26/2011)
Well, Joe still has his rhetoric, but it seems to have been toned down quite a bit. Almost an attempt to be humorous about it.
He really seems to...
January 26, 2011 at 12:09 pm
mister.magoo (1/26/2011)
January 26, 2011 at 11:28 am
mister.magoo (1/26/2011)
SELECT [object_id]
, [form_family]
, [file_name]
...
January 26, 2011 at 11:12 am
Stefan Krzywicki (1/26/2011)
Where the hell did January go? I think it might have been buried in snow and I missed it.
Or it decided you were a bad little boy and...
January 26, 2011 at 11:08 am
Can you log directly into the server to test the server side response?
Have you tried a column list for the query to see if that changes?
Everything I'm finding on your...
January 26, 2011 at 11:06 am
CirquedeSQLeil (1/26/2011)
Trey Staker (1/26/2011)
I'm not suggesting anyone to delete any comments. I just don't think religion should be a topic in the Thread.
That kind of surprises me considering all...
January 26, 2011 at 10:57 am
Jpotucek (1/26/2011)
the table structure is listed above and there are no indexes on this small table
Another thing I should point out. Look back at your table structure. See this line:
PRIMARY...
January 26, 2011 at 10:54 am
Jpotucek (1/26/2011)
the table structure is listed above and there are no indexes on this small table
How many rows in the table? Can you upload some sample data (make sure to...
January 26, 2011 at 10:47 am
Look at the table size (width and length), see if the table has indexes (too few or too many?), look at the Dev's query, check Profiler and PerfMon for any...
January 26, 2011 at 10:27 am
You really need to look up GetDate() in Books Online before you use it. Changing Date() to GetDate() will make SQL do what you tell it, but it may end...
January 26, 2011 at 9:22 am
Gus, where and how did you learn all this stuff? It's really fascinating.
January 26, 2011 at 4:34 am
You could always give her the estimate for how long it will take just to map the processes and say you'll get back with the project timeline when that part...
January 25, 2011 at 12:01 pm
Viewing 15 posts - 6,661 through 6,675 (of 9,715 total)