Viewing 15 posts - 5,971 through 5,985 (of 7,631 total)
Actually, you DID get an answer at your original post.
[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]
August 10, 2008 at 6:40 am
Mscode_Pro (8/10/2008)
The table is not exist in Master Tables, and if it exists what the structure of it to make the query works???
It must exist in MASTER or else 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]
August 10, 2008 at 6:21 am
Select * from sys,procedures
[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]
August 9, 2008 at 10:59 pm
Try this:
CREATE TRIGGER mytrigger ON mytable
AFTER UPDATE AS
Declare @UpdateBits int
Declare @Mask9to18 int--set mask for bits 9 to 18
Set @Mask9to18 = 512|1024|2048|4096|8192|16384|32768|65536|131072|262144
Set @UpdateBits = Cast(COLUMNS_UPDATED() as int) & @Mask9to18
IF @UpdateBits >...
[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]
August 9, 2008 at 10:35 pm
and i want to know why the master database make it works?????????
Because Emp_Inf table is defined differently in MASTER than is is in your other database(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]
August 9, 2008 at 9:29 pm
shamshad.ali (8/9/2008)
The problem is I have to "Find DISTINCT SPECIAL characters in column [NTLogin]"
The problem is that "DISTINCT SPECIAL" does not really mean anything. What you call special is...
[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]
August 9, 2008 at 9:36 am
mstrong86 (8/9/2008)
Another thing to keep in mind is that not all cursors are bad- it's possible that they are the appropriate tools to use for the task at hand.
No, they're...
[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]
August 9, 2008 at 9:23 am
Like this:
INSERT INTO FooTable (Col_X, Col_Y, Col_Z)
SELECT Expression_1, Expression_2, Expression_3
FROM FooTable
WHERE SomeCondition_A
AND SomeCondition_B
[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]
August 9, 2008 at 7:54 am
By its very nature, SQL Server does not share well, especially memory. If you need it to leave space for IIS, then you will need to limit SQL Servers...
[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]
August 9, 2008 at 6:50 am
Atif:
These does not conform to the rulesfor Haiku. Haiku are supposed to consist of 3 lines, with 5 syllables in the first line, 7 syllables in the second...
[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]
August 9, 2008 at 5:54 am
bret.lowery (8/8/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]
August 8, 2008 at 4:13 pm
You should contact the Publisher.
[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]
August 8, 2008 at 2:25 pm
Thanks for the feedback, John.
[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]
August 8, 2008 at 1:19 pm
Thanks for the clarification guys.
[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]
August 8, 2008 at 1:18 pm
usman.tanveer (8/8/2008)
does the "sort in temp DB" option of index effects sorting performance??
Yes, that's why it is there. However, I believe that this is only used when rebuilding 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]
August 8, 2008 at 12:34 pm
Viewing 15 posts - 5,971 through 5,985 (of 7,631 total)