Viewing 15 posts - 6,376 through 6,390 (of 7,636 total)
Jeff Moden (3/4/2008)
I don't know what I'd do for testing if NEWID() wasn't available...
Oh, I'm sure that Matt or Gus or I could whip up something in CLR. 😀
And 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]
July 6, 2008 at 9:32 pm
And if you need two random values on the same row, either select the View or function twice, or change the view to have two columns, each calling NewID().
[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]
July 6, 2008 at 9:29 pm
Heh. I always just Google 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]
July 6, 2008 at 7:16 pm
sqluser (1/24/2008)
In CLR, if i create a Procedure with the use of an Assesbly that Procedure is being locked. After...
[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]
July 6, 2008 at 1:49 pm
Vijaya Kadiyala (7/6/2008)
HiCheck out the below link
http://support.microsoft.com/kb/q139444/
http://www.sql-server-performance.com/articles/dev/dv_delete_duplicates_p1.aspx
Thanks -- VJ
Why?
[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]
July 6, 2008 at 11:20 am
Without being to specific then, I think that you need to review this design and rethink some parts of it.
In a typical design, you should have one or more tables...
[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]
July 6, 2008 at 11:13 am
Jeff Moden (7/5/2008)
dakshinamurthy (7/5/2008)
I would also helpfull if i get to know what to do if we exceed the seed value for a bigint field in a table
If you exceed...
[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]
July 5, 2008 at 10:39 pm
So far as I know, the only reliable way is:
Select * From sys.databases Where [name] NOT IN ('master', 'tempdb', 'model', 'msdb')
[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]
July 5, 2008 at 10:04 pm
Jeff Moden (7/5/2008)
rbarryyoung (7/5/2008)
Well, off the top of my head: I always put the Operators in front (and comma is the column-list concatenation operator) because:
I agree that operators should...
[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]
July 5, 2008 at 9:30 pm
The first sentence of the 3rd page of your assignment sheet says:
The following should be an individual piece of work.
Before we go any further, I strongly recommend that you...
[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]
July 5, 2008 at 7:54 pm
Well, off the top of my head: I always put the Operators in front (and comma is the column-list concatenation operator) because:
1) in some cases, like FROM clauses 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]
July 5, 2008 at 5:53 pm
While that is a personal preference of mine, I do have practical reasons for it also. 😀
[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]
July 5, 2008 at 4:47 pm
Any reason you cannot just post it here as an attachment?
That way we can see what this is before we make a commitment to you.
[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]
July 5, 2008 at 4:43 pm
OK, I've cleaned up the syntax of this so that it is much easier to read, including removing all of the "dbo."'s that were just eye clutter and changing 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]
July 5, 2008 at 1:22 pm
Well my first suggestion is to stop using Query Wizard, because it makes it really easy to make really bad and ugly queries like this.
Secondly, to do anything with 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]
July 5, 2008 at 12:04 pm
Viewing 15 posts - 6,376 through 6,390 (of 7,636 total)