Viewing 15 posts - 2,401 through 2,415 (of 7,631 total)
De Morgan's laws:
1)
IF (NOT A=B) OR (NOT C=D)
is the same as
IF NOT ( A=B AND C=D)
2)
IF (NOT A=B) AND (NOT C=D)
is the 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]
May 14, 2009 at 1:42 pm
Cwalton (5/14/2009)
I cant seem to ppost the XML correctly, I've added an attachment to show this.
You need to use the code tags: ..
[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]
May 14, 2009 at 1:22 pm
The right time to switch to stored procedures is as soon as you determine that it is going to be an actual application with actual users (as opposed to a...
[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]
May 14, 2009 at 1:18 pm
klnsuddu (5/10/2009)
Could you please anybody maintaining share point databases in sql server 2005, help me in creating multiple files for Content database, which is already in production with 70gb size....
[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]
May 14, 2009 at 11:51 am
Jeff Moden (5/14/2009)
Steve Jones - Editor (5/13/2009)
Ahhh, Klingons asking questions. About databases? Could be interesting....Heh... still not as bad as some of the questions folks ask on the forums. 😀
Steve...
[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]
May 14, 2009 at 11:13 am
Great!
[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]
May 14, 2009 at 11:07 am
That said, assuming that you cannot convert these to a more relational design, then your best approach is probably to parse the CSV field into a table variable or temporary...
[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]
May 14, 2009 at 11:04 am
bpowers (5/14/2009)
Lets say...
[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]
May 14, 2009 at 9:31 am
Good catch. Thanks for letting us know!
[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]
May 14, 2009 at 9:23 am
Alvin Ramard (5/14/2009)
Please try this and tell me what you get.
declare @CustomerRef as varchar(50)
set @CustomerRef = '00000012345678900'
select REPLACE(LTRIM(REPLACE(@CustomerRef,'0',' ')), ' ','0')
That won't work, Alvin. Rich is in 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]
May 14, 2009 at 9:20 am
jparra (5/14/2009)
Developers develop and their task is to meet functional requirements. This means that they can prove through each iteration of their development that functions / procedures / methods...
[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]
May 14, 2009 at 7:42 am
Actually, folks, I believe that Rich already said that he tried using a single space and it didn't work.
If I am reading the screen shot correctly, I think...
[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]
May 14, 2009 at 7:27 am
jparra (5/14/2009)
Barkingdog (5/13/2009)
Good point:Of course while it may not match production data RedGat'es data generator (and others) is a good start in my opinion.
Barkingdog
But that's the whole point, isn't it?...
[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]
May 14, 2009 at 7:17 am
ondrej.bouda (5/14/2009)
Malcolm Daughtree (5/13/2009)
[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]
May 14, 2009 at 7:13 am
If you want to capture this out-of-request, thought, Trace/Profile is about the only accurate option.
[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]
May 13, 2009 at 11:38 pm
Viewing 15 posts - 2,401 through 2,415 (of 7,631 total)