Viewing 15 posts - 2,446 through 2,460 (of 7,631 total)
A datetime datatype has no internal format or representation distinctions AFAIK, they're all the same. More likely, there is another column that it is using to keep track of...
[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 7:23 am
Great article Perry! And very useful given the trend toward virtualization these days.
[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 7:20 am
karthikeyan (5/12/2009)
We are planning the db migration from sqlserver 2000 to sqlserver 2005 in one of our production box soon.
We are going for backup and restore option.
Please help me...
[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 12, 2009 at 11:31 pm
emzero (5/12/2009)
Let's say we have:
A->B->C->A
...
So this approach doesn't work well with cyclics. In fact, it doesn't work at all because it's getting into...
[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 12, 2009 at 11:27 pm
Paul White (5/12/2009)
RBarryYoung (5/12/2009)
There are only three non-printable control-characters allowed. Guess which three they are? 🙂ROFL! :w00t:
Heh. Yeah, well they did except those three for a reason....
[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 12, 2009 at 11:21 pm
Like this:
...
Declare @sql as Varchar(MAX)
Select @sql = 'DELETE FROM '+@WE_ClientCode+'_ReEnrolment;'
+' INSERT INTO '+@WE_ClientCode+'_ReEnrolment ;'
+' SELECT EmpID, Sin FROM '+@tbCueUp+';'
EXEC(@sql);
...
[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 12, 2009 at 11:20 pm
UMG Developer (5/12/2009)
Paul White (5/12/2009)
Jeff Moden (5/12/2009)
If anyone knows what the ".VALUE trick" that UMG was talking about is, I'm all ears, thank you. :w00t:
I believe he is referring 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]
May 12, 2009 at 11:13 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]
May 12, 2009 at 11:10 pm
FYI, then this problem is called a "Topological 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]
May 12, 2009 at 11:03 pm
Yes, the problem is right here:
...
DELETE FROM + @WE_ClientCode + '_ReEnrolment '
INSERT INTO + @WE_ClientCode + '_ReEnrolment '
SELECT EmpID, Sin FROM @tbCueUp
...
You cannot use 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 12, 2009 at 11:01 pm
Which is it, a multi-parent tree or a digraph? They are not the same thing.
In particular, a multi-parent tree would be a digraph that is connected and has no...
[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 12, 2009 at 10:02 pm
naveenreddy.84 (5/12/2009)
Further, also let me know in which scenario the CLR based stored proceduers, triggers etc implemention are used.
The three general cases for SQLCLR use are:
1) Access to external...
[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 12, 2009 at 9:57 pm
Well it still seems like something is missing, but this code does what you have specified:
;WITH cteBinary as (
Select
SUM(
Case [status]
When 1 Then Power(2, ResID)
Else 0...
[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 12, 2009 at 9:47 pm
Jeff Moden (5/12/2009)
Heh... get any on ya, Barry? 😛
Snacks for later. 😀
[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 12, 2009 at 9:30 pm
Try using dynamic SQL to do this.
[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 12, 2009 at 8:44 pm
Viewing 15 posts - 2,446 through 2,460 (of 7,631 total)