Viewing 15 posts - 541 through 555 (of 19,560 total)
Lynn Pettis (4/6/2016)
Ed Wagner (4/6/2016)
Phil Parkin (4/6/2016)
Lynn Pettis (4/5/2016)
And now the attitude arrives.Check out the most recent 'I am proficient ...' comment. I nearly regurgitated my breakfast cereal.
Yeah, that was...
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
April 6, 2016 at 2:26 pm
Mighty (4/6/2016)
According to this article a temporary table can be partitioned:http://jasonbrimhall.info/2014/05/23/can-you-partition-a-temporary-table/.
So "Temporary tables cannot be partitioned" is not a limitation.
Thanks Mighty, morlindk and Steve for the call-outs to the...
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
April 6, 2016 at 1:53 pm
Luis Cazares (4/6/2016)
Koen Verbeeck (4/6/2016)
Boooo, temp tables can be partitioned.
So I guess BOL should be corrected?
You can create local and global temporary tables. Local temporary tables are visible only...
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
April 6, 2016 at 1:40 pm
haha - SQL Prompt helps give this one away far too easily.
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
April 5, 2016 at 3:23 pm
Welsh Corgi (4/5/2016)
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
April 5, 2016 at 12:18 pm
Grant Fritchey (4/5/2016)
SQLRNNR (4/5/2016)
Grant Fritchey (4/5/2016)
Phil Parkin (4/5/2016)
Gail and I are gamely persevering with this one. I think my pressure limit has been reached now, though.
Oh god...
"The delete works sometimes"
......
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
April 5, 2016 at 11:31 am
Ed Wagner (4/5/2016)
Grant Fritchey (4/5/2016)
SQLRNNR (4/5/2016)
Grant Fritchey (4/5/2016)
Phil Parkin (4/5/2016)
Gail and I are gamely persevering with this one. I think my pressure limit has been reached now, though.
Oh god...
"The delete...
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
April 5, 2016 at 11:23 am
Grant Fritchey (4/5/2016)
Phil Parkin (4/5/2016)
Gail and I are gamely persevering with this one. I think my pressure limit has been reached now, though.
Oh god...
"The delete works sometimes"
... Surely, please, tell...
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
April 5, 2016 at 11:05 am
Welsh Corgi (4/5/2016)
ok, I dropped the constraint but sometimes the error message does not include the table name.
Can you recreate the scenario where the error message does not include the...
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
April 5, 2016 at 10:59 am
Chad Crawford (4/4/2016)
SQLRNNR (4/4/2016)
Brandie Tarvin (4/4/2016)
jasona.work (4/4/2016)
Brandie Tarvin (4/4/2016)
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
April 4, 2016 at 3:57 pm
Brandie Tarvin (4/4/2016)
jasona.work (4/4/2016)
Brandie Tarvin (4/4/2016)
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
April 4, 2016 at 1:37 pm
crookj (4/1/2016)
DonlSimpson (4/1/2016)
TomThomson (4/1/2016)
Ed Wagner (4/1/2016)
SQLRNNR (4/1/2016)
conversationListen
hear
Fear
Dread
Locks
You know those things that mean contention on resources and a winner is chosen while the other becomes a victim?
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
April 1, 2016 at 9:36 pm
Ed Wagner (4/1/2016)
TomThomson (4/1/2016)
SQLRNNR (4/1/2016)
Why isn't the correct answer Hekaton?
It was when I picked it, has it changed since?
Since then some people have picked the mountain, so all the wrong...
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
April 1, 2016 at 9:26 pm
conversation
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
April 1, 2016 at 12:16 pm
Steve Jones - SSC Editor (4/1/2016)
Use the Oh-En-Oh-Eff-Eff switch.
Its not the
Eff-En-Eff-En-Oh-En
switch?
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
April 1, 2016 at 11:00 am
Viewing 15 posts - 541 through 555 (of 19,560 total)