Viewing 15 posts - 8,926 through 8,940 (of 19,560 total)
This should help explain the issue you are seeing.
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
August 24, 2011 at 8:00 am
Be nice to them. Try to help them if you can. Also try to remind them of your focus and projects and deadlines you may be facing. ...
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
August 23, 2011 at 11:05 pm
What kind of indexes do you have on that table?
Also, you have by chance shrunk the database recently have you?
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
August 23, 2011 at 10:58 pm
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
August 23, 2011 at 10:55 pm
Typical failure reasons are data truncation or data type mismatch in the fields. make sure the fields line up properly for those that are failing.
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
August 23, 2011 at 10:52 pm
That has got to be an error in the data. Pop-tarts? Really?
I do agree that one should invest in writing better performing code. It just makes sense....
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
August 23, 2011 at 10:50 pm
This article should help you understand it.
http://www.sqlservercentral.com/articles/Transaction+Log/72488/
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
August 23, 2011 at 10:20 pm
Sadly, I think there is truth to this cartoon.
Ever been to a doctors office sitting in the exam room and seen another patients records on the screen?
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
August 23, 2011 at 9:43 am
shew (8/23/2011)
Presumably, most posters would have already tried Google and Books Online (as I have) prior to posting on this site.
As Gail said, not even a simple majority of posters...
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
August 23, 2011 at 9:26 am
Good 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
August 23, 2011 at 9:21 am
Christian Buettner-167247 (8/23/2011)
elbedata (8/23/2011)
Has this changed in later SQL versions? I am pretty sure...
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
August 23, 2011 at 9:20 am
fathom
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
August 23, 2011 at 8:21 am
Fal (8/23/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
August 23, 2011 at 8:20 am
Nice. I thought about removing that table variable altogether last night after I posted. I put it in because I was getting weird results. But the weird...
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
August 23, 2011 at 8:16 am
K - new post will be available @ 6:30am PDT on 8/23
http://jasonbrimhall.info/2011/08/23/tsql-sudoku-ii/
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
August 23, 2011 at 12:29 am
Viewing 15 posts - 8,926 through 8,940 (of 19,560 total)