Viewing 15 posts - 10,156 through 10,170 (of 19,560 total)
Jeff Moden (5/9/2011)
SQLRNNR (5/7/2011)
GilaMonster (5/7/2011)
Jeff Moden (5/7/2011)
GilaMonster (5/6/2011)
Off to SQLSaturday, the first one in Africa
You can only say that once. I don't know if you had anything to do...
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 10, 2011 at 11:26 am
Thanks for the 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 9, 2011 at 12:13 pm
Tom.Thomson (5/7/2011)
I've seen more rain in the last two and a half days than in the previous five and a half months. I suppose I asked for it, coming...
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 8, 2011 at 3:40 pm
crookj (5/6/2011)
WOTD - noncoagulating(nose bleed yesterday that would not quit...)
Joe
cocaine - or silver nitrate (two usual treatments in ER for that)
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 8, 2011 at 10:17 am
GilaMonster (5/7/2011)
Jeff Moden (5/7/2011)
GilaMonster (5/6/2011)
Off to SQLSaturday, the first one in Africa
You can only say that once. I don't know if you had anything to do with it but...
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 7, 2011 at 12:43 pm
GilaMonster (5/6/2011)
Off to SQLSaturday, the first one in Africa
Just finished SQLSaturday in JHB - it was good. Well worth it:cool::cool::cool:
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 7, 2011 at 5:18 am
Nice 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 6, 2011 at 10:30 am
Thanks for the info Robert.
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 4:27 pm
try this instead
Insert Into Countings
Select 598,Count(*) from Transfer
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 3:40 pm
What is the error that you are receiving?
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 3:20 pm
I think one of the things to understand with services like what Amazon offers is to know all of your options within that service. If you have certain services...
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 3:16 pm
jpSQLDude (5/5/2011)
SQLRNNR (5/5/2011)
The arithmetic overflow occurs prior to the attempt to convert those ints to a bigint.Got it! That makes sense.
Thanx!
Good - you're welcome.
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 1:15 pm
sqlgirlatty (5/5/2011)
UPDATE ADDRESS
SET ADDRESS_STATE_ID = s.STATE_ID
FROM zipcode z
INNER JOIN state_ref s
ON s.STATE_ABBREV...
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 1:15 pm
In each of the first three you have ints doing the math. The arithmetic overflow occurs prior to the attempt to convert those ints to a bigint.
Thus by converting...
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 1:01 pm
Sean Lange (5/5/2011)
Lowell you beat me to the punch again. 😛
Curses - i was in the reply window when you guys posted.
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:53 pm
Viewing 15 posts - 10,156 through 10,170 (of 19,560 total)