Viewing 15 posts - 3,946 through 3,960 (of 18,926 total)
TravisDBA (8/1/2011)
Kiara (8/1/2011)
GSquared (8/1/2011)
It gets worse than just accents.I've had a multitude of people assume I'm not American, because I "speak well" instead of "talk good".
:hehe: Sadly, my experiences with...
August 2, 2011 at 1:02 pm
So I get credit for all further answers, how nice :-P.
I also asked for sample data > (insert statements).
I'll go 1 up and ask for the actual execution plans for...
August 2, 2011 at 12:59 pm
That seems clear enough. So where do you need help, other than us doing all the work for you, free?
August 2, 2011 at 12:53 pm
And the SSRS parameter is DATETIME and NOT string?
(just want to be 100% certain).
If it still doesn't work, please post the actual execution plan so that I can take a...
August 2, 2011 at 12:52 pm
You should set it at some MB (or GB).
Try to keep it so that it can extend in 1-2 sec max.
On another note, I'd change the initial size so that...
August 2, 2011 at 12:51 pm
Sean Lange (8/2/2011)
I wouldn't even try to roll your own. Take a look at Jeff Moden's string parser[/url]. What you have is a delimited string using ^.
For the 3rd time:exclamation:.
Fast,...
August 2, 2011 at 12:50 pm
... and you do that how in a multi-user env?
August 2, 2011 at 12:48 pm
Give them SA in dev. Read-only max in prod (if any access at all).
Test and QA should be used the application's rights.
August 2, 2011 at 12:47 pm
That shouldn't happen (only ever saw that from profiler to ssms).
Are you sure that the parameters are declared as datetime in the proc, the parameters and the column....
August 2, 2011 at 12:40 pm
ChrisTaylor (8/2/2011)
As stated by others, from a quick glance over it there are a number of...
August 2, 2011 at 12:33 pm
Didn't read the whole thing, but I need to point out that you might want to rebuild the stats (that are outside the rebuilt index).
For this reason : http://sqlinthewild.co.za/index.php/2011/03/22/statistics-row-estimations-and-the-ascending-date-column/
August 2, 2011 at 12:31 pm
Then it's back to openrowset, openquery or linked server.
Nothing else will work. So get <something> setup depending on the business rules and be done with it.
August 2, 2011 at 12:27 pm
chess.chess (8/2/2011)
OK , thanks guys . I didn't expect there to be that much variation . But sounds like in the thousands is not unreasonable .
What "issue" are you facing...
August 2, 2011 at 12:26 pm
Why does it have to be SSIS?
in t-sql we can use the "FOR XML" option which converts the whole table for you.
SELECT * FROM sys.tables FOR XML AUTO
August 2, 2011 at 12:25 pm
Viewing 15 posts - 3,946 through 3,960 (of 18,926 total)