Viewing 15 posts - 8,326 through 8,340 (of 19,560 total)
The role should define the set of permissions. With different permissions requirements in different environments, we just follow the documented roles (for audit purposes) and just make sure not...
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
October 10, 2011 at 10:11 pm
richa.gupta (10/10/2011)
FOR XML could not serialize the data for node 'processing-instruction(definition)' because it contains a...
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
October 10, 2011 at 1:16 pm
GSquared (10/10/2011)
Grant Fritchey (10/10/2011)
GSquared (10/10/2011)
GilaMonster (10/10/2011)
Be nice.YOU'VE BEEN WARNED!!!
😀 😛 😛 😀
She's an ED-9000.... You have 15 seconds to comply... 10 seconds... 5 seconds...
The computer is my friend.
The computer wants...
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
October 10, 2011 at 12:38 pm
Here is a thread where that topic was discussed
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
October 10, 2011 at 12:33 pm
Kiara (10/10/2011)
Roy Ernest (10/10/2011)
I am here at the pre-con of Gail and Grant. This is going to be fun. 🙂 Information overload.*jealous*
That's why I encourage them to heckle on our...
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
October 10, 2011 at 11:29 am
The generalization is fine - more memory is generally good. Before throwing more money and hardware at a problem though, optimizing is the best rule of thumb.
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
October 10, 2011 at 10:56 am
HowardW (10/10/2011)
[sessdata] [ntext] NULL,
This is a LOB. You must have more data in this column on average than you did on your test environment.
This column can store up to...
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
October 10, 2011 at 10:42 am
MysteryJimbo (10/10/2011)
What is stored in the ntext column? That will be the cause
Definitely.
By default NTEXT stores the text value in the LOB structure and the table structure...
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
October 10, 2011 at 10:42 am
All you can do is as Gail said - wait for the rollback to finish.
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
October 10, 2011 at 10:17 am
GilaMonster (10/10/2011)
Be nice.
big teddy bear wayne is nice - and he can be nice when he heckles 😀
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
October 10, 2011 at 10:16 am
That depends - do you have an MSDN subscription? If not, then they are evals. If you have an MSDN subscription, then it depends on your level 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
October 10, 2011 at 10:15 am
Dude63 (10/10/2011)
Daniel Bowlin (10/10/2011)
Obfuscatedata privacy
Data piracy
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
October 10, 2011 at 10:12 am
Roy Ernest (10/10/2011)
SQLRNNR (10/10/2011)
Roy Ernest (10/10/2011)
I am here at the pre-con of Gail and Grant. This is going to be fun. 🙂 Information overload.Please heckle like crazy
Wayne is going to...
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
October 10, 2011 at 9:32 am
Roy Ernest (10/10/2011)
I am here at the pre-con of Gail and Grant. This is going to be fun. 🙂 Information overload.
Please heckle like crazy
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
October 10, 2011 at 9:25 am
Revenant (10/10/2011)
SQLRNNR (10/10/2011)
planbehind
aside
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
October 10, 2011 at 9:13 am
Viewing 15 posts - 8,326 through 8,340 (of 19,560 total)