January 27, 2012 at 9:16 am
Jack Corbett (1/26/2012)
Okay, Jason don't report me. Just found this in an SP:
IF 1 = 1 -- Placeholder in case there is an actual conditional on this blockThere is code in the IF block, but I love stuff like this. I assumed the THREAD was safer than twitter.
Haha - I think I know which one you are talking about.
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
January 27, 2012 at 9:20 am
Roy Ernest (1/26/2012)
Somebody please put the brakes on the THREAD. It keeps moving from one random topic to another. It does not even care who gets run over with these topic changes.
Can't - moving forward as that corolla with bad brakes.
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
January 27, 2012 at 9:22 am
Evil Kraig F (1/27/2012)
Roy Ernest (1/26/2012)
Somebody please put the brakes on the THREAD. It keeps moving from one random topic to another. It does not even care who gets run over with these topic changes.VRRRRRMMMMM!!!!!
On yet another note, what is it, "Spoon Feed me my job" day?
Yes, yes it 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
January 27, 2012 at 9:31 am
GilaMonster (1/27/2012)
My favourite 'not enough information' recently was at SQLTeam. Question basically stated "The following code throws an error. Please helpDim CPDHourUpdate As SqlDataSource = New SqlDataSource() CPDHourUpdate.ConnectionString = ConfigurationManager.ConnectionStrings("Application").ToString() CPDHourUpdate.UpdateCommand = "UPDATE UserDetails SET CPD_Hours = CPD_Hours + 2 WHERE UserId = @userid" CPDHourUpdate.UpdateParameters.Add("UserId", Session("UserID").ToString()) Dim rowsAffected As Integer = CPDHourUpdate.Update()"
That's it, nothing else. Now the update looks syntactically valid, and I don't know VB enough to tell if there's something wrong with the rest. I asked for the error message and the table definition as without those I wouldn't be able to help.
The reply was "So don't answer then??? Just a suggestion...."
"Well, hmmm, if you really don't want me to help you then don't post a 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
January 27, 2012 at 9:36 am
Someone help me. My brain is leaking.
I think I need to stop answering forum questions for the day. My fingers and my head don't agree with each other, and neither is being very intelligent right now.
January 27, 2012 at 9:43 am
GSquared (1/27/2012)
sturner (1/27/2012)
GSquared (1/27/2012)
Stop trying to help them.
Personally, I am growing more and more fond of Celko's approach with each passing day.
I understand the temptation, truly do.
Just don't succumb to it.
Or (karma) next time you go to the doctor and say, "I'm not sure what's wrong, but I just don't feel good", he might prescribe cyanide. 😛
But the dark side is sooooo tantalizing
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
January 27, 2012 at 9:47 am
SQLRNNR (1/27/2012)
GSquared (1/27/2012)
sturner (1/27/2012)
GSquared (1/27/2012)
Stop trying to help them.
Personally, I am growing more and more fond of Celko's approach with each passing day.
I understand the temptation, truly do.
Just don't succumb to it.
Or (karma) next time you go to the doctor and say, "I'm not sure what's wrong, but I just don't feel good", he might prescribe cyanide. 😛
But the dark side is sooooo tantalizing
Speaking of which (sorry Roy), I just saw the commercial with the dogs barking the Imperial March for the first time last night, laughed my @$$ off, especially when the greyhound came out as the AT-AT!
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
January 27, 2012 at 9:59 am
jcrawf02 (1/27/2012)
SQLRNNR (1/27/2012)
GSquared (1/27/2012)
sturner (1/27/2012)
GSquared (1/27/2012)
Stop trying to help them.
Personally, I am growing more and more fond of Celko's approach with each passing day.
I understand the temptation, truly do.
Just don't succumb to it.
Or (karma) next time you go to the doctor and say, "I'm not sure what's wrong, but I just don't feel good", he might prescribe cyanide. 😛
But the dark side is sooooo tantalizing
Speaking of which (sorry Roy), I just saw the commercial with the dogs barking the Imperial March for the first time last night, laughed my @$$ off, especially when the greyhound came out as the AT-AT!
Very good commercial
http://www.youtube.com/watch?v=6ntDYjS0Y3w
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
January 27, 2012 at 10:05 am
That is excellent.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 27, 2012 at 10:11 am
The one at the end is awesome.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
January 27, 2012 at 10:20 am
Milestones on the horizon
Gail 30K points - currently 29,974
Paul 10K points - currently 9,932
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
January 27, 2012 at 10:23 am
I liked the last comment:
The bark side? is strong in this one
-- Gianluca Sartori
January 27, 2012 at 10:43 am
is this an all time 30 days record?
Show more
Top Members (last 30 days)
# Name Score 30 days All-time
1. Diane Fortin 2006 2006 SSCrazy
2. the_macabros 891 1052 Ten Centuries
3. GilaMonster 824 29974 SSChampion
4. Gary Varga 548 2718 SSCrazy
5. SQL Kiwi 542 9935 SSCrazy Eights
...
---------------------------------------------------------------------
January 27, 2012 at 10:49 am
george sibbald (1/27/2012)
is this an all time 30 days record?Show more
Top Members (last 30 days)
# Name Score 30 days All-time
1. Diane Fortin 2006 2006 SSCrazy
2. the_macabros 891 1052 Ten Centuries
3. GilaMonster 824 29974 SSChampion
4. Gary Varga 548 2718 SSCrazy
5. SQL Kiwi 542 9935 SSCrazy Eights
...
That happens a lot. People are going through the QOTD.
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
January 27, 2012 at 10:55 am
Anybody here backup with BizTalk?
http://www.sqlservercentral.com/Forums/Topic1242925-391-1.aspx#bm1242974
Viewing 15 posts - 34,021 through 34,035 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply