Viewing 15 posts - 2,641 through 2,655 (of 19,560 total)
Lynn Pettis (7/15/2014)
Jeff Moden (7/15/2014)
GilaMonster (7/15/2014)
Ah, why not(link to one of my later posts in the thread, but you can just scroll up)
You're right. Pork chops won't work there....
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
July 15, 2014 at 7:35 pm
Lynn Pettis (7/15/2014)
GilaMonster (7/15/2014)
Lynn Pettis (7/15/2014)
Whose turn with the silver spoon??Sorry, mine's already packed.
And I left mine back in the States. Didn't want to chance losing it here in...
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
July 15, 2014 at 2:27 pm
Interesting question.
It seems this would not be an issue if tinyint supported signed values.
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
July 15, 2014 at 8:22 am
Steve Jones - SSC Editor (7/15/2014)
Miss me?
Has it been six weeks already?
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
July 15, 2014 at 7:34 am
Revenant (7/14/2014)
Ed Wagner (7/14/2014)
SQLRNNR (7/14/2014)
BWFC (7/11/2014)
Venusdesire
Want
Wanton
Pork
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
July 14, 2014 at 12:51 pm
BWFC (7/11/2014)
Venus
desire
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
July 14, 2014 at 10:57 am
Thanks for the question. It'd be nice to see more PoSH questions.
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
July 14, 2014 at 8:34 am
Grant Fritchey (7/12/2014)
Just bumped by Gus on the Total Points board. Still behind him on the forum posts count.
Nice SQL Bump
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
July 14, 2014 at 7:48 am
Lynn Pettis (7/13/2014)
Love those problems that go like this:OP: I have a problem (explains problem)
Forgot to mention he laid down on the couch while somebody in the room nodded their...
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
July 14, 2014 at 7:43 am
In response to the original question, yes I have had several clients run checkdb nightly on their TB+ databases. 3.5-4hrs was normal.
There is a tweak that can be made...
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
July 10, 2014 at 11:31 am
One of the things that can cause that is a bug. http://www.sqlskills.com/blogs/paul/missing-index-dmvs-bug-that-could-cost-your-sanity/
The other is that the sort order needs to be changed. You can check the sort order.
56% can...
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
July 10, 2014 at 11:16 am
Grant Fritchey (7/10/2014)
SQLRNNR (7/10/2014)
Grant Fritchey (7/10/2014)
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
July 10, 2014 at 11:07 am
Ed Wagner (7/10/2014)
crookj (7/10/2014)
Ed Wagner (7/10/2014)
BWFC (7/10/2014)
Stuart Davies (7/10/2014)
Ed Wagner (7/9/2014)
crookj (7/9/2014)
sing4you (7/9/2014)
Sean Lange (7/9/2014)
Ed Wagner (7/9/2014)
SQLRNNR (7/9/2014)
gefilteFish (yuck)
haggis
entrails
viscera
Intrinsic
Essential
Required
Verify
Authenticate
Authorize
posterize
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
July 10, 2014 at 8:05 am
Grant Fritchey (7/10/2014)
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
July 10, 2014 at 8:03 am
Andy Warren (7/10/2014)
Jason, there is also the corresponding import column, so overall they make it pretty easy to import/export blobs.
I might someday have to try that. It could potentially...
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
July 10, 2014 at 7:57 am
Viewing 15 posts - 2,641 through 2,655 (of 19,560 total)