Forum Replies Created
Viewing 15 posts - 2,416 through 2,430 (of 7,631 total)
-
RE: Finding the average response time of a query.
RBarryYoung (5/13/2009)
nabeelmukhtar (5/13/2009)
Just found out that both sys.dm_exec_sessions and sys.dm_exec_requests return incorrect total_elapsed_time for parallel queries (requests with parallel execution plans). Is this a defect or a misunderstanding on my...[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font] -
RE: Data Loading error
calibar2k (5/13/2009)
HiI created a dtsx package for bulkload, it is a huge data more than a million records in the text file. After loading 200000
there showing following error:
Data conversion...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font] -
RE: Error during inserting records
petersobeco (5/13/2009)
Hi, Still this script is not working and not able to insert records into 'GSK_Reenrolment' table. Please advise. Thanks.Well I'm a pretty good guesser but I'm afraid that you'll...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font] -
RE: derived column trimming leading zeros
Rich96 (5/13/2009)
RBarryYoung (5/13/2009)
That will remove all of the zero characters from [Account] if account is a string. Is that what you wanted to do?If your intent was to change all...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font] -
RE: Where clause on converted datatype
john.arnott (5/13/2009)
**** sigh. Spent too much time making up examples, so RBarry beat me to the answer....Here 'tis anyway****...
Heh, I've been there too John. 🙂 Besides, really...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font] -
RE: Advice needed on data warehousing strategy
SOP on this would be SSIS, though there are some other ways to go.
Replication does not seem like a good choice as what you really need to do is to...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font] -
RE: need help in looping records
Anjana (5/13/2009)
i tried this,,,,Insert Into tPM_Cmptc_Cat_Skill_Codes (compcatidno, skillcodeidno, fromeffectdate, toeffectdate)
select '-10001', a.skillcodedomainidno, a.skillcodefromeffectdate, a.skillcodetoeffectdate
From tskill_codes a
Where a.skillcodeidno in (Select *
from tskill_codes a
Where a.skillcodeidno not in...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font] -
RE: Need help breaking "bad habit"
More to the point, you need to get management backing on this. Big time. In fact, you need to get a manager to champion it because this is...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font] -
RE: derived column trimming leading zeros
Rich96 (5/13/2009)
I probably didn't make myself clear. I'm using the Derived Column Transformation Editor.
Actually I had assumed that since this is the SSIS forum. In any event, that...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font] -
RE: Where clause on converted datatype
Try this
LIKE '%3'You have to have wildcards on any unanchored sides. Also, the LIKE wildcards are "%" and "_", not "*" and "?" as you would use for filenames.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font] -
RE: derived column trimming leading zeros
That will remove all of the zero characters from [Account] if account is a string. Is that what you wanted to do?
If your intent was to change all of the...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font] -
RE: In operand
Of course if you're lazy like me, you can just do this:
create procedure ....
@codes varchar(50)
select *
from myTable
where Charindex(','+myTable.code+',', ','+@codes+',') > 0
True, this pretty much forces a table scan, but...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font] -
RE: Paging Problem SQL 2005 using row_number and order by
Nish (5/13/2009)
Ray Laubert (5/13/2009)
Create a view with out the order by. Then select from the view and order by the results. That should work.I've heard that views are...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font] -
RE: Paging Problem SQL 2005 using row_number and order by
Nish (5/13/2009)
Sorry for not explaining properly,To sort on Jobcount , i have to write "(ORDER BY j.JobCount)" , but as you said datatable does not know the table prifix, same...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font] -
RE: Bad habit #2: Prod data -->> dev, test databases
The issue isn't just the possible sensitivity of the production data, it's also the fact that you cannot do regression testing on data sets that are not fixed.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 15 posts - 2,416 through 2,430 (of 7,631 total)