Viewing 15 posts - 52,576 through 52,590 (of 59,064 total)
You had all of that in your first post... obviously, you want some specific format and I'm tired of guessing...
Would you please type up what you want the output to...
February 11, 2008 at 9:54 pm
So, what is it that you want to do? You've identified everything but that...
February 11, 2008 at 9:35 pm
Instead of doing the FREEPROCCACHE thingy, which affects the whole server, just do a forced recompile in the proc. The other thing this sounds like is "Parameter Sniffing". ...
February 11, 2008 at 8:06 pm
You bet... let us know how it works out... tuning queries of this nature may take one of the items I listed... or all 6. Maybe even something else......
February 11, 2008 at 7:59 pm
Which row do you want to keep for each customer by campaignID?
Yes i want to keep campaign_id.
Well.... that's why you're getting the dupes in the results... You have dupes...
February 11, 2008 at 7:53 pm
...AND...
Until you figure out what made it grow that big to begin with, it's not gonna do you any good to shrink it because the same something is gonna make...
February 11, 2008 at 7:44 pm
If the file width is less than or equal to 255 characters, this is a very easy way to do what you ask...
[font="Courier New"]CREATE TABLE #MyFile (LineNum INT IDENTITY(1,1), MyText...
February 11, 2008 at 7:36 pm
I'm thinking a simple looping DOS batch file would work just fine... either that or maybe a simple VB script.
February 11, 2008 at 7:29 pm
WHAT do you mean by "Transaction ID"? Do you mean the level of nesting within the transaction or do you mean the IDENTITY number of a row you just...
February 11, 2008 at 7:25 pm
Post the table schema and the columns you would consider in deciding if a row where a duplicate or not... there's hardly any reason to go to text files and...
February 11, 2008 at 7:23 pm
Because of implicit conversions.
A better question would be...
... why are you copying INT data into an NVARCHAR column to begin with?
February 11, 2008 at 7:21 pm
itortu (2/11/2008)
i do have hu_id on the result dataset i pasted above.
Yes, you do... but not in the code you posted... we can't tell which table hu_id is in.
Also,...
February 11, 2008 at 7:16 pm
For starters, this....
WHERE CONVERT(VARCHAR, tblRFXProjecto.tmsCreated, 103) = CONVERT(VARCHAR, getdate()-1, 103)
... will not allow indexes to be used effectively because of the forced scan created by wrapping the column reference in...
February 11, 2008 at 7:09 pm
I guess my question would be....
... what in blazes do you think you need to do in a database that can't be done in T-SQL?
The only possible exception to that...
February 11, 2008 at 6:55 pm
Only way I can see that happening is if dbatools_filesize has two rows for each day for each database in it. Recommend you do a dupecheck to see...
February 11, 2008 at 6:49 pm
Viewing 15 posts - 52,576 through 52,590 (of 59,064 total)