Viewing 15 posts - 20,866 through 20,880 (of 26,484 total)
Roy Ernest (5/20/2009)
Mine are still very young. Once they become a teenagers, I will make a bunker for myself and close myself in it... 😛
Build it now! They will...
May 20, 2009 at 3:15 pm
First, i think the first query should benefit from the partioned table. Not sure about the second one.
Second, I took the time to rewrite your queries. I think...
May 20, 2009 at 3:10 pm
What do your typical queries look like, not the one you alread showed me by the way.
May 20, 2009 at 2:26 pm
You might want to look at SQL Server 2008 with the varbinary data type and the filestream filegroup (?).
May 20, 2009 at 2:12 pm
What you are trying to accomplish may not benefit from a partitioned table. What is your objective? How much data do you have? What are the normal...
May 20, 2009 at 2:03 pm
Roy Ernest (5/20/2009)
Alvin Ramard (5/20/2009)
Roy Ernest (5/20/2009)
... You have all gone crazy.... 😛And your point is?
😎
My point is I am the only sane one giving out insane advices... 😀
But are...
May 20, 2009 at 1:59 pm
Insanity is hereditary, you get it from your kids
-- reference unknown
Edit: And for those without kids, I have no explanation.
May 20, 2009 at 1:37 pm
Roy Ernest (5/20/2009)
All of you need a vacation... You have all gone crazy.... 😛
we can't go where we already are
May 20, 2009 at 1:36 pm
I don't know. You did not provide the actual code for the partition scheme, partition function, or the partition table.
May 20, 2009 at 1:33 pm
lily1706 (5/20/2009)
select * from [table_name] where date > '2009-03-01 00:00:00.000'
i tired on my production DB where the table is not partitioned yet and I...
May 20, 2009 at 1:15 pm
What do your queries look like? Could you post one or two of them?
May 20, 2009 at 1:07 pm
Alvin Ramard (5/20/2009)
Lynn Pettis (5/20/2009)
Alvin Ramard (5/20/2009)
Lynn Pettis (5/20/2009)
The mind, know you, first to go it is.I'd say something about that last comment but my mind is blank.
:w00t:
Worry not young...
May 20, 2009 at 1:04 pm
Alvin Ramard (5/20/2009)
Lynn Pettis (5/20/2009)
The mind, know you, first to go it is.I'd say something about that last comment but my mind is blank.
:w00t:
Worry not young padawan, with yours mine...
May 20, 2009 at 12:57 pm
Glad you resolved the problem I am.
May 20, 2009 at 12:56 pm
Alvin Ramard (5/20/2009)
Lynn Pettis (5/20/2009)
Alvin Ramard (5/20/2009)
Luke L (5/20/2009)
Alvin Ramard (5/20/2009)
Jack Corbett (5/20/2009)
Lynn Pettis (5/20/2009)
Lynn Pettis (5/20/2009)
Would someone who knows SSRS please go help this person?Thanks Luke!
I have to admit...
May 20, 2009 at 12:43 pm
Viewing 15 posts - 20,866 through 20,880 (of 26,484 total)