Viewing 15 posts - 2,281 through 2,295 (of 7,631 total)
AFAIK, the "compatibility level" is a syntax-only setting. That is, it only affects the T-SQL syntax recognized and implemented.
There are a very few other areas and tools on 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 25, 2009 at 9:24 am
I would suggest using either a command line or GUI SMTP tool on your server ot cinfirm that you can connect to your mailrelay and send mail outside of 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 24, 2009 at 11:19 pm
Could you post the code, please?
[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 24, 2009 at 9:44 pm
sridevi sriraman (5/24/2009)
My SSIS package is calling a stored procedure. When I change my stored procedure and then execute the package, there is no change. SSIS is doing 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]
May 24, 2009 at 9:35 pm
This BOL article has the list of all of the currency symbols that SLQ Server allows.
I say "allows" instead of "recognizes" because apparently it does not do anything...
[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 24, 2009 at 9:16 pm
Paul White (5/24/2009)
Lynn Pettis (5/24/2009)
Paul White (5/23/2009)
What is this "soccer" everyone keeps referring to? :laugh:
Well, it is what the rest of the world calls football or futbol. Sorry, 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]
May 24, 2009 at 6:38 am
Jeff Moden (5/23/2009)
http://support.microsoft.com/kb/136699
[font="Arial Black"]The Equi-Join and Natural Join[/font]
...
A natural join is one in which only...
[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 23, 2009 at 7:53 pm
Florian Reischl (5/23/2009)
...For batch processing you need to query "sys.dm_exec_sessions" instead of "sys.dm_exec_requests".
Could you explain that some more Florian? What kind of situation would you need to measure more...
[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 23, 2009 at 12:24 pm
Jeff: this is a typo, I think:
Jeff Moden (5/23/2009)
[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 23, 2009 at 10:27 am
bitbucket (5/23/2009)
RBarryYoung (5/22/2009)
bitbucket (5/22/2009)
For those old enough to remember Korean Peace Keeping otherwise known as the Korean War!!!
bitbucket, You're 75???
Nope not 75 ... born April 1932 ... which...
[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 23, 2009 at 10:20 am
bitbucket (5/22/2009)
For those old enough to remember Korean Peace Keeping otherwise known as the Korean War
!!!
bitbucket, You're 75???
[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 22, 2009 at 10:49 pm
sam (5/22/2009)
I want to know what happens when i append the recent backup file and when i overwrite the recent back up file? does both are same?
"Append" means to attach...
[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 22, 2009 at 6:20 pm
GilaMonster (5/22/2009)
RBarryYoung (5/22/2009)
[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 22, 2009 at 3:26 pm
Grant Fritchey (5/22/2009)
[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 22, 2009 at 3:09 pm
Jan Van der Eecken (5/22/2009)
Gianluca Sartori (5/22/2009)
Honestly, I would find paragraphs 2 and 3 quite offending if they were directed at me.
I'm sorry, I don't know English well enough 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 22, 2009 at 3:06 pm
Viewing 15 posts - 2,281 through 2,295 (of 7,631 total)