Viewing 15 posts - 7,096 through 7,110 (of 7,631 total)
ksullivan (4/21/2008)
create table #xx (z1 varchar(10))
insert into #xx
select '00070111' union all
select '0001111' union all
select '00000111' union all
select '00040111' union all
select '00044111' union all
select '000001111'
select * from #xx
where convert(int,...
[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]
April 22, 2008 at 1:07 pm
Ron:
I am not convinced that that MS issue has anything to do with your problem since it was talking about assembly mismatches during serialization tasks.
I have sucessfully used SMO on...
[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]
April 22, 2008 at 1:02 pm
It should be released just like any other terminated process. Do you have reason to believe otherwise?
[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]
April 22, 2008 at 12:42 pm
peter Vramby (4/22/2008)
Memory\Page Faults/sec
average ...
[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]
April 22, 2008 at 12:37 pm
GSquared (4/18/2008)
[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]
April 22, 2008 at 12:28 pm
These forums work better if you ask a question.
[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]
April 21, 2008 at 2:15 pm
Also, you do not actually have Hard Page Faults listed anywhere in these statistics ("Page Reads/sec"). Pages/sec does not directly correspond with "Page Reads/sec" and a value of 40+...
[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]
April 21, 2008 at 2:06 pm
Something is wrong with these numbers. In particular:
peter Vramby (4/21/2008)
PhysicalDisk(0 C: )\% Idle Time1279.9485202866.299877PhysicalDisk(1 D: )\% Idle Time404.273847502866.033589
You shouldn't be getting Idle% greater than 100%. What is your...
[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]
April 21, 2008 at 1:58 pm
I have tried 2008 and I cannot find the Service Broker GUI. Can you point me to it?
Do you have any procs, functions, etc. that you use to make...
[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]
April 18, 2008 at 12:30 pm
I think that you would have you redefine the data after you pulled it out of the table/column by running it through a view or other virtual column that partitoned...
[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]
April 18, 2008 at 8:24 am
Jeff Moden (4/17/2008)
rbarryyoung (4/16/2008)
And now a word from our sponsors ...;)Heh... didn't mean too push the sponsor... and I wouldn't have if I never used it. :hehe:
Oh, I think it's...
[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]
April 18, 2008 at 8:17 am
Close, try this:
Replace(REPLACE(REPLACE(description, CHAR(13), ''), CHAR(10), ''), CHAR(9), '')
[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]
April 17, 2008 at 9:54 am
It usually depends on the size of the company and how many databases: If they do not have enough to justify a full-time dba-only, then they will split the job...
[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]
April 17, 2008 at 8:25 am
Jeff Moden (4/16/2008)
...
[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]
April 17, 2008 at 7:10 am
Drop the FK's
[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]
April 16, 2008 at 11:52 pm
Viewing 15 posts - 7,096 through 7,110 (of 7,631 total)