Forum Replies Created
Viewing 15 posts - 6,886 through 6,900 (of 7,631 total)
-
RE: getdate() accuracy
Thanks Ryan, that did 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] -
RE: Execute a Stored Proc as a background process
ALZDBA (5/18/2008)
rbarryyoung (5/17/2008)
Service Broker only works on SQL Express when it is connected to another SQL Server with a full license to Service Broker.SQL Server 2005 Features Comparison
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
states :
Service Broker
...
[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] -
RE: determing ERROR_PROCEDURE() without an error
Nice one, Jeff.
[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] -
RE: Recursive Queries in SQL:1999 and SQL Server 2005
Great Article!
[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] -
RE: getdate() accuracy
yeah, I can't figure out why though. I've got the right address in the IFcode, but somehow its coming out with this rogue pointer.
Here's what I put in:
[font="Times New...
[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] -
RE: How to find long queries on SQL Server 2005
You could start with this:
select s.text,
P.*
from master..sysprocesses P
Cross apply fn_get_sql(sql_handle) s
though you will get better info from a profiler sessions.
[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] -
RE: getdate() accuracy
Yeah? Well let's jst see what happens when we extract your avatar and uncover the hidden right side:
Ha! I knew 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] -
RE: SQL Server 2005 TCP Settings
sarkisp (5/16/2008)
I have restarted server, i have opened port on router and firewall ( I have also disabled firewall), I have changed port while connecting to server. According Microsoft docs...[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] -
RE: SQL Server never starts
Write a NET.BAT file like this:
ECHO Hi!
And put it in the default directory of your xp_CmdShell command.
[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] -
RE: Connections
I get this once in a while myself and (for me) it has always turned out to be a domain trust/authorization problem. YMMV.
[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] -
RE: Execute a Stored Proc as a background process
Service Broker only works on SQL Express when it is connected to another SQL Server with a full license to Service Broker.
[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] -
RE: determing ERROR_PROCEDURE() without an error
I don't think that you can get this.
I always just set a variable at the beginning of my stored procedures:
Declare @ProcName varchar(64)
Set @ProcName = 'spMy_SprocName'
...
Print @ProcName
...
[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] -
RE: sum(),Cummulative addition,Case statement
Jeff, couldn't you use MAX(CAST(RestrictedID as int)) instead of SUM(SIGN(..))?
[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] -
RE: Calling an external dll written in native code from a CLR stored proc.
Let us know how it works 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] -
RE: getdate() accuracy
Jeff Moden (5/16/2008)
Heh... what yellow dots?OK, now that's just wrong!
I'm keeping my eye(s) on you mister...
And don't think that I haven't noticed that your "No RBAR" avatar 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]
Viewing 15 posts - 6,886 through 6,900 (of 7,631 total)