Viewing 15 posts - 2,086 through 2,100 (of 7,631 total)
ChrisMoix (6/12/2009)
I got an economics degree as an undergrad, and ended up falling backwards into an IT job ...
Hmmm, I don't think that most of us would call that "backwards"....
[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]
June 12, 2009 at 10:47 am
Grant Fritchey (6/12/2009)
RBarryYoung (6/12/2009)
Actually, MAXDOP = 1 is the Microsoft recommended setting for OLTP environments, especially heavily loaded ones.
Hey Barry, If you start working with spatial data in 2008, 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]
June 12, 2009 at 10:44 am
dougznospam-mailbox (6/12/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]
June 12, 2009 at 10:00 am
Glad I could help.
[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]
June 12, 2009 at 9:43 am
Nice writeup, Rick. You should consider submitting this as an article here.
[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]
June 12, 2009 at 9:14 am
Carl Federl (6/12/2009)
What you are requesting, a filtered index, is available under SQL Server 2008 but not under 2005 ...
Yeah, thats where I thought this was going too, Carl....
[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]
June 12, 2009 at 9:00 am
JKSQL (6/12/2009)
there would be one on filter = 0 and then one on filter = 1
The table probably should have been split but there is already...
[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]
June 12, 2009 at 8:52 am
mjarsaniya (6/12/2009)
Use information_schema.columns table you get most of from itlike table_name,column_name,max of length,is_nullable through which u can generate script easily..
In SSMS, right-click on the database, select Tasks.. Generate Scripts..
In 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]
June 12, 2009 at 8:47 am
???
At this point, I cannot honestly say that I understand what you are trying to do?
Are you trying to apply a Unique Constraint to only some of 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]
June 12, 2009 at 8:33 am
Glad I could help.
[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]
June 12, 2009 at 8:28 am
Just to clarify: MAXDOP (maximum degree of parallelism) does NOT restrict how many CPU cores a SQL Server instance can use at one time. Rather it only restricts how...
[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]
June 12, 2009 at 8:26 am
Actually, MAXDOP = 1 is the Microsoft recommended setting for OLTP environments, especially heavily loaded ones.
[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]
June 12, 2009 at 8:20 am
Try it like this:
DECLARE @VAR1 CHAR(20), @VAR2 CHAR(20), @VAR3 CHAR(20)
SET @VAR1='Variable1'
SET @VAR2='Variable2'
SET @VAR3='Variable3'
Select Distinct
SYS.User_Name0,
SYS.User_Domain0,
@VAR1 As [Var1],
@VAR1 As [Var2],
@VAR1 As [Var3],
MAX( CASE WHEN ENV.Name0 = @VAR1
THEN ENV.VariableValue0
END ) As [Value1],
MAX( CASE...
[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]
June 12, 2009 at 8:15 am
Crystal should be OK with your SP, as long as you just put the SELECT... at the end.
[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]
June 12, 2009 at 7:52 am
Grant Fritchey (6/12/2009)
RBarryYoung (6/12/2009)
Does anyone know...
[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]
June 12, 2009 at 7:40 am
Viewing 15 posts - 2,086 through 2,100 (of 7,631 total)