Viewing 15 posts - 16,891 through 16,905 (of 19,560 total)
Nice article Wayne. I've told you that already - but now it is posted with the article too 😀
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
March 3, 2010 at 12:51 pm
Nice one.
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
March 3, 2010 at 12:46 pm
tmacs33 (3/3/2010)
Forum Moderator, as a side note, I REALLY liked a question a few days ago that was a .jpg so users couldn't copy and paste the response. That...
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
March 3, 2010 at 11:28 am
Chad Crawford (3/3/2010)
I do have a question 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
March 3, 2010 at 11:25 am
Chris Houghton (3/3/2010)
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
March 3, 2010 at 11:23 am
Lynn Pettis (3/3/2010)
First, it is obvious that this question was directed to SQL Server 2005/2008 because of the CTE....
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
March 3, 2010 at 11:15 am
bitbucket-25253 (3/3/2010)
kaspencer
Your reputation is now properly in the gutter.
Remember that this should be a group of professionals, and trash talk is not appropriate, nor appreciated by those of us...
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
March 3, 2010 at 11:15 am
jncarter (3/3/2010)
SQL 2000 Standard only supports 2GB. It does not support AWE. If you need more than 2GB you will need to use Enterprise Edition or upgrade to 2005/2008.
Ah...
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
March 3, 2010 at 10:31 am
Paul White (3/3/2010)
Oh, and hey, Steve, do you really hand-convert Word articles to use that horrible XStandard thing? I just tried it with my two articles. Four hours...
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
March 3, 2010 at 9:28 am
Yes. Applications can also suffer from too many VLF's.
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
March 2, 2010 at 7:42 pm
calico-604598 (3/2/2010)
In witch situations having a large trx-log size can affect performance ? Replication ???
Note : I am NOT talking about the performance degradation when the trx-log...
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
March 2, 2010 at 6:31 pm
Jpotucek (3/2/2010)
Msg 102, Level 15, State 1, Procedure sp_ScriptRoles, Line 4
Incorrect syntax near '?'.
Msg 137, Level 15, State...
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
March 2, 2010 at 6:30 pm
nice solution
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
March 2, 2010 at 5:09 pm
AWE is for SQL Server and will depend on the version of SQL server you are using (32 bit or 64 bit). You will need to enable AWE 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
March 2, 2010 at 4:49 pm
I have seen plenty of implementations using this method. They seem to like it and it works well for them.
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
March 2, 2010 at 4:46 pm
Viewing 15 posts - 16,891 through 16,905 (of 19,560 total)