Viewing 15 posts - 931 through 945 (of 7,631 total)
Kevin Rathgeber (2/18/2010)
This was more a warning for those who...
[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]
February 18, 2010 at 9:57 am
I guessing that it's because you have no table nor table alias named "tEx".
[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]
February 18, 2010 at 9:46 am
athornicroft (2/18/2010)
Hi there is a good thread here about eliminating cursors without the use of sub queries.
It is a myth that subqueries are necessarily a bad thing.
[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]
February 18, 2010 at 9:37 am
Dynamic SQL is not preferred, but saying that it should be "avoided at all costs" is far too strong and just is not correct. There are many, many situations...
[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]
February 18, 2010 at 9:34 am
Leon Orlov-255445 (2/18/2010)
Have anybody were successful in attempt to modify SQL Server 2008 'system stored procedure'?
Lets say that for some really insane reason you want to modify 'system stored...
[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]
February 18, 2010 at 9:27 am
Variables in T-SQL are batch-scoped. They go away when the batch that created them does. Note that stored procedures executions are batches.
(edit: improved wording to be less ambiguous)
[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]
February 18, 2010 at 9:22 am
So, should we uncomment them? Because if I leave them commented, then its not doing very much.
[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]
February 18, 2010 at 9:13 am
tstaker (2/18/2010)
jcrawf02 (2/18/2010)
Grant Fritchey (2/18/2010)
[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]
February 18, 2010 at 9:06 am
IMHO, you should know and understand the normalization rules up to 5th Normal Form (or at least Boyce-Codd). Most "acceptable" data designs are at least 3rd Normal Form. ...
[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]
February 18, 2010 at 5:31 am
Alvin Ramard (2/17/2010)
RBarryYoung (2/17/2010)
CirquedeSQLeil (2/17/2010)
74% incorrect for Paul Randal's question on Checksum. Numbers are similar to his question the other...
[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]
February 17, 2010 at 6:13 pm
Give us the whole error message please. Also we need a version of your query that can reproduce the problem. Having "blah blahblah" in there makes it impossible...
[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]
February 17, 2010 at 6:06 pm
FYI: I think that you used a [ quote ] tag in your post when you meant to use a [ code="sql" ] tag.
[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]
February 17, 2010 at 6:03 pm
CirquedeSQLeil (2/17/2010)
Has anyone noticed the success/failure rate on the QOD today?74% incorrect for Paul Randal's question on Checksum. Numbers are similar to his question the other day.
The Correct% always...
[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]
February 17, 2010 at 5:56 pm
Why are all of the INSERTs and UPDATEs commented out?
[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]
February 17, 2010 at 5:07 pm
Also, you cannot do variable assignments "bare" in T-SQL, you have to put a "SELECT " in front.
Like:
SELECT @myVariable = @someOtherVariable
[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]
February 17, 2010 at 12:49 pm
Viewing 15 posts - 931 through 945 (of 7,631 total)