Viewing 15 posts - 10,171 through 10,185 (of 19,560 total)
I would use this update statement instead
UPDATE ADDRESS
SET ADDRESS_STATE_ID = s.STATE_ID
FROM ADDRESS a
INNER JOIN zipcode z
ON a.ADDRESS_ZIPCODE_TXT = z.ZIP_CD
INNER JOIN state_ref s
ON s.STATE_ABBREV = z.STATE_CD
WHERE ADDRESS_STATE_ID IS...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 5, 2011 at 12:52 pm
Steve Jones - SSC Editor (5/5/2011)
Craig Farrell (5/4/2011)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 5, 2011 at 10:46 am
DSR0308 (5/5/2011)
thank you everyone for their help, GSquared solution did it for me.
Good to know. Congrats on getting it working.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 5, 2011 at 10:15 am
Daniel Bowlin (5/5/2011)
crookj (5/5/2011)
Brandie Tarvin (5/5/2011)
WOTD: InvariablyWOTD - Habitually
Joe
monotonous
polyotonous
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 5, 2011 at 10:11 am
Lowell (5/5/2011)
create...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 5, 2011 at 9:57 am
That's good to hear. Glad you found and fixed it. I would recommend getting that application off of using the sa account.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 5, 2011 at 9:54 am
habitually
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 5, 2011 at 7:53 am
See if this article helps.
http://sqlblog.com/blogs/eric_johnson/archive/2008/09/30/scripting-sql-server-logins.aspx
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 4, 2011 at 9:52 pm
WayneS (5/4/2011)
Jeff Moden (5/4/2011)
Nicely done, Nadrek!
Yes indeed, very nice!
The cool part about all of this is if you run into a DBA that won't allow auxiliary tables such as...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 4, 2011 at 9:45 pm
WayneS (5/4/2011)
Jeff Moden (5/3/2011)
What I find really strange is why do people wait until I write an article to bring these wonders forward? 😛
To go along with this... where...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 4, 2011 at 9:44 pm
I like it too. I also like that the R2 doc seems better written on this topic than the SQL 2008 doc
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 4, 2011 at 9:40 pm
Excellent question.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 4, 2011 at 9:11 pm
Dan.Humphries (5/4/2011)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 4, 2011 at 8:33 pm
You can connect visual studio to mercurial / svn
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 4, 2011 at 11:52 am
ColdCoffee (5/4/2011)
DECLARE @Today DATETIME = DATEADD( DD , DATEDIFF(DD,0,GETDATE()),0),
@ThisDayLastYR DATETIME
SELECT @ThisDayLastYR = DATEADD( YEAR , -1,@Today)
select @Today , @ThisDayLastYR
SELECT
DimGeography.GeographyKey,...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 4, 2011 at 11:47 am
Viewing 15 posts - 10,171 through 10,185 (of 19,560 total)