Viewing 15 posts - 6,586 through 6,600 (of 7,631 total)
I think that you're missing something from your new Install or it lost the location of something.
[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]
June 18, 2008 at 8:44 pm
GSquared (6/17/2008)
...are all considered deterministic by SQL Server, butDatepart(Weekday, date)
is not.
Neither are:
dateadd(day, '12/30/1899', date)%7
cast(date as float)%7
cast(date as int)
Aren't the first two affected by configuration settings on the server or instance?
[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]
June 18, 2008 at 8:36 pm
Check out the IS_MEMBER() function in books on line. If you know what explicit groups you want to check for, this will do it.
If you need an actual list...
[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]
June 18, 2008 at 8:31 pm
Jeff Moden (6/18/2008)
rbarryyoung (6/18/2008)
Jeff Moden (6/18/2008)
Easy to print? They contain CR/LF's... should print just fine if you display them in a text mode instead of a grid mode...
Well, sort...
[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]
June 18, 2008 at 7:52 pm
Matt, Jeff:
FYI, I've already used this trick today to put up a "quick & dirty" Service Broker monitor. sweet...
Thanks again,
[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]
June 18, 2008 at 4:50 pm
Glad I could help.
[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]
June 18, 2008 at 4:45 pm
Oh, and that's another thing that I discovered today: They do not ALL contain CR/LF's. Some of them contain just LF's! That's a nice little inconsistency.
[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]
June 18, 2008 at 4:21 pm
Jeff Moden (6/18/2008)
Easy to print? They contain CR/LF's... should print just fine if you display them in a text mode instead of a grid mode...
Well, sort of. There'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]
June 18, 2008 at 4:18 pm
OK, fair enough, I can see that is was not caught up to the changes that you were making.
To answer your question then: from a performance standpoint, 2 different version...
[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]
June 18, 2008 at 6:09 am
Carl Federl (6/17/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]
June 17, 2008 at 11:21 pm
Jeff Moden (6/17/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]
June 17, 2008 at 11:17 pm
This works, though I honestly have no idea why:
select T.Loc.value('(/XML/Institution/@Id)[1]','uniqueidentifier') AS [Institution]
, t.Loc.query('.').value('(/User/Email)[1]','varchar(128)') AS [Email]
, t.Loc.query('.').value('(/User/BusinessRoleGuid)[1]','uniqueidentifier') AS [BusinessRoleGuid]
FROM @x.nodes('/XML/Institution/Users/User') AS T(Loc )
🙁 *sigh* XML queries just remain so...
[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]
June 17, 2008 at 4:35 pm
rbarryyoung (6/17/2008)
Ah, it's SQL, not CLR...
Du'h, it's not the SQL2005 forum... :blush:
[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]
June 17, 2008 at 11:12 am
Ah, it's SQL, not CLR. It looks like the Triangular Concatentation problem (ie., sequential cumulative string concatenation is O(n2), esp. with immutable strings), which is solvable in CLR, 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]
June 17, 2008 at 11:09 am
Jeff Moden (6/17/2008)
rbarryyoung (6/17/2008)
I think that you have to at a minimum include '. + -' in that list.And, a decimal point...
it's in there, it's just hard to see... 🙂
[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]
June 17, 2008 at 11:04 am
Viewing 15 posts - 6,586 through 6,600 (of 7,631 total)