Viewing 15 posts - 17,671 through 17,685 (of 19,560 total)
Good question indeed. I learned something today :w00t:
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
February 2, 2010 at 12:19 pm
lmu92 (2/2/2010)
sql_ques (2/2/2010)
SELECT LASTNAME FROM CPM.dbo.T_CANADIANWHERE '678567' BETWEEN '673001' AND '679000'
AND 'Z' BETWEEN 'P' AND 'P'
this worked.
I actually doubt that this query would return anything but an empty...
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
February 2, 2010 at 12:14 pm
Alvin Ramard (2/2/2010)
GilaMonster (2/2/2010)
http://www.sqlservercentral.com/Forums/Topic856902-145-1.aspx#bm857286
http://www.sqlservercentral.com/Forums/Topic475163-146-1.aspx#bm856344
http://www.sqlservercentral.com/Forums/Topic855771-360-1.aspx#bm855992
Am I...
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
February 2, 2010 at 12:13 pm
KlineandKing,
Do as Gail said. You need to wait out the rollback.
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
February 2, 2010 at 12:12 pm
GilaMonster (2/2/2010)
http://www.sqlservercentral.com/Forums/Topic856902-145-1.aspx#bm857286
http://www.sqlservercentral.com/Forums/Topic475163-146-1.aspx#bm856344
http://www.sqlservercentral.com/Forums/Topic855771-360-1.aspx#bm855992
Am I getting too...
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
February 2, 2010 at 10:45 am
Alvin Ramard (2/2/2010)
Roy Ernest (2/2/2010)
Alvin Ramard (2/2/2010)
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
February 2, 2010 at 10:33 am
tosscrosby-60625 (2/2/2010)
No, I am not from PETA but I read yesterady that waking the beast throws off his hibernation and can lead to starvation (not much growing around...
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
February 2, 2010 at 10:15 am
Florian Reischl (2/2/2010)
CirquedeSQLeil (2/2/2010)
That's not a good signI really think it will be a good day. However, today it's Groundhog Day in Punxsutawney 😉
I'll never forget this song:
I just discovered...
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
February 2, 2010 at 10:14 am
David Burrows (2/2/2010)
Alvin Ramard (2/2/2010)
Roy Ernest (2/2/2010)
This thread is going to get interesting. :hehe:
How new does someone have to be to not know substring functions and basic comparisons? Who's...
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
February 2, 2010 at 10:11 am
lmu92 (2/2/2010)
sql_ques (2/2/2010)
SELECT LASTNAME FROM CPM.dbo.T_CANADIANWHERE '678567' BETWEEN '673001' AND '679000'
AND 'Z' BETWEEN 'P' AND 'P'
this worked.
I actually doubt that this query would return anything but an empty...
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
February 2, 2010 at 10:10 am
mohammed.arsalan (1/31/2010)
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
February 2, 2010 at 12:37 am
motivation
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
February 2, 2010 at 12:17 am
That's not a good sign
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
February 2, 2010 at 12:14 am
I think this is a nice foundation script.
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
February 1, 2010 at 11:29 pm
lmu92 (2/1/2010)
The effect on a single company is minor, I think.
But it seems to be a trust/loyality issue between each of...
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
February 1, 2010 at 2:44 pm
Viewing 15 posts - 17,671 through 17,685 (of 19,560 total)